Nie mogę rozwiązać tego problemu (tytuł). Szukałem odpowiedzi na ten problem, ale nigdzie go nie znalazłem.
Register.php:
<?php
include "db.php";
extract($_POST);
$fname = str_replace($link, "'","`",$fname);
$fname = mysqli_real_escape_string($fname);
$lname = str_replace($link, "'","`",$lname);
$lname = mysqli_real_escape_string($link,$lname);
$username = str_replace($link, "'","`",$username);
$username = mysqli_real_escape_string($link,$username);
$password = str_replace($link, "'","`",$password);
$password = mysqli_real_escape_string($link,$password);
$password = md5($link,$password);
mysqli_query($connect, "INSERT INTO tbluser (fname,lname,gender)VALUES('$fname','$lname','$gender','$')");
//$sql = "INSERT INTO `tbluser`(`fname`, `lname`, `gender`) VALUES ('$fname','$lname','$gender')";
$result = mysqli_query($sql);
if(mysqli_affected_rows($connect) > 0){
echo '<p>Employee Added </p>';
echo '<a href="index.html">Go Back</a>';
} else {
echo 'Employee NOT Added<br />';
echo mysqli_error ($connect);
}
if($result)
{
$a = mysqli_query("SELECT * FROM `tbluser` WHERE `fname` = '$fname' ");
$aa = mysqli_fetch_array($a);
if($a)
{
$aaa = $aa['user_Id'];
$sql = "INSERT INTO `tblaccount`(`username`, `password`, `user_Id`) VALUES('$username','$password',$aaa)";
$res = mysqli_query($sql);
if($res==true)
{
echo '<script language="javascript">';
echo 'alert("Successfully Registered")';
echo '</script>';
echo '<meta http-equiv="refresh" content="0;url=../index.php" />';
}
}
}
?>
db.php:
<?php
$host = "localhost";
$user = "root";
$pwd = "";
$db = "dbforum";
$link = mysqli_connect("localhost", "root", "", "dbforum") or die($link);
//$con = mysqli_connect($host,$user,$pwd) or die("Could not connect");
//$con = mysqli_select_db($db,$con) or die("No database");
$connection = mysqli_connect("localhost", "root", "", "dbforum");
if (!$connection) {
die("Database connection failed: " . mysqli_connect_error());
}
// Selecting a database
$db = mysqli_select_db($connection, "dbforum");
if (!$db) {
die("Database selection failed: " . mysqli_connect_error());
}
?>