Ajutor in legatura cu baza de date
Last Updated: Aug 08 2018 16:24, Started by
deeszilard
, Aug 02 2018 14:13
·
0
#1
Posted 02 August 2018 - 14:13
Urmez un tutorial despre baza date si incerc sa fac o baza de date cum este in tutorial dar imi apare eroarea respectiva din imagine.
Sistemul de operare folosit este Windows 10(xampp) si cel din tutorial este Mac. Attached FilesEdited by deeszilard, 02 August 2018 - 14:15. |
#3
Posted 03 August 2018 - 11:06
<?php $connection = mysql_connect("localhost","root","Maxishine"); if (!$connection){ die("Database connection failed: " . mysql_error()); } $db_select = mysql_select_db("widget_corp",$connection); if (!$db_select){ die("Database connection failed: " . mysql_error()); } ?> <html> <head> <title>Basic</title> </head> <body> <?php $result = mysql_query("SELECT * FROM subjects", $connection); if (!$result){ die("Database connection failed: " . mysql_error()); } while ($row = msql_fetch_array($result)){ echo $row["menu_name"]." ".$row["position"]. "<br />"; } ?> </body> </html> <?php mysql_close($connection); ?>Am mai avut o eroare in legatura cu baza de date. Am citit pe internet ca cei care au XAMPP si versiunea a 7 al PHP-ului mysql se inlocuieste cu mysqli si am inlocuit peste tot si la error si tot imi da eroare. Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\php_sandbox\databases.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\php_sandbox\databases.php on line 2 Edited by deeszilard, 03 August 2018 - 11:08. |
#4
Posted 08 August 2018 - 16:24
deeszilard, on 03 august 2018 - 11:06, said: <?php $connection = mysql_connect("localhost","root","Maxishine"); if (!$connection){ die("Database connection failed: " . mysql_error()); } $db_select = mysql_select_db("widget_corp",$connection); if (!$db_select){ die("Database connection failed: " . mysql_error()); } ?> <html> <head> <title>Basic</title> </head> <body> <?php $result = mysql_query("SELECT * FROM subjects", $connection); if (!$result){ die("Database connection failed: " . mysql_error()); } while ($row = msql_fetch_array($result)){ echo $row["menu_name"]." ".$row["position"]. "<br />"; } ?> </body> </html> <?php mysql_close($connection); ?>Am mai avut o eroare in legatura cu baza de date. Am citit pe internet ca cei care au XAMPP si versiunea a 7 al PHP-ului mysql se inlocuieste cu mysqli si am inlocuit peste tot si la error si tot imi da eroare. Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\php_sandbox\databases.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\php_sandbox\databases.php on line 2 Eroarea este datorata faptului ca folosesti o functie pe care nu o gaseste. Daca tot vrei sa folosesti mysqli, atunci in loc de mysql_query, foloseste mysqli_query Ce iti recomand eu, in loc sa adaugi informatii sensibile de conectare la mysql in fiecare fisier, mai bine folosesti un require. Concret: 1. creaza un fisier denumit dbconnect.php, iar in el scrie asta: $servername = "localhost"; //de obicei este localhost, doar daca faci remote sql pui IP-ul serverului de SQL $username = "unuser"; // username baza de date $password = "oparola"; // parola username $dbname = "example"; //baza de date // Creare conexiune $conn = new mysqli($servername, $username, $password, $dbname); // Verificam conexiunea if ($conn->connect_error) { die("Conexiune esuata: " . $conn->connect_error); } 2. la inceputul fisierului, dupa tagul <?php adauga asa: require_once 'dbconnect.php'; 3. Orice query il rulezi asa apeland conexiunea la baza de date: $testquery = "SELECT * FROM users"; if ($result = mysqli_query($conn, $testquery)) { if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_array($result)) { $userName = $row['userName']; echo $userName; } } else { echo "No result found"; } } Edited by Kriogen, 08 August 2018 - 16:26. |
Anunturi
Bun venit pe Forumul Softpedia!
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users