PHP Programming Tips

Posts Tagged ‘mysql’

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Table: datadump

Columns: table, column, data

Data I want to insert: They are variables; $table, $column, $data

I know that the mysql_select_db and mysql_connect is ok and I will not give that for security reasons, but what about this syntax:

$sql = “INSERT INTO datadump (table, column, data) VALUES ($table,$column,$data)”;

$mysqlquery = mysql_query($sql,$con);
if(!$mysqlquery)
{
die(‘Error: ‘ . mysql_error());
}

When I run the script with this syntax, I get the following error:

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘table, column, data) VALUES (index,name,fruits)’ at line 1

Can you please tell me what to do?
Same problem after taking the first answerer’s advice
Same problem again with second answerer’s advice

Still learning about Network security and web page development. Currently Learning PHP and MySQL. Other than that, I am pretty much an HTML, JScript amatuer web designer. On my web site, I would like to be able to record and log the IP address of people who visit my site. Is this accomplished through code on a page, or by adding software to the server? And While I have you here reading, what programming is best for log in abilities (creating user names and passwords)? As I said, still learning, so any help is appreciated. Any references to tutorial sites, or books is also appreciated. I would like to learn as much as possible about web development, network security, and intrusion detection and prevention.
Thank you! ( And yes, I give best answer)

why my dynamic web content cannot be viewed from other computer within LAN? I used PHP,Mysql and apache?

why my dynamic web content cannot be viewed from other computer? Its apache,php and mysql in windows xp pro?

I found this account login code online:

username;
$password = $row->password;
}
echo “Your username is $username”;
echo “Your password is $password”;
}
else {
echo “Please enter your email address!”;
}

?>

My question is, isn’t this very unsafe since if a malicious user does a little digging and finds a user’s email address, they can pretty much get their password or am I incorrect? I have a mysql db and and trying to develop a secure php front end with user login. I haven’t found any that use hashing algorythms.