"; ?> Working with records

Working with records

The database server is not available

"); @mysql_select_db("sb", $DBconnect) Or die("

Unable to open the database.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); $request = "SELECT * FROM products"; $queryResult = @mysql_query($request, $DBconnect) Or die("

Unable to execute the request.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); print("" . "\n" . ""); while($row = mysql_fetch_row($queryResult)) { print(""); for ($i=0; $i{$row[$i]}"); print(""); } print("
Original database
Make Model Price Quantity
"); mysql_close($DBconnect); ?>

Adding a new record

Make:
Model:
Price:
Quantity:

The database server is not available

"); @mysql_select_db("sb", $DBconnect) Or die("

Unable to open the database.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); $request = "INSERT INTO products VALUES('{$_POST['make']}', " . "'{$_POST['model']}', {$_POST['price']}, {$_POST['quantity']});"; $queryResult = @mysql_query($request, $DBconnect) Or die("

Unable to execute the request.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); // printing modified DB $request = "SELECT * FROM products"; $queryResult = @mysql_query($request, $DBconnect) Or die("

Unable to execute the request.

" . "

Error code " . mysql_errno($DBconnect) . ": " . mysql_error($DBconnect) . "

"); print("" . "\n" . ""); while($row = mysql_fetch_row($queryResult)) { print(""); for ($i=0; $i{$row[$i]}"); print(""); } print("
Modified database
Make Model Price Quantity
"); mysql_free_result($queryResult); mysql_close($DBconnect); } ?>