Help: Cant insert data into table

**acer2** · June 7, 2008

Hi,

I was wondering if someone knows the answer.

I just installed Wamp with: Apache Version : 2.2.8 PHP Version : 5.2.5 and

phpMyAdmin - 2.11.5 with MySQL client version: 5.0.45 and Used PHP extensions: mysqli.

I want to insert data in a table. The table exist in mysql!

I do everything correct but i keep getting this error:

Couldn’t execute query

This is the code:

connect.php

<?php

//connect to database

$server='localhost';

$host='127.0.0.1';

$user='root';

$password='';

$dbname = 'tester';

$cxn = mysqli_connect($host,$user,$password,$dbname)

or die ('Couldn’t connect to server.');

$username = $_POST["username"];

$passwrd = $_POST["passwrd"];

$adres = $_POST["adres"];

$query = 'INSERT INTO test1 (username, passwrd, adres) VALUES ($username, $passwrd, $adres)';

$result = mysqli_query($cxn,$query) or die ('Couldn’t execute query.');

echo "Data inserted in table " . ;

?>

</body>

</html

This is the code for the form: add.php

<html>

<head>

</head>

<body>

<tr>

</tr>

<tr>

<td width="100">Password</td>

</tr>

<tr>

<td width="100">adres</td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

Hope to get help!

Thanks

Acer

**acer2** · June 7, 2008

Well, I'm embarred to say that I had made a little mistake .

The first variable was numeric, so the quotes ("username") where wrong. And the rest should have been :

"$passwrd", "$adres")

You can say I solved the problem myself

thanks anyway.

acer

Sign In

Help: Cant insert data into table

Recommended Posts

acer2

Link to comment

Share on other sites

acer2

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Activity

Browse