/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 vote87 views1 answer
Laravel api get controller
PHP
0 vote131 views1 answer
Php copy image from remote to local server
PHP
9 votes101 views3 answers
Laravel with select
PHP
-1 vote139 views2 answers
Strings functions php
PHP
0 vote97 views1 answer
Wp_query limit 1
PHP
1 vote96 views1 answer
How handle the number with k in laravel balde
PHP
2 votes101 views1 answer
You can also run `php --ini` in a terminal to see which files are used by PHP in CLI mode. Alternatively, you can run Composer with `--ignore-platform-req=ext-mb
PHP
0 vote103 views1 answer
Wp php get rows number from mysql
PHP Wordpress
1 vote115 views1 answer
How can set defult value for yield in laravel
PHP Laravel
0 vote97 views2 answers
Smtp server xampp
PHP