Making PHP MySQL PDO easy
SELECT
SELECT multi-where's
INSERT
UPDATE
DELETE
Connection
MySQL SELECT statement
SELECT
(* for all or list columns)
FROM
(table name)
Leave the following empty if not needed:
WHERE
(column name)
Condition
(= > < like)
Value
(1 :value 'Gary')
ORDER BY
(column name DESC or ASC)
LIMIT
(amount of rows returned)
Create
MySQL SELECT multi where's statement
SELECT
(* for all or list columns)
FROM
(table name)
Leave the following empty if not needed:
WHERE
(column name)
Condition
(= > < like)
Value
(1 :value 'Gary')
Leave the following empty if not needed:
WHERE
(column name)
Condition
(= > < like)
Value
(1 :value 'Gary')
Leave the following empty if not needed:
WHERE
(column name)
Condition
(= > < like)
Value
(1 :value 'Gary')
ORDER BY
(column name DESC or ASC)
LIMIT
(amount of rows returned)
Create
MySQL INSERT statement
INSERT INTO
(tablename)
Number of values
(How many columns to insert data)
Create
MySQL UPDATE statement
UPDATE
(tablename)
Columns to update
(number of SET's)
Leave the following empty if not needed:
WHERE
(column name)
Condition
(= > < like)
Value
(1 :value 'Gary')
Create
MySQL DELETE statement
DELETE FROM
(tablename)
Leave the following empty if not needed:
WHERE
(column name)
Condition
(= > < like)
Value
(1 :value 'Gary')
Create
MySQL connection details
Host
Database
Username
Password
Create