Mysql Value Adding Problem

[purtip3154]

<?php
$user = "user";
$pass = "test";
mysql_connect('localhost','root','michael1');
mysql_select_db('LogPass');
$sql="INSERT INTO Table1 VALUES ('$ulog', '$plog')";
$rs=mysql_query($sql);
header("Location: http://localhost/proj/");
?>

I've been having some problems getting this code to add a user and pass into my db... It worked perfectly in odbc, so I know it works. There is no error message, but the values do not get inserted...

[awpti]

change:

 

$rs=mysql_query($sql);

 

to:

 

$rs=mysql_query($sql) or die(mysql_error());

 

Also, where is $ulog and $plog coming from?

[phpSensei]

$sql="INSERT INTO `Table1` VALUES ('$ulog', '$plog')";

 

Where are the columns set for Table 1?

 

 

 

 

Try this

 

<?php
$user = "user";
$pass = "test";
mysql_connect('localhost','root','michael1') or die(mysql_error());
mysql_select_db('LogPass')or die(mysql_error());
$sql="INSERT INTO `Table1` (username,password) VALUES ('$ulog', '$plog')";
$rs=mysql_query($sql)or die(mysql_error());
header("Location: http://localhost/proj/");
?>

 

edit: Oops. someone already posted, sorry.

[revraz]

$sql="INSERT INTO Table1 VALUES ('$user', '$pass')";

 

You were passing the wrong values.

[purtip3154]

When the error message comes it says "No Database Selected", but there is one selected. I changed the values back, but to no avail.

 

EDIT:

You have to select the columns?

[shocker-z]

means that you haven't got

 

mysql_select_db('databasename', $link) or die(myswl_error());

http://uk2.php.net/function.mysql-select-db

 

If not, then you fancy showing the whole code?

 

Regards

Liam

[PFMaBiSmAd]

You must list the columns if you are not inserting a value into each column. If you only have two columns in the table and you are inserting a value into each column, you don't need to list the columns.

 

Because you get a database selected error message from the query statement, it means that your mysql_select_db() statement is incorrect. Fix that problem first.

[purtip3154]

That is the whole code, but the mysql_select_db() statement is there... Any ideas?

[redarrow]

try that but even it work's sort your insert out mate....

<?php
$user = "user";
$pass = "test";
$db=mysql_connect('localhost','root','michael1');
mysql_select_db('LogPass',$db);
$sql="INSERT INTO Table1 VALUES ('$ulog', '$plog')";
$rs=mysql_query($sql)or die(mysql_query());
header("Location: http://localhost/proj/");
?>

[phpSensei]

Where are your values for the INSERT?

 

Plus

 

$sql="INSERT INTO Table1 VALUES ('$ulog', '$plog')";

 

That is wrong.

 

Read this

 

http://www.w3schools.com/php/php_mysql_insert.asp

[redarrow]

Where are your values for the INSERT?

 

Plus

 

$sql="INSERT INTO Table1 VALUES ('$ulog', '$plog')";

 

That is wrong.

 

Read this

 

http://www.w3schools.com/php/php_mysql_insert.asp

 

it not wrong he not using the first varable defention

 

you dont need to tell the varables what thay are if u dont want to....#

 

it bad but it still works

[purtip3154]

$user = "user";

$pass = "test";

 

Those are the values... Sorry, I mistyped.

Thanks for the code redarrow, but it did not work.

[revraz]

Repost your current code and also post your DB Table layout and verify the DB name.

[redarrow]

try this mate should insert your name password and goto google

 

it will work if in your databae you got ulog and plog in a table as one table,,,,,

 

 

<?php

$user="user";
$pass="test";

$db=mysql_connect("localhost","root","michael1");
$result=mysql_select_db("LogPass",$db);

$user=addslashes($_POST['user']);
$pass=addslashes($_POST['pass']);

if(isset($user)||($pass))){

$sql="INSERT INTO Table1 (ulog,plog) VALUES ('$user', '$pass')";
$rs=mysql_query($sql)or die(mysql_query());

header("Location: http://www.google.com");
}
?>

[revraz]

This makes no sense

 

$user="user";

$pass="test";

 

$user=addslashes($_POST['user']);

$pass=addslashes($_POST['pass']);

 

He has no FORM to POST from.

[phpSensei]

This makes no sense

 

$user="user";

$pass="test";

 

$user=addslashes($_POST['user']);

$pass=addslashes($_POST['pass']);

 

He has no FORM to POST from.

 

He probably only posted the Script.

[PFMaBiSmAd]

Considering that the original problem was that there was no error checking on any of the mysql function calls to get php/mysql to tell exactly which one and why it was failing and that once some error checking was added to the mysql_query(), which resulted in the only addition information that there was no database selected, this thread has gotten off topic of helping with the problem of connecting to the database server, selecting a database, and executing a query.

 

Correct the actual query once it is executing, but the code is not even reaching that point yet. The OP stated the $ulog/$plog/$user/$pass was a typo. Without knowing what the column names are, posting code with guesses about what the names are and if a form is involved, is just adding confusion.

[purtip3154]

Sorry, been away for a while... DB Layout:

 

Name: LogPass

Table: Table1

Headers: Username, Password

 

I was only posting the script but the form was just your basic html page and I prefer to get the script working before integrating it into the form...

 

The code I was using was this one:

 

<?php

$user = "user";

$pass = "test";

mysql_connect('localhost','root','michael1') or die(mysql_error());

mysql_select_db('LogPass')or die(mysql_error());

$sql="INSERT INTO `Table1` (username,password) VALUES ('$user', '$pass')";

$rs=mysql_query($sql)or die(mysql_error());

header("Location: http://localhost/proj/");

?>

 

Thanks to PhpSensei

 

I was still having the No Database Selected error though. Is it a problem having MySql and xampp installed if Mysql has a diff. port and service name?

[phpSensei]

Remove the OR die and see what happens.

[revraz]

Still didn't fix your variables.

[phpSensei]

ya it should be

 

<?php
$user = "user";
$pass = "test";
mysql_connect('localhost','root','michael1') or die(mysql_error());
mysql_select_db('LogPass';
$sql="INSERT INTO `Table1` (username,password) VALUES ('$user', '$pass')";
$rs=mysql_query($sql)or die(mysql_error());
header("Location: http://localhost/proj/");
?>