On Wed, 2010-12-15 at 13:42 -0500, Gary wrote:
> 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?
>
> Gary
>
>
> <form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
> <tr>
> <td>
> <label>Name of Beer</label></td><td><input name="beername" type="text" />
> </td>
> </tr>
> <tr>
> <td>
> <label>Maker of Beer</label></td><td><input name="manu" type="text" />
> </td>
> </tr>
> <tr>
> <td>
> <label>Type of Beer</label></td>
> <td><select name="type" size="1" id="type">
> <option>Imported</option>
> <option>Domestic</option>
> <option>Craft</option>
> <option>Light</option>
> </select>
> <!--<select name="avail" size="1" id="avail">
> <option>Available</option>
> <option>Sold</option>
> </select>-->
> </td>
> </tr>
> <tr>
> <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 />
> <tr>
> <td>
> <label>Size</label></td><td><input name="size" type="text" />
> </td></tr>
> <tr><td>
> <label>Description</label></td><td><textarea name="desc" cols="40"
> rows="5"></textarea>
> </td></tr>
> <tr><td>
> <input name="submit" type="submit" value="Submit" /></td></tr>
> </form>
> </table>
> </div>
> <div id="list">
> <?php
> $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'];
> $ip= $_SERVER['REMOTE_ADDR'];
>
> $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.');
>
>
> mysqli_close($dbc);
>
>
>
> --
> Gary
Read Ash's reply... but basically, you're running the query with POST
variables, and inserting them on page display as well as on form submit.
can you ensure that you can connect from the command line?
if you may take some criticism, you should rethink your database design,
as well as the page flow/design... you should either post the form to a
new page, or if it is back to itself, you should check to see that you
have in fact posted it before just blindly inserting into the database
(as currently, every time you view the page, you will insert into the
database, even if completely empty values).
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
