Examples of SQL and a checker:http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htmMysqli Prepare Statement Checker
This tool is to help debug SQL statements used in mysqli prepare statements. Enter your SQL, flags and variable that you would use in constructing your prepare statement below to see the SQL generated as well as any issues.
SQL:
INSERT INTO STATION VALUES (13, \'Phoenix\', \'AZ\', 33, 112); INSERT INTO STATION VALUES (44, \'Denver\', \'CO\', 40, 105); INSERT INTO STATION VALUES (66, \'Caribou\', \'ME\', 47, 68);
Issues:
More flags than variables. Less placeholders (?) than flags
SQL Query:
INSERT INTO STATION VALUES (13, \'Phoenix\', \'AZ\', 33, 112);
INSERT INTO STATION VALUES (44, \'Denver\', \'CO\', 40, 105);
INSERT INTO STATION VALUES (66, \'Caribou\', \'ME\', 47, 68);
Flags:
isd
Only use i, s, d or b. Check tool:
http://www.mustbebuilt.co.uk/apps/mysql-prepare-checker/enjoy, my good friends, enjoy,
polonus