mysql query not inserting string into table?

Question

I have been able to manually insert values in my table using phpmyadmin, and even if i end up using the same php code i get from php my admin to call the query it STILL won't add the value to the table. here is the code:

<?php
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

mysql_select_db('sc2broating1', $link);

$sql = "INSERT INTO `sc2broad_tesing1`.`Persons` (`re`) VALUES (\'hello11\')";

mysql_query($sql);

mysql_close($link);

?>

KV Prajapati · Accepted Answer · 2012-01-03 03:14:01Z

1

Don't escape value.

$sql = "INSERT INTO `sc2broad_tesing1`.`Persons` (`re`) VALUES ('hello11')";

answered Jan 3, 2012 at 3:14

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonathon Reinhart · Accepted Answer · 2012-01-03 03:22:02Z

0

I would also consider using bound parameters, as seen in mysqli::prepare, if Mysqli is an option.

answered Jan 3, 2012 at 3:22

Jonathon Reinhart

138k38 gold badges266 silver badges347 bronze badges

Collectives™ on Stack Overflow

mysql query not inserting string into table?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related