Emu
-
Posts
5 -
Joined
-
Last visited
Posts posted by Emu
-
-
2 minutes ago, Barand said:
You have a database named "*" !?
No. I just changed all of that info.
-
9 minutes ago, Barand said:
Put this line of code immediately before your line containing mysqli_connect
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
That should get itt to report automatically any mysqli errors (such as the prepare() failing.
Fatal error: Uncaught mysqli_sql_exception: Table '*.register' doesn't exist in /var/www/html/insert.php:20 Stack trace: #0 /var/www/html/insert.php(20): mysqli->prepare('INSERT Into reg...') #1 {main} thrown in /var/www/html/insert.php on line 20
I have the table made in phpmyadmin, but it isn't under mysql structure. That shouldn't be the problem, right?
-
Fatal error: Uncaught Error: Call to a member function bind_param() on bool in /var/www/html/insert.php:21 Stack trace: #0 {main} thrown in /var/www/html/insert.php on line 21
-
I am making a simple form, but when trying to send all the information to my database the code doesn't seem to work. I don't know how much about php and would appreciate if you could check what the problem is. When I displayed errors it said the error is in the 21. line with $stmt->bind_param.
<?php ini_set('display_errors', 1); $gender = $_POST['gender']; $opinionb = $_POST['opinionb']; $opinionn = $_POST['opinionn']; $host = "localhost"; $dbUsername = "*"; $dbPassword = "*"; $dbname = "*"; $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname); if (mysqli_connect_error()) { die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error()); } else { $INSERT = "INSERT Into register (gender, opinionb, opinionn) values(?, ?, ?)"; $stmt = $conn->prepare($INSERT); $stmt->bind_param('sss', $gender, $opinionb, $opinionn); $stmt->execute(); } ?>
HTML Form to phpmyadmin error
in PHP Coding Help
Posted · Edited by Emu
Found solution
Fatal error: Uncaught mysqli_sql_exception: Table 'test.register' doesn't exist in /var/www/html/insert.php:20 Stack trace: #0 /var/www/html/insert.php(20): mysqli->prepare('INSERT Into reg...') #1 {main} thrown in /var/www/html/insert.php on line 20
Still throws out this.
Found the problem. Had the register name wrong.