I cant seem to get this to connect.  This is to my local testing server, 
which is on, so we need not worry that I have posted the UN/PW.

This is a duplicate of a script I have used countless times and it worked. 
The error message is 'Error querying database.'

Some one point out the error of my ways?


<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
<label>Name of Beer</label></td><td><input name="beername" type="text" />
<label>Maker of Beer</label></td><td><input name="manu" type="text" />
<label>Type of Beer</label></td>
<td><select name="type" size="1" id="type">
<!--<select name="avail" size="1" id="avail">
<td><label>Sold in</label>
</td><td><input type="checkbox" name="singles" value="Yes" /> Singles<br />
<input type="checkbox" name="six" value="Yes" /> Six Packs <br />
<input type="checkbox" name="can" value="Yes" /> Cans<br />
<input type="checkbox" name="bottles" value="Yes" /> Bottles <br />
<input type="checkbox" name="tap" value="Yes" /> Draft <br />
<label>Size</label></td><td><input name="size" type="text" />
<label>Description</label></td><td><textarea name="desc" cols="40" 
<input name="submit" type="submit" value="Submit" /></td></tr>
<div id="list">
$beername = $_POST['beername'];
$manu = $_POST['manu'];
$type = $_POST['type'];
$singles = $_POST['singles'];
$six = $_POST['six'];
$can = $_POST['can'];
$bottles = $_POST['bottles'];
$tap = $_POST['tap'];
$size = $_POST['size'];
$desc = $_POST['desc'];

$dbc = mysqli_connect('localhost','root','','rr')or die('Error connecting 
with MySQL Database');

$query = "INSERT INTO beer (beername, manu, type, singles, six, can, 
bottles, tap, size, desc, ip )"." VALUES ('$beername', '$manu', '$type', 
'$singles', '$six', '$can', '$bottles', '$tap', '$size', '$desc', '$ip' )";

$result = mysqli_query($dbc, $query)
or die('Error querying database.');



__________ Information from ESET Smart Security, version of virus signature 
database 5706 (20101215) __________

The message was checked by ESET Smart Security.


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to