Need Help with PHP + MySQL

**Cezary Kubel** · May 12, 2009, 19:03

Hey guys,

I have been running into problems with this code for a bit now. Since I am just learning PHP, I decided that the best way to learn is to start building. So I got part of the script done, but ran into a problem adding data to a database.

I have a file called ADD dot php which looks like this:

<?php include "base dot php"; ?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Beta Test</title>
<link rel="stylesheet" href="style dot css" type="text/css" />
</head>
<body>

<h1>Add Domain</h1>

<form method="post" action="addomain dot php" name="loginform" id="loginform">
<fieldset>
<label for="domain">Domain

/label><input type="text" name="domain" id="domain" /><br /><br />
<input type="submit" name="submit" id="submit" value="Add Domain!" />
</fieldset>
</form>

<a href="logout dot php">Logout</a>

and a file called addomain dot php that includes this

<?php
$first = $_POST['domain'];
$sql = "INSERT INTO (domains) VALUES ('$first')";
mysql_query($sql);
{
?>

But for some reason, I can't add whatever the user imput into the form into the database. Is there anything wrong with this? It gives me a syntax error like this

Parse error: syntax error, unexpected $end in addomain dot php on line 6

If anyone could help, I would really appreciate it.

Thanks,

**Dan Grossman** · May 12, 2009, 19:23

What is the last "{" in the file for? It doesn't match anything, which is probably why it's complaining.

You need to connect to the database before you can issue queries to it

**Cezary Kubel** · May 12, 2009, 19:31

Ok, That works. No more syntax erroe but now for some reason, its not adding anything to the database. :/

**Dan Grossman** · May 12, 2009, 19:37

Did you connect to the database before calling mysql_query?

Also, your query is not correct. It's missing either the table name or the name of the column, I'm not sure which...

PHP Code:


$sql = "INSERT INTO table_name (column_name) VALUES ('$first')";

**Cezary Kubel** · May 12, 2009, 19:40

Wow thanks man. That works!

**Cezary Kubel** · May 13, 2009, 11:16

When I try to add another domain, it doesnt add a new row. Why is there?

**Dan Grossman** · May 13, 2009, 11:24

Two things:

1) Share the schema of the table. Show the CREATE TABLE query that created it.

2) Share the error message.

PHP Code:


$ret = mysql_query($sql);
if (!$ret) {
  echo "Error: " . mysql_error();
}

**Cezary Kubel** · May 13, 2009, 11:27

Not sure what you mean for #1 but if I got to phpMyAdmin, and click the table, it says this for the MySQL query

SELECT *
FROM `domains`
LIMIT 0 , 30

Im getting this for the error

Error: Duplicate entry '' for key 1

**Jake Arkinstall** · May 13, 2009, 11:29

You need to set the primary key of the table to an auto_incrementing integer.

**Dan Grossman** · May 13, 2009, 11:30

Originally Posted by arkinstall

You need to set the primary key of the table to an auto_incrementing integer.

Why?

Domains are unique, they would make a suitable key without adding an artificial key.

We don't even know what this table looks like.

**Cezary Kubel** · May 13, 2009, 11:36

I have 3 rows in the database. uid, username, and domain. I'm not worried about the username and uid now, just need to add the domains.

**Dan Grossman** · May 13, 2009, 11:38

Originally Posted by Cezary Kubel

I have 3 rows in the database. uid, username, and domain. I'm not worried about the username and uid now, just need to add the domains.

Your table has unique constraints on one or more of the columns, and by not specifying values for all the columns, you're violating that constraint by trying to insert nothing twice.

The SitePoint Forums have moved.

User Tag List

Thread: Need Help with PHP + MySQL

Thread Tools

Display

Need Help with PHP + MySQL

Bookmarks

Bookmarks

Posting Permissions