Jump to content

HTML Form to phpmyadmin error


Emu

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();
}
?>
Link to comment
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
Link to comment
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
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

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.