StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POError Updating Database with PHP
primarykey
Id
6606229
data
AcceptedAnswerId
0
AnswerCount
4
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-07-07T05:33:08.977
FavoriteCount
0
LastActivityDate
2014-01-05T08:58:44.563
LastEditDate
LastEditorUserId
0
OwnerUserId
832890
ParentId
0
PostTypeId
1
Score
0
ViewCount
1546
LastEditorDisplayName
text
Body
<p>I'm currently attempting to insert data into a MySQL database using PHP. To help, I am following <a href="http://teamtutorials.com/web-development-tutorials/php-tutorials/inserting-data-into-a-mysql-database-using-php" rel="nofollow">this</a> tutorial.</p> <p>Thus far, I have taken the following steps:</p> <ul> <li>Manually created a database via phpMyAdmin named "core_group_me" on my WAMPSERVER</li> <li><p>Created a form page named "form.php" (code below):</p> <pre><code><html> <head> <title></title> </head> <body> <form method="post" action="update.php"> Username:<br /> <input type="text" name="id" size="30" /><br /> First Name:<br /> <input type="text" name="firstname" size="30" /><br /> Last Name:<br /> <input type="text" name="lastname" size="30" /><br /> Email:<br /> <input type="text" name="email" size="30" /><br /> Location:<br /> <input type="text" name="location" size="30" /><br /> Expertise:<br /> <input type="text" name="expertise" size="30" /><br /><br /> <input type="submit" value="Update Database" /> </body> </html> </code></pre></li> <li><p>Created a page to update the "core_group_me" database named "update.php" (code below):</p> <pre><code><?php $id = $_POST['id']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $email = $_POST['email']; $location = $_POST['location']; $expertise = $_POST['expertise']; mysql_connect ("localhost", "core_group_me", "") or die ('Error: ' .mysql_error()); mysql_select_db ("members"); $query="INSERT INTO members (id, firstname, lastname, email, location, expertise)VALUES ('".$id."', '".$firstname."', '".$lastname."', '".$email."', '".$location."', '".$expertise."')"; mysql_query($query) or die ('Error updating database'); echo "Database Updated With: " .$id. " " .$firstname. " ".$lastname. " ".$email. " " .$location. " " .$expertise ; ?> </code></pre></li> </ul> <p>That being said, when I open up the "form.php" page, input information in the specified fields and submit everything, I receive the the following error: "Error updating database". I'm <em>very</em> new to programming in PHP and working with MySQL databases, so I honestly have absolutely no idea where I've gone wrong. Any help would be much appreciated!</p>
Tags
<php><mysql><phpmyadmin><mysql-error-1064>
Title
Error Updating Database with PHP
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USHoustonBG
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYou have changed your database to members using `mysql_select_db ("members");` command. Is members table in members database?
  singulars
  PostPostId
  POError Updating Database with PHP
  UserUserId
  USrahim asgari
2. COWhat error do you receive if you use `mysql_query($query) or die(mysql_error());`?
  singulars
  PostPostId
  POError Updating Database with PHP
  UserUserId
  USdrfranks3

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.