PHP Database Aux

An example with PHP Database Aux:

<?php
// Include PHP Database Aux file
require_once( 'database.php' );

$db = new db();

// Define our connection data
$db->host = 'localhost';
$db->username = 'example';
$db->password = 'example';
$db->database = 'example';

// Try to connect/verify if any error happens
if ( !$db->connect() )
{
	die( 'There was a problem connecting to database' );
}


// Insert dummy data
$data = array(
	'data1' => $_POST['data1'],
	'data2' => $_POST['data2'],
	'data3' => $_POST['data3'],
	'data4' => $_POST['data4'],
	'data5' => $_POST['data5'],
	'data6' => $_POST['data6'],
	'data7' => $_POST['data7'],
	'data8' => $_POST['data8'],
	'data9' => $_POST['data9'],
	'data10' => $_POST['data10']
);

$db->insert( 'table_name' , $data );


// Select the row that we just inserted
$where = array(
	'iddata' => $db->insert_id()
);

$db->where( $where );
$db->select( 'table_name' );

foreach( $db->result() as $row )
{
	echo $row['data1'];
	echo $row['data2'];
	echo 'All data :-)';
}
?>		

An example with pure PHP:

<?php
// Define our connection data
$host = 'localhost';
$username = 'example';
$password = 'example';
$database = 'example';

// Connect
$connect = mysql_connect( $host , $username , $password );

$select_db = mysql_select_db( $database );

// Verify if any error happens
if ( !$select_db )
{
	die( 'There was a problem connecting to database' );
}

mysql_query( 'INSERT INTO table_name ( data1 , data2 , data3 , data4 , data5 , data6 , data7 , data8 , data9 , data10 ) VALUES ( "'. $_POST['data1'] .'" , "'. $_POST['data2'] .'" , "'. $_POST['data3'] .'" , "'. $_POST['data4'] .'" , "'. $_POST['data5'] .'" , "'. $_POST['data6'] .'" , "'. $_POST['data7'] .'" , "'. $_POST['data8'] .'" , "'. $_POST['data9'] .'" , "'. $_POST['data10'] .'" )' );

$inserted_id = mysql_insert_id();

// Select the row that we just inserted
$sql = mysql_query( 'SELECT * FROM table_name WHERE iddata = "'. $inserted_id .'"' );


while ( $row = mysql_fetch_array( $sql ) )
{
	echo $row['data1'];
	echo $row['data2'];
	echo 'All data :-)';
}
?>