|
|
Posted by Colin Fine on 10/21/06 15:49
Bonzol wrote:
> 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.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml">
> <head>
> <title>Database 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
> ($dberrormessage);
> #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($_REQUEST['name']))
> { ?>
> <table border="1">
> <tr>
> <th>Number</th>
>
> </tr>
> "Insert into tbl_category (cat_description)
> Values ('%{$_REQUEST['name']}%')
>
>
> <?php $query = "Insert into tbl_category (cat_description) Values
> ('%{$_REQUEST['name']}%')";
> @$result = mysql_query($query) or exit('<strong>An 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($conn);
> }
> ?>
> </body>
> </html>
>
>
> Thanx in advance
>
You haven't told us what the problem actually is: do you get an error
message? Does it apparently succeed but insert no rows? Does it insert
empty rows?
Colin
Navigation:
[Reply to this message]
|