inserting to mysql fails

alijsh

Hi.
I'm having this wee problem.
I recently installed apache2, php and mysql on my freebsd-computer.

I've coded som php befor, but nothing with mysql.
Looked into a tutorial and couldn't even get their example to work.
Now here's how it look, anyone sees something wrong?

<html>
<head><title>Web Database Sample Inserting</title>
</head> 

<body bgcolor=#ffffff>
<?
    if (isset($name) && isset($phone)) {
	mysql_connect("localhost", "webuser", ""); 
        $query = "INSERT INTO mytable VALUES ('$name', '$phone')";
        $result = mysql_db_query("example", $query); 

if ($result) {
    echo "<p>$name was added to the database</p>";
}
}
?>

<h1>Add an entry</h1>
<form>
Name: <input type=text name='name'><br>
Phone: <input type=text name='phone'><br>
<input type=submit>
</form>

<p><a href="index.php">Back to index</a>
</body>
</html>

the databse is up and running, I can view what's in the database, but not add anything.
The webuser has permission to insert, select and delete.

I tried "or die()" on the connect and the query lines, but they didn't help.

Thanks a bunch.

daphreeek

Don't you need a password? If you have set the user to not require a password, I recommend you change it so it does for security 🙂

Anyways - you need to select the database 🙂 Otherwise PHP/MySQL doesnt know which database to enter the database into. change ur mysql_connect() line to this:

$db = mysql_connect("localhost", "webuser", "password");
mysql_select_db("database_name",$db);

Hope that helps
- Matt

planetsim

Actually i dont use a password but thats only on my computer.

mysql_select_db("database_name",$db);

this is what confuses me. Why call the database twice..

either use the var or not.

planetsim

Woops. You should not use the $result to add to the database

1) Cos its not needed. And never gonna be used
2) Well $result is just a variable meaning nothing will be executed until the var is given some kinda purpose

Try this

mysql_query("INSERT INTO blah (feild names) VALUES(insert where you want it in each feild)");

alijsh

The webuser doesn't have a password bacause it't just for testing.

I still can't get i working, tried selecting database, but don't I do it in
$result = mysql_db_query("example", $query);
the database name is example.
Couldn't get it working anyhow.
Tested the user through mysql's comamndline client, it worked alright, no problem adding things there.

I'm getting rather frustrated over not getting this to work.
How would you write a script inserting values into the fileds name and phone in a database called example, to a table called mytable?

thanks for your help.

daphreeek

<?php
$db = mysql_connect("localhost", "webuser", "");
mysql_select_db("example",$db);

$sql = "INSERT INTO mytable (name, phone) VALUES ('Matt', '0123456789)";
$result = mysql_query($sql);

?>

That should work.

The reason you must use mysql_select_db() is because each user may have multiple databses. mysql_connect() only connects to mysql - not a specific database.

Matt

alijsh

I'm starting to think there's something wrong with my settings.
Couldn't get the prvious script working either.

The weirdo thing is that I can display data, but not write it.

Anyone got any clues on what might be the thing.
It's all running on Freebsd with apache 2, php4 and mysql, everything installed from the bsd ports.

Thanks for all your help