Aquí tenemos un ejemplo básico para conectarnos desde PHP a mysql, podemos implementarlo fácilmente y probarlo en nuestro servidor web:
https://www.w3schools.com/php/php_mysql_connect.asp
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | <?php$servername = "localhost";$username = "username";$password = "password";// Create connection$conn = new mysqli($servername, $username, $password);// Check connectionif ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);}echo "Connected successfully";?> |
Una vez conectados podemos hacer una consulta y mostrarla por pantalla:
https://www.w3schools.com/PhP/php_mysql_select.asp
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <?php$servername = "localhost";$username = "username";$password = "password";$dbname = "myDB";// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);}$sql = "SELECT id, firstname, lastname FROM MyGuests";$result = $conn->query($sql);if ($result->num_rows > 0) {// output data of each rowwhile($row = $result->fetch_assoc()) {echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";}} else {echo "0 results";}$conn->close();?> |
Comentarios recientes