Updated: 07/07/2004

Simple SQL

DESCRIPTION: Simple SQL provides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs. ADVANTAGES: - This PHP class file will eliminate nearly all code from the built in std mysql PHP functions. - Speed, it will dramatically decrease development and execution time. - Extremely easy to use; one hardly has to understand the MySQL syntax. - It automatically determines whether or not there is an open connection to the MySQL server. It will connect and reconnect automatically. - The built in debugging functions make it easy to solve syntax error and logic error. - Supports arrays for arguments and returns ASSOC arrays from the DB with indexes. - Stores resource links and common variables such as the last table used.

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Tags
  • and or not php,
  • arguments in php,
  • arrays,
  • class in php,
  • class php,
  • class php mysql,
  • code error sql,
  • code mysql php,
  • code sql,
  • column names in sql,
  • column names mysql,
  • column names sql,
  • connect mysql,
  • connect mysql php,
  • connect to mysql,
  • connect to mysql db,
  • connect to mysql php,
  • connect to mysql with php,
  • connection mysql php,
  • db links sql,
  • db php,
  • debugging php,
  • debugging php code,
  • debugging sql,
  • delete column sql,
  • delete file in php,
  • delete file php,
  • delete file php code,
  • delete file with php,
  • delete from mysql,
  • delete from mysql php,
  • delete from mysql table,
  • delete from sql syntax,
  • delete from table mysql,
  • delete from table sql,
  • delete in sql,
  • delete mysql,
  • delete mysql php,
  • delete mysql rows,
  • delete mysql syntax,
  • delete mysql table,
  • delete rows sql,
  • delete sql,
  • delete sql syntax,
  • delete sql table,
  • delete syntax in mysql,
  • delete syntax in sql,
  • delete syntax mysql,
  • delete syntax sql,
  • delete table in sql,
  • file functions in php,
  • file functions php,
  • file open php,
  • for update of sql,
  • for update sql,
  • in sql,
  • in sql update,
  • insert in sql,
  • insert mysql,
  • insert mysql php,
  • insert php,
  • insert php code,
  • insert php mysql,
  • insert sql,
  • insert sql syntax,
  • make table sql,
  • many to many sql,
  • mysql class,
  • mysql connect error,
  • mysql db connect,
  • mysql delete,
  • mysql delete column,
  • mysql delete from,
  • mysql delete from table,
  • mysql delete rows,
  • mysql delete syntax,
  • mysql delete table,
  • mysql delete table syntax,
  • mysql development,
  • mysql functions in php,
  • mysql insert,
  • mysql insert syntax,
  • mysql php class,
  • mysql php insert,
  • mysql php update syntax,
  • mysql php update table,
  • mysql simple,
  • mysql sql syntax,
  • mysql syntax,
  • mysql syntax delete,
  • mysql syntax error,
  • mysql syntax for,
  • mysql syntax insert,
  • mysql syntax update,
  • mysql update from file,
  • mysql update syntax,
  • mysql update syntax php,
  • mysql update table,
  • mysql update table php,
  • mysql update table syntax,
  • mysql variables,
  • not in sql,
  • not in sql syntax,
  • not sql,
  • one to many sql,
  • open file php,
  • open php file,
  • php and php or mysql,
  • php arguments,
  • php arrays,
  • php arrays mysql,
  • php built in functions,
  • php class,
  • php class arrays,
  • php class functions,
  • php class variables,
  • php db,
  • php db class,
  • php db connect,
  • php db connection,
  • php debugging,
  • php development,
  • php error,
  • php fields,
  • php functions arrays,
  • php insert mysql,
  • php insert mysql table,
  • php insert sql,
  • php links,
  • php links code,
  • php mysql arrays,
  • php mysql delete from,
  • php mysql delete table,
  • php mysql insert,
  • php mysql rows,
  • php mysql syntax,
  • php sql,
  • php sql column names,
  • php sql delete,
  • php stores,
  • php syntax error,
  • php table class,
  • php variables,
  • rows to column sql,
  • sql and insert,
  • sql arrays,
  • sql built in functions,
  • sql code,
  • sql column names,
  • sql column names php,
  • sql delete,
  • sql delete all,
  • sql delete all from table,
  • sql delete all rows,
  • sql delete column,
  • sql delete file,
  • sql delete from syntax,
  • sql delete from table,
  • sql delete rows,
  • sql delete syntax,
  • sql delete table,
  • sql delete table column,
  • sql delete table syntax,
  • sql error,
  • sql error code,
  • sql functions,
  • sql in php,
  • sql insert,
  • sql insert column,
  • sql insert from,
  • sql insert from file,
  • sql insert from table,
  • sql insert rows,
  • sql insert table,
  • sql insert table column,
  • sql insert update,
  • sql insert update delete,
  • sql insert with,
  • sql make table,
  • sql not,
  • sql not in syntax,
  • sql not in table,
  • sql resource,
  • sql syntax,
  • sql syntax and,
  • sql syntax delete,
  • sql syntax delete column,
  • sql syntax delete table,
  • sql syntax error,
  • sql syntax for,
  • sql syntax for delete,
  • sql syntax for insert,
  • sql syntax for update,
  • sql syntax in,
  • sql syntax insert,
  • sql syntax not,
  • sql syntax not in,
  • sql syntax update,
  • sql syntax update table,
  • sql table,
  • sql table update,
  • sql table variables,
  • sql to delete,
  • sql update,
  • sql update from table,
  • sql update rows,
  • sql update syntax,
  • sql update syntax mysql,
  • sql update table,
  • sql update table column,
  • sql update table syntax,
  • sql variables,
  • sql variables mysql,
  • syntax in php,
  • table functions sql,
  • table names in mysql,
  • table names in sql,
  • table simple,
  • table sql syntax,
  • update from sql,
  • update from table sql,
  • update in sql,
  • update mysql,
  • update mysql php,
  • update mysql syntax,
  • update mysql table,
  • update sql,
  • update sql syntax,
  • update sql syntax mysql,
  • update table in mysql,
  • update table in sql,
  • update table mysql,
  • update table mysql php,
  • update table sql,
  • update table sql syntax,
  • update table syntax mysql,
  • update table syntax sql,
  • variables in php,
  • variables in sql,
  • variables php,
  • variables sql
  • ...
• Platforms
  • Linux
• Licenses
  • Freeware