/PHP/Connecting to database and performing sql queries

Connecting to database and performing sql queries

<?php 
//Connecting to the database
$conn =  mysqli_connect('localhost', 'root', '', 'peroHub');

if(!$conn){
    echo "Error in connection: " . mysqli_connect_error();
}

$sql = 'SELECT title, ingredients, id FROM pizzas';

$result = mysqli_query($conn, $sql);


$pizza = mysqli_fetch_all($result, MYSQLI_ASSOC);

//free result from memory
mysqli_free_result($result);

//close connection
mysqli_close($conn);

// print_r($pizza);


?>

Source: stackoverflow.com

Similar codes

0 vote212 views1 answer
Trim specific character from strin using php
PHP
1 vote180 views3 answers
Php artisan create controller inside folder
PHP
0 vote169 views1 answer
Singular from table laravel
PHP Laravel
1 vote201 views1 answer
How to change laravel 8 login credentials
PHP Laravel
0 vote205 views1 answer
Pure Intersection Types - PHP 8.1
PHP
1 vote213 views2 answers
Modularizing laravel 8.0
PHP Laravel
0 vote240 views1 answer
Wp wc php use comma separated thousands
PHP Wordpress
-1 vote175 views1 answer
Woocommerce check if cart is not empty
PHP
2 votes211 views1 answer
Retrieving a cookie in php
PHP
-1 vote215 views1 answer
Php mysql row to json
PHP