Menu
Community /Pin to ProfileBookmark
@NogDogApr 22.2014 — #Get rid of the line in red!
@NogDogApr 22.2014 — #
There are many ways to do it, of course. One way would be to create different HTML/PHP "template" files, and require() them based on the circumstance. So you might have a "success" template you would require() at the end if everything worked and you go there okay. If you hit an error condition, you would instead require() an "error" template, that might look for an $error variable for the message to display, which you would set in the main script. Simplified example:
main script:
error.php:
mysqli_query(): Couldn’t fetch mysqli
Hi guys I know this might be a repeated post, someone has looked at the code and they seem to think that it all look fine, but I’m getting this following message again
Warning: mysqli_query(): Couldn’t fetch mysqli in C:xampphtdocssubmit-form.php on line 19
The following SQL Failed INSERT INTO ‘users’ (‘firstname’, ‘lastname’, ‘username’, ‘confirmusername’, ‘password’, ‘confirmpassword’, ’email’ ,’confirmemail’) VALUES (‘richard’, ‘Hemmings’, ‘hemmo001’, ‘hemmo001’, ‘password’, ‘password’, ‘
I just cant seem to see where I’m going wrong, at first there was a single quote missing from firstname’ this I have now addressed, I’ve been woriking on this now for 2 weeks today!
Config.php
[CODE]<?php
$connection = mysqli_connect(“localhost”,”root”,””,”registration”);
// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
mysqli_close($connection);
?>
?>
submit-form.php
[CODE]<?php
$connection = mysqli_connect(“localhost”, “root”, “”, “registration”) or die(“Error!!”);
//select your database
//$b=mysql_select_db(“database_name”,$a);
$firstname=$_POST[‘firstname’];
$lastname=$_POST[‘lastname’];
$username=$_POST[‘username’];
$confirmusername=$_POST[‘confirmusername’];
$password=$_POST[‘password’];
$confirmpassword=$_POST[‘confirmpassword’];
$email=$_POST[’email’];
$confirmemail=$_POST[‘confirmemail’];
//Database connection
require_once(“config.php”);
//mysql query to insert value to database
$query=”INSERT INTOTO ‘users’ (‘firstname’, ‘lastname’, ‘username’, ‘confirmusername’, ‘password’, ‘confirmpassword’, ’email’ ,’confirmemail’) VALUES (‘$firstname’, ‘$lastname’, ‘$username’, ‘$confirmusername’, ‘$password’, ‘$confirmpassword’, ‘$email’ , ‘$confirmemail’)”;
$result = mysqli_query($connection,$query);
//if value inserted successyully disply success message
if(!$result) {
die(“The following SQL Failed $query”);
}
echo ‘Registred successfully..!!</div>’;
?>
Any help would be appreicated
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogApr 22.2014 — #Get rid of the line in red!<i>
</i><?php
$connection = mysqli_connect("localhost","root","","registration");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
[COLOR="#B22222"][B]mysqli_close($connection);[/B][/COLOR]
?>
0
@NogDogApr 22.2014 — #...
Just one more quick question instead of having "failed to connect" or "Registred successfully..!!" I want to show the web pages instead of white pages.
How would I go about doing this?[/QUOTE]
There are many ways to do it, of course. One way would be to create different HTML/PHP "template" files, and require() them based on the circumstance. So you might have a "success" template you would require() at the end if everything worked and you go there okay. If you hit an error condition, you would instead require() an "error" template, that might look for an $error variable for the message to display, which you would set in the main script. Simplified example:
main script:
[code=php]
<?php
// lots of stuff happens, then...
$result = mysqli_query($foo, $bar);
if($result == false) {
error_log(mysqli_error($foo));
$error = "Sorry, there was an unexpected database error."
require "error.php";
exit;
}
// ... more stuff happens, then if all is okay...
require 'success.php';
[/code]error.php:
[code=php]
<!DOCTYPE html>
<html><head><title>Error!</title></head>
<body>
<p class='error'><?php
if(!empty($error)) {
echo $error;
}
else {
echo "We're sorry, but an unexpected error occurred."
}
?></p>
<p><a 'href=/main_script.php'>Back to whatever you call the page</a></p>
</body>
</html>
[/code]