Jump to content

[SOLVED] Error Querying Database: Web form to Database


tbritny

Recommended Posts

Hi! I am very much a newbie to PHP(I started yesterday) I am working on learning how to get info into a database from a web form, but I have hit a road block pretty early on. My problem started when I entered the code from $dbc to mysql_close($dbc). More specifically this line " $result = mysql_query($dbc, $query) " is what is noted in the error message. I checked to make sure my location, user name, password, database name and table name were correct with my hosting company and that seems to be fine. More information:   

* PHP Version 4.4.8

* Hosting - MediaTemple Grid-Service

 

This is the error message:

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /web/web/web/web/web/web/website.com/html/test/report.php on line 35

Error querying database.

 

 

Here is my code (copied from a book tutorial):

<?php
$first_name = $_POST['firstname'];
$last_name = $_POST['lastname'];
$when_it_happened = $_POST['whenithappened'];
$how_long = $_POST['howlong'];
$how_many = $_POST['howmany'];
$alien_description = $_POST['aliendescription'];
$what_they_did = $_POST['whattheydid'];
$fang_spotted = $_POST['fangspotted'];
$email = $_POST['email'];
$other = $_POST['other'];

$dbc = mysql_connect('location', 'username', 'password', 'database_name')
or die('Error connecting to MySQL server.');

$query = "INSERT INTO table_name (first_name, last_name, " .
"when_it_happened, how_long, how_many, alien_description, " .
"what_they_did, fang_spotted, other, email) " .
"VALUES ('Sally', 'Jones', '3 days ago', '1 day', 'four', " .
"'green with six tentacles', 'We just talked and played with a dog', " .
"'yes', 'I may have seen your dog. Contact me.', " .
"'sally@gregs-list.net')";

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

mysql_close($dbc);

echo 'Thanks for submitting the form.<br />';
echo 'You were abducted ' . $when_it_happened;
echo ' and were gone for ' . $how_long . '<br />';
echo 'Number of aliens: ' . $how_many . '<br />';
echo 'Describe them: ' . $alien_description . '<br />';
echo 'The aliens did this: ' . $what_they_did . '<br />';
echo 'Was Fang there? ' . $fang_spotted . '<br />';
echo 'Other comments: ' . $other . '<br />';
echo 'Your email address is ' . $email;
?>

Thanks for any help you can give me! Let me know if more information is needed.

 

 

 

 

Link to comment
Share on other sites

As written in the manual:

resource mysql_query ( string $query [, resource $link_identifier ] )

So try this:

$result = mysql_query($query, $dbc)

or better (if you have only one connection):

$result = mysql_query($query);

Link to comment
Share on other sites

Also,

 

$dbc = mysql_connect('location', 'username', 'password', 'database_name')
or die('Error connecting to MySQL server.');

 

I hope that you just changed the location, username and password arguments to that for posting purposes, because you need to put the real info in there for it to work.

 

Also, the 'database_name' does not go in the mysql_connect.  You need to specify the database name with

 

mysql_select_db after the mysql_connect

 

Link to comment
Share on other sites

Thank you, I just utilized both of your suggestions! I am not getting the line error anymore, just the Error Querying Database part, but I'll keep working it. And yes, I used fake information for posting here...I checked with the hosting company and all that information is correct on my actual code. Anyway, thanks again!

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.