eroare inregistrare

[mihaiciuraru]

Am niste err la o pagina de inregistrare !

Code: Select all

----------------------------------------------------------------------------------------------
( ! ) Notice: Undefined variable: connection in C:\wamp\www\index.php on line 49
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0

-----------------------------------------------------------------------------------------------
( ! ) Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www\index.php on line 49
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
2	0.0240	156736	mysqli_query ( )	..\index.php:49

-----------------------------------------------------------------------------------------------
( ! ) Notice: Undefined variable: connection in C:\wamp\www\index.php on line 50
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
-----------------------------------------------------------------------------------------------
( ! ) Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www\index.php on line 50
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
2	0.0300	156824	mysqli_query ( )	..\index.php:50
-----------------------------------------------------------------------------------------------
( ! ) Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\wamp\www\index.php on line 51
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
2	0.0350	157000	mysqli_num_rows ( )	..\index.php:51
-----------------------------------------------------------------------------------------------
( ! ) Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\wamp\www\index.php on line 54
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
2	0.0380	157008	mysqli_num_rows ( )	..\index.php:54
-----------------------------------------------------------------------------------------------
( ! ) Notice: Undefined variable: connection in C:\wamp\www\index.php on line 65
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
-----------------------------------------------------------------------------------------------
( ! ) Fatal error: Call to a member function query() on a non-object in C:\wamp\www\index.php on line 65
Call Stack
#	Time	Memory	Function	Location
1	0.0070	148032	{main}( )	..\index.php:0
-----------------------------------------------------------------------------------------------


Astea sunt err. 

Index.php

<?PHP
	if(isset($_POST['submit'])) {
		$real_name = $_POST['real_name'];
		$username = $_POST['username'];
		$email = $_POST['email'];
		$password = $_POST['password'];
		$password2 = $_POST['password2'];
		$social_id = $_POST['social_id'];
		
		if(empty($real_name) || empty($username) || empty($email) || 
			empty($password) || empty($password2) || empty($social_id)) {
			echo '<font color="red">Completează toate câmpurile corect.</font><hr></br>';
		}
		elseif(!preg_match("/^([ \x{00C0}-\x{01FF}a-zA-Z\'\-])+$/u", $real_name)) {
			echo '<font color="red">Te rog să introduci un nume valid.</font><hr></br>';
		}
		elseif(!filter_var($email, FILTER_VALIDATE_EMAIL)) {
			echo '<font color="red">Te rog să introduci o adresă de e-mail validă.</font><hr></br>';
		}
		elseif($password != $password2) {
			echo '<font color="red">Mai încearcă!Parolele nu corespund.</font><hr></br>';
		}
		else {
			$existing_user = "SELECT login FROM account WHERE login = '".$username."'";
			$existing_email = "SELECT email FROM account WHERE email = '".$email."'";
			$check_user = mysqli_query($connection, $existing_user);
			$check_email = mysqli_query($connection, $existing_email);
			if(mysqli_num_rows($check_user) != 0) {
				echo '<font color="red">Acest cont este deja înregistrat.</font><hr></br>'; 
			}
			elseif(mysqli_num_rows($check_email) != 0) {
				echo '<font color="red">Verifica m-eilul ! E deja luat !</font><hr></br>'; 
			}
			elseif(strlen($real_name) > 30 || strlen($real_name) < 3 ||
				strlen($username) > 16 || strlen($username) < 5 ||
				strlen($password) > 16 || strlen($password) < 5 ||
				strlen($email) > 40 ||
				strlen($social_id) != 7) {
				echo '<font color="red">Verifică din nou cerințele pentru fiecare domeniu.</font><hr></br>';
			}
			else {
				$connection->query("SET NAMES utf8");
				$sql = "INSERT INTO account SET login = '".$username."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'";
				$result = mysqli_query($connection, $sql);
				if($result) { 
					echo '<font color="green">Contul a fost înregistrat cu succes.</font><hr></br>'; 
				}
				else { 
					echo '<font color="red">Eroare la înregistrare. Te rog să încerci mai târziu sau contactează un administrator.</font><hr></br>'; 
				}					
			}
		}
	}
?>
		<label>Nume real:</label>
		<input type="text" name="real_name" placeholder="Nume real" maxlength="30" />
				
		<label>Utilizator: </br><small>(Între 5 și 16 caractere)</small></label>
		<input type="text" name="username" placeholder="Utilizator" maxlength="16" />
		
		<label>E-Mail:</label>
		<input type="text" name="email" placeholder="E-Mail" maxlength="40" />
		
		<label>Parolă: </br><small>(Între 5 și 16 caractere)</small></label>
		<input type="password" name="password" placeholder="Parolă" maxlength="16" />
		
		<label>Repetă parola:</label>
		<input type="password" name="password2" placeholder="Repetă parola" maxlength="16" />
		
		<label>Numele Mamei/Tatei: </br><small>(ex: Marcele,Vasilica,Ioana etc..)</small></label>
		<input type="text" name="social_id" placeholder="Cod ștergere caractere" maxlength="7" />
		<br>
		<br>
		
		<div class="submit_btn_wrapper">
			<input type="submit" name="submit" class="btn_submit" value="ÎNREGISTRARE" />
		</div>
	</form>
</div>

1. intrebare cum ar trebui sa fac baza de date ca sa se poata connecta formularul la baza de date am incercat dar nu merge .. daca e cineva care ma poate ajuta cu problema !
Mulțumesc ! :D

[The Kalu]

Code: Select all

<?php

    $connection = mysqli_connect("localhost","my_user","my_password","my_db");

    if (mysqli_connect_errno()){

          print "Failed to connect to MySQL: " . mysqli_connect_error();

     }

    if(isset($_POST['submit'])){

        $real_name         = filter_var($_POST['real_name'], FILTER_SANITIZE_STRING);
        $username          = filter_var($_POST['username'], FILTER_SANITIZE_STRING);
        $email             = filter_var($_POST['email'], FILTER_VALIDATE_EMAIL);
        $password         = filter_var($_POST['password'], FILTER_SANITIZE_STRING);
        $password       = filter_var($_POST['password2'], FILTER_SANITIZE_STRING);
        $social_id         = filter_var($_POST['social_id'], FILTER_SANITIZE_STRING);

        $post_field = array('real_name', 'username', 'email', 'password', 'password2', 'social_id');

        $error = false;

        foreach($required as $field) {
          
              if(empty($_POST[$post_field])) {
        
                $error = true;
          
              }
        }

        if($error){

            print 'Completează toate câmpurile!';

        } elseif ($password != $password2) {

            print 'Mai încearcă!Parolele nu corespund.';
        
        } elseif(!preg_match("/^([ \x{00C0}-\x{01FF}a-zA-Z\'\-])+$/u", $real_name)) {

             print 'Te rog să introduci un nume valid.';

          } else {

              $check_user = mysqli_query($connection, "SELECT `login` FROM `account` WHERE `login` = '".$username."'");

              $check_email = mysqli_query($connection, "SELECT `email` FROM `account` WHERE `email` = '".$email."'");

              if(mysqli_num_rows($check_user) > 0){

                  print 'Acest cont este deja înregistrat.';

              } elseif (mysqli_num_rows($check_email) > 0) {

                  print 'Verifica e-mailul ! E deja luat ';

              } elseif(strlen($real_name) > 30 || strlen($real_name) < 3 ||
            strlen($username) > 16 || strlen($username) < 5 ||
            strlen($password) > 16 || strlen($password) < 5 ||
            strlen($email) > 40 ||
            strlen($social_id) != 7) {
                
                print 'Verifică din nou cerințele pentru fiecare domeniu.';

             } else {

                  $sql = mysqli_query($connection,"INSERT INTO account SET login = '".$username."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'");
                    
                    if($sql) {

                           print 'Contul a fost înregistrat cu succes.';
                    } else {

                           print 'Eroare la înregistrare. Te rog să încerci mai târziu sau contactează un administrator.';
                    }  

             }


          }


    }

?>

[mihaiciuraru]

( ! ) Warning: mysqli_connect(): in C:\wamp\www\index.php on line 24
Call Stack
# Time Memory Function Location
1 0.0000 145344 {main}( ) ..\index.php:0
2 0.0156 153272 mysqli_connect ( ) ..\index.php:24
Failed to connect to MySQL: Acc�s refus� pour l'utilisateur: 'my_user'@'@localhost' (mot de passe: OUI)

??? ce inseamna ?

[The Kalu]

Inseamna ca nu ai pus corect datele de la serverul mysql.

[mihaiciuraru]

idnex.php

| Afiseaza codul

-----------------------------------------------------------------------------------------------------------------
<?PHP
	include('config.php');
?>

<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<meta charset="utf-8">
	<!-- <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> -->
	<meta name="description" content="MMORPG Metin2">
	<meta name="viewport" content="width=device-width">

	<title>Bliz.Ml</title>
	<link rel="stylesheet" href="style.css">
</head>
<body>
<div id="registerForm">
	<h1>Bliz.Ml</h1>
	<h1>Inregistrează-te pe Bliz.Ml !</h1>
	
	<form action="index.php" method="post">
<?php

    $connection = mysqli_connect("localhost","my_user","my_password","my_db");

    if (mysqli_connect_errno()){

          print "Failed to connect to MySQL: " . mysqli_connect_error();

     }

    if(isset($_POST['submit'])){

        $real_name         = filter_var($_POST['real_name'], FILTER_SANITIZE_STRING);
        $username          = filter_var($_POST['username'], FILTER_SANITIZE_STRING);
        $email             = filter_var($_POST['email'], FILTER_VALIDATE_EMAIL);
        $password         = filter_var($_POST['password'], FILTER_SANITIZE_STRING);
        $password       = filter_var($_POST['password2'], FILTER_SANITIZE_STRING);
        $social_id         = filter_var($_POST['social_id'], FILTER_SANITIZE_STRING);

        $post_field = array('real_name', 'username', 'email', 'password', 'password2', 'social_id');

        $error = false;

        foreach($required as $field) {
          
              if(empty($_POST[$post_field])) {
        
                $error = true;
          
              }
        }

        if($error){

            print 'Completează toate câmpurile!';

        } elseif ($password != $password2) {

            print 'Mai încearcă!Parolele nu corespund.';
        
        } elseif(!preg_match("/^([ \x{00C0}-\x{01FF}a-zA-Z\'\-])+$/u", $real_name)) {

             print 'Te rog să introduci un nume valid.';

          } else {

              $check_user = mysqli_query($connection, "SELECT `login` FROM `account` WHERE `login` = '".$username."'");

              $check_email = mysqli_query($connection, "SELECT `email` FROM `account` WHERE `email` = '".$email."'");

              if(mysqli_num_rows($check_user) > 0){

                  print 'Acest cont este deja înregistrat.';

              } elseif (mysqli_num_rows($check_email) > 0) {

                  print 'Verifica e-mailul ! E deja luat ';

              } elseif(strlen($real_name) > 30 || strlen($real_name) < 3 ||
            strlen($username) > 16 || strlen($username) < 5 ||
            strlen($password) > 16 || strlen($password) < 5 ||
            strlen($email) > 40 ||
            strlen($social_id) != 7) {
                
                print 'Verifică din nou cerințele pentru fiecare domeniu.';

             } else {

                  $sql = mysqli_query($connection,"INSERT INTO account SET login = '".$username."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'");
                    
                    if($sql) {

                           print 'Contul a fost înregistrat cu succes.';
                    } else {

                           print 'Eroare la înregistrare. Te rog să încerci mai târziu sau contactează un administrator.';
                    }  

             }


          }


    }

?>
<div class="footer">
    <div id="footerWrapper">
	<div id="footerWrapper">
	<div id="footerWrapper">
	<div id="footerWrapper">
	<div id="footerWrapper">
	<div id="footerWrapper">
	<div id="footerWrapper">
        </div>
        <p class="legal_line">
			Bliz.Ml 
		</p>
    </div>
</div>
</body>
</html>
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
Config.php
<?PHP
$mysqlServer = "localhost";
$mysqlDb = "users";
$mysqlUser = "root";
$mysqlPass = "";

$conn = mysqli_connect($mysqlServer, $mysqlUser, $mysqlPass) or die("failed to connect to db");
mysqli_select_db($conn, $mysqlDb) or die("failed to connect select db");


?>

----------------------------------------------------------------------------------------------------------------------------

Cum adica am pus datele gresite ? Sau vă refereați la datele din tabel ?

[sTraToN]

Ma prietene nu se poate connecta la baza de date, nu ai pus datele de conectare la baza de date corect. Fa o baza de date noua, un user nou, atribuie acel user la baza de date nou creeata si dai toate permisiunile.

[zigweed]

Code: Select all

$connection = mysqli_connect("localhost","my_user","my_password","my_db") or die ("Eroare la conectare DB");

Asta este modul corect de a face treaba.

[mihaiciuraru]

Aici am modificat cu linia spusa de dl. "zigweed".

Aici am acordat toate permisiunile.

Cum am facut tabelele !




Err conectare DB !

[mihaiciuraru]

stie cineva ?

[zigweed]

Nu inteleg nimic din pozele puse de tine, sunt thumbnail-uri (MICI).

[mihaiciuraru]

zigweed Multumesc enorm de mult pentru ajutor multumesc mult ! toata stima mea si tot respectul meu nota 10 ! Multumesc !

[zigweed]

Pentru putin :)