<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>
SirMahlon
0
Junior Poster in Training
Recommended Answers
Jump to Post
$con
comes after the query, not before. See: http://php.net/mysql_queryAlso check your
mysql_connect
Jump to PostYou 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
All 8 Replies
SirMahlon
0
Junior Poster in Training
pritaeas
2,179
¯\_(ツ)_/¯
Moderator
Featured Poster
code_rum
8
Junior Poster in Training
SirMahlon
0
Junior Poster in Training
code_rum
8
Junior Poster in Training
SirMahlon
0
Junior Poster in Training
code_rum
8
Junior Poster in Training
SirMahlon
0
Junior Poster in Training
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.