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

acer2

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Activity

Browse