PHP Insert into mySQL Error

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I have been playing with some code today as it's my day off work, and I cannot figure out what is going wrong... my code connects to the dbase successfully, however when trying to insert data, even though the page comes back and says the record has been added, it's not actually going in to the dbase table. I have changed some of the details in the code example below for security reasons, however the main part of the code is all correct... can anyone point out the obvious?

<?php

$fname = $_POST['fname'];
$sname = $_POST['sname'];
$age = $_POST['age'];
$email = $_POST['email'];
$uname = $_POST['uname'];
$pword = $_POST['pword'];



$con=mysqli_connect("mysql1454.000webhost.com", "a464549813_admin", "password", "a464549813_members");

if ($con)
{
echo mysqli_connect_error();
}



$sql="INSERT INTO members (
Firstname,
Surname,
Age,
Email,
Username,
Password)
VALUES
(
'$fname',
'$sname',
'$age',
'$email',
'$uname',
'$pword')
)";

if (mysqli_query($con, $sql))
{
echo "error inserting new record";
}
else
{
echo "record added";
}

mysqli_close($con);

- - - Updated - - -

I have fixed it... stripped all the text back and began again and started working... the main reason was because I moved from mysqli back to MySQL for each of the commands

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Glad you got it working. I just started looking into SQL for work. Its pretty fun keep it up.

 

you might want to take the connection string off this webpage. I can see it's non-production, but you might use it in the future!