Discutii despre tot ce nu se incadreaza in celelalte categorii.
Moderators: Moderatori ajutatori, Moderatori
-
mihaiciuraru
- Membru, skill 0
- Posts: 23
- Joined: 20 Aug 2015, 13:28
- Detinator Steam: Da
- Detinator server CS: Furien.Online
- Fond eXtream: 0
- Location: UK
- Discord: Hokage'sama#1269
-
Contact:
01 Dec 2015, 12:01
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
Last edited by
Bloo# on 01 Dec 2015, 12:06, edited 1 time in total.
Reason: ti-am pus textul in "code" ca sa se inteleaga si titlu editat
-
The Kalu
- Fost administrator
- Posts: 13712
- Joined: 09 Oct 2010, 12:39
- Detinator Steam: Da
- CS Status: In grajd!
- SteamID: kalulord
- Reputatie: Fost Administrator
Fost membru Club eXtreamCS (6 luni)
Nume anterior: Terra
- Location: Romania, Ploiesti
- Has thanked: 328 times
- Been thanked: 646 times
-
Contact:
01 Dec 2015, 13:25
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
- Membru, skill 0
- Posts: 23
- Joined: 20 Aug 2015, 13:28
- Detinator Steam: Da
- Detinator server CS: Furien.Online
- Fond eXtream: 0
- Location: UK
- Discord: Hokage'sama#1269
-
Contact:
01 Dec 2015, 15:59
( ! ) 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
- Fost administrator
- Posts: 13712
- Joined: 09 Oct 2010, 12:39
- Detinator Steam: Da
- CS Status: In grajd!
- SteamID: kalulord
- Reputatie: Fost Administrator
Fost membru Club eXtreamCS (6 luni)
Nume anterior: Terra
- Location: Romania, Ploiesti
- Has thanked: 328 times
- Been thanked: 646 times
-
Contact:
01 Dec 2015, 16:00
Inseamna ca nu ai pus corect datele de la serverul mysql.
-
mihaiciuraru
- Membru, skill 0
- Posts: 23
- Joined: 20 Aug 2015, 13:28
- Detinator Steam: Da
- Detinator server CS: Furien.Online
- Fond eXtream: 0
- Location: UK
- Discord: Hokage'sama#1269
-
Contact:
01 Dec 2015, 16:07
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
- Membru, skill +1
- Posts: 438
- Joined: 14 Nov 2015, 14:49
- Detinator Steam: Da
- CS Status: Road to Nova II
- Detinator server CS: Nu
- SteamID: Privat
- Fond eXtream: 0
- Location: Dabuleni
-
Contact:
01 Dec 2015, 16:31
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.
My name isn't Santa but you stain' my lap.
-
zigweed
- Membru, skill +3
- Posts: 1094
- Joined: 27 Oct 2015, 16:35
- Detinator Steam: Da
- SteamID: zshare
- Reputatie: Fost Membru Club eXtreamCS ( o luna )
- Fond eXtream: 0
- Location: Bucuresti
- Has thanked: 2 times
- Been thanked: 13 times
-
Contact:
01 Dec 2015, 16:44
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
- Membru, skill 0
- Posts: 23
- Joined: 20 Aug 2015, 13:28
- Detinator Steam: Da
- Detinator server CS: Furien.Online
- Fond eXtream: 0
- Location: UK
- Discord: Hokage'sama#1269
-
Contact:
01 Dec 2015, 17:14
Aici am modificat cu linia spusa de dl. "zigweed".
Aici am acordat toate permisiunile.
Cum am facut tabelele !
Err conectare DB !
Last edited by
mihaiciuraru on 01 Dec 2015, 19:26, edited 1 time in total.
-
mihaiciuraru
- Membru, skill 0
- Posts: 23
- Joined: 20 Aug 2015, 13:28
- Detinator Steam: Da
- Detinator server CS: Furien.Online
- Fond eXtream: 0
- Location: UK
- Discord: Hokage'sama#1269
-
Contact:
-
zigweed
- Membru, skill +3
- Posts: 1094
- Joined: 27 Oct 2015, 16:35
- Detinator Steam: Da
- SteamID: zshare
- Reputatie: Fost Membru Club eXtreamCS ( o luna )
- Fond eXtream: 0
- Location: Bucuresti
- Has thanked: 2 times
- Been thanked: 13 times
-
Contact:
01 Dec 2015, 18:17
Nu inteleg nimic din pozele puse de tine, sunt thumbnail-uri (MICI).
-
mihaiciuraru
- Membru, skill 0
- Posts: 23
- Joined: 20 Aug 2015, 13:28
- Detinator Steam: Da
- Detinator server CS: Furien.Online
- Fond eXtream: 0
- Location: UK
- Discord: Hokage'sama#1269
-
Contact:
01 Dec 2015, 21:14
zigweed Multumesc enorm de mult pentru ajutor multumesc mult ! toata stima mea si tot respectul meu nota 10 ! Multumesc !
-
zigweed
- Membru, skill +3
- Posts: 1094
- Joined: 27 Oct 2015, 16:35
- Detinator Steam: Da
- SteamID: zshare
- Reputatie: Fost Membru Club eXtreamCS ( o luna )
- Fond eXtream: 0
- Location: Bucuresti
- Has thanked: 2 times
- Been thanked: 13 times
-
Contact:
-
Users browsing this forum: Bing [Bot], MDFK. eXtream and 364 guests