Jump to content
Emu

HTML Form to phpmyadmin error

Recommended Posts

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();
}
?>

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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?

Edited by Emu

Share this post


Link to post
Share on other sites
2 minutes ago, Barand said:

You have a database named "*" !?

No. I just changed all of that info.

Share this post


Link to post
Share on other sites
8 minutes ago, Barand said:

So does it now work OK?

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.

Edited by Emu
Found solution

Share this post


Link to post
Share on other sites

From command line:

mysql -u <root user> -p

>use test;

>show tables;

Post that output.

Edited by gw1500se

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.