Location: PHPKode > scripts > Simple SQL > simple-sql/example.php
<?
include('SimpleSQL.class.php');

$mysql=new SimpleSQL("test_db");		// most of the connection vars are in the class file
						// you CAN provide the connection vars, but they are optional
						// view class file for more info

$mysql->db_table="content";			// assign "content" to the active table
$mysql->debug=true; 				// enable debug mode (prints out the class file's every move)

/***************************************\
The following code assumes your database
is set up like this:
database name: 	test_db
table name:		content
fields:			location,content (both type text)
\***************************************/

$stuff="<html>
<body>
<h3>w00t</h3>
</body>
</html>";
									// insert stuff into the database
$mysql->insert("'location','content'","'home','$stuff'","content");	// ("content" is really optional,
									// the script already has it stored
									// in a public variable (view up top)
									// insert function works like this:
									// first argument are the fields
									// second arguemnt is the data
									// third and on are optional (see comments in class file)

$mysql->get_content("content","WHERE location='home'");
echo "Number of Rows: ".$mysql->num_rows();
echo"<pre>";
print_r($mysql->result);			// this will be an array
echo"</pre>";
						// optional arguments [db_table],[db_order],[db_limit] for delete
$mysql->delete("WHERE location='home'","","",1);		// delete rows and limit to 1

for($i=0;$i<4;$i++)				// loop and insert
$mysql->insert("'location','content'","'services','im on the services page'");
						// another example of insert function
$mysql->get_content("","WHERE location='services'");
echo"<pre>";
print_r($mysql->result);			// this will be an array
echo"</pre>";
						// update arguments are: field, newdata, table_name, where, limit
$mysql->update("content","im a newer version of home content","","WHERE location='home'");
						// example of the update function

$mysql->get_content();
echo "Number of Rows: ".$mysql->num_rows();
echo"<pre>";
print_r($mysql->result);			// this will be an array
echo"</pre>";

echo $mysql->error;				// echo errors if any were filled out

?>
Return current item: Simple SQL