php insert into mysql database

Question

I can't find out what I'm doing wrong here. I'm just trying to insert a value into a field. the value consists of text,numbers and # characters. There are no errors or nothing, also nothing is inserted.. Here is the php:

$dbc = mysqli_connect(DBHOST,DBUSER,DBPW);
if (!$dbc) {
die("Database connection failed: " . mysqli_error($dbc));
exit();
}

$dbs = mysqli_select_db($dbc, DBNAME);
if (!$dbs) {
die("Database selection failed: " . mysqli_error($dbc));
exit(); 
}
mysqli_set_charset($dbc, 'utf8');

$reportdata = mysqli_real_escape_string($dbc, $_GET['reportdata']);

$query = "INSERT INTO `onwordreports`(`reportdata`) VALUES ('$reportdata')";

$result = mysqli_query($dbc, $query or trigger_error("Veri yükleme başarısız: " . mysqli_error($dbc)));

echo $result;

mysqli_close($dbc);

Thanks.

Turn on error reporting.

MonkeyZeus
– MonkeyZeus

2016-04-06 13:28:58 +00:00
Commented Apr 6, 2016 at 13:28 — MonkeyZeus
– MonkeyZeus, Commented Apr 6, 2016 at 13:28

Saty · Accepted Answer · 2016-04-06 13:29:25Z

2

Closing ) issue

$result = mysqli_query($dbc, $query) or trigger_error("Veri yükleme başarısız: " . mysqli_error($dbc));
                                ^^^^^// close it here instead of last

answered Apr 6, 2016 at 13:29

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

php insert into mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related