Member Avatar for SirMahlon 
<html>
<body>
<?php
$username = 'root';
$password = '';
$hostname = 'localhost'; 
//connection to the database
$con = mysql_connect($hostname, $username, $password,'contactmanager') 
 or die('Unable to connect to MySQL');
echo 'Connected to MySQL<br>'.'<p>';
mysql_query($con,'INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber)
VALUES(Peter,2008-03-05,peter@hotmail.com,kasland,0269015748)');
mysql_close($con);
?>
</body>
</html>
  • 3 Contributors
  • 8 Replies
  • 5K Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by SirMahlon
Member Avatar for SirMahlon

i keep on getting this error message.can the forum assit me pls.
Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\www\getinside.php on line 12

Member Avatar for code_rum

You are missing mysql_select_db('dbname')
and in insert query string values should be in double inverted comma ""
$con not required in mysql_query
mysql_connect should not have dbname

Member Avatar for SirMahlon

so where am putting $con.can elaborate further.i inserted mysql_select_db('dbname').now i dontget any error but it does not g intothe sql server thou it displays connected to mysql.

Member Avatar for code_rum

remove $con from mysql_query and add $con to mysql_select_db('your-db-name',$con).

Change this

mysql_query($con,'INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber)
VALUES(Peter,2008-03-05,peter@hotmail.com,kasland,0269015748)');

to

mysql_query('INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber)
VALUES("Peter","2008-03-05","peter@hotmail.com","kasland",0269015748)');

If this doesn't work then paste your updated code

Edited by code_rum
Member Avatar for SirMahlon

<html>
<body>
<?php
$username = 'root';
$password = '';
$hostname = 'localhost';
//connection to the database
$con = mysql_connect($hostname, $username, $password)
or die('Unable to connect to MySQL');
echo 'Connected to MySQL<br>'.'<p>';
mysql_select_db("contactmanager",$con);
mysql_query('INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber);
VALUES("Peter","2008-03-05","peter@hotmail.com","kasland",0269015748)');
mysql_close($con);
?>
</body>
</html>.
did not work.could it be some configuration from mysql phpadmin?

Member Avatar for code_rum 
mysql_query('INSERT INTO Personalinformation(Name, YearOfBirth, Email,Location,PhoneNumber);
VALUES("Peter","2008-03-05","peter@hotmail.com","kasland",0269015748)');

above code have no space after Personalinformation(Name...) and there's ; at PhoneNumber); which shuoldn't be there.

Replace by this code

mysql_query('INSERT INTO Personalinformation (Name, YearOfBirth, Email,Location,PhoneNumber)
VALUES("Peter","2008-03-05","peter@hotmail.com","kasland",0269015748)');
Edited by code_rum
Member Avatar for SirMahlon

thank u very much.it worked for me now.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.