Hello, PHP n00b here.
Using SQL just working off some examples, I have no problem selecting
data, but I cant seem to be able to insert. If someone could see where
im going wrong
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Databa se Connection</title>
</head>
<body>
<?php
#Server Name - e.g. localhost:3309
$dbserver = 'localhost';
#Username used to log into MySQL database server.
$dbusername = '';
#Password used to log into MySQL database server.
$dbpassword = '';
#Error message shown if an error whilst attempt to establish a
connection with the server.
$dberrormessage = '<strong>Error connecting to database...</strong>';
#Name of database on server.
$dbdatabase = 'bonzollibrary' ;
#Establish Connection
@$conn = mysql_connect($ dbserver, $dbusername, $dbpassword) or exit
($dberrormessag e);
#Selects which database is to be used on server.
mysql_select_db ($dbdatabase);
?>
<h1>Sample Database Connection</h1>
<form action="db-conn2.php" method="get">
<input type="text" id="name" name="name" />
<input type="submit" value="Search" />
</form>
<?php if(isset($_REQU EST['name']))
{ ?>
<table border="1">
<tr>
<th>Number</th>
</tr>
"Insert into tbl_category (cat_descriptio n)
Values ('%{$_REQUEST['name']}%')
<?php $query = "Insert into tbl_category (cat_descriptio n) Values
('%{$_REQUEST['name']}%')";
@$result = mysql_query($qu ery) or exit('<strong>A n error has
occured while connecting to the database. The following query is
not valid: \''.$query.'\'. </strong>');
}?>
</table>
<?php
#Check if connection is still open
if($conn)
{
#Close the connection
mysql_close($co nn);
}
?>
</body>
</html>
Thanx in advance
