Breaking News: Grepper is joining You.com. Read the official announcement!

query sql in php

Add Answer

Terrible Toucan answered on February 5, 2020 Popularity 10/10 Helpfulness 7/10

answer query sql in php

related select sql in php

related query php

related php query

query sql in php

Comment

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();

Popularity 10/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: php sql-in

Link to this answer
Share Copy Link

Contributed on Feb 05 2020

Terrible Toucan

0 Answers Avg Quality 2/10

Closely Related Answers

select sql in php

Comment

<?php
$mysqli = new mysqli("localhost","my_user","my_password","my_db");

if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}

$sql = "SELECT Lastname, Age FROM Persons ORDER BY Lastname";
$result = $mysqli -> query($sql);

// Associative array
$row = $result -> fetch_assoc();
printf ("%s (%s)\n", $row["Lastname"], $row["Age"]);

// Free result set
$result -> free_result();

$mysqli -> close();
?>
//eng.aamirAlshawa

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: php

Link to this answer
Share Copy Link

Contributed on Feb 15 2022

Jolly Jellyfish

0 Answers Avg Quality 2/10

query php

Comment

<?php 
// MySqli connection
$mysqli = new mysqli("localhost", "my_username", "my_password", "my_database");

// Errors
if($mysqli->connect_error) {
  echo "<b>Failed to connect to MySQL: </b>" . $mysqli->connect_error;
}

// Query
$selectQuery = $mysqli->prepare("SELECT * FROM my_table");
$selectQuery->execute();
$selectQueryResult = $selectQuery->get_result();

// Loop 
while($selectQueryRow = $selectQueryResult->fetch_array()) {
  echo $selectQueryRow['my_column'];
}

// Example
$selectUsername = $mysqli->prepare("SELECT * FROM users");
$selectUsername->execute();
$selectUsernameResult = $selectUsername->get_result();
while($selectUsernameRow = $selectUsernameResult->fetch_array()) {
  echo $selectUsernameRow['username'];
}

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: php

Link to this answer
Share Copy Link

Contributed on Oct 06 2020

Clean Code Dev

0 Answers Avg Quality 2/10

php query

Comment

-2

xPaw\SourceQuery\Exception\InvalidPacketException: Failed to read any data from socket in C:\xampp\htdocs\minecraft\vendor\xpaw\php-source-query-class\SourceQuery\BaseSocket.php:50
Stack trace:
#0 C:\xampp\htdocs\minecraft\vendor\xpaw\php-source-query-class\SourceQuery\Socket.php(76): xPaw\SourceQuery\BaseSocket->ReadInternal(Object(xPaw\SourceQuery\Buffer), 1400, Array)
#1 C:\xampp\htdocs\minecraft\vendor\xpaw\php-source-query-class\SourceQuery\SourceQuery.php(212): xPaw\SourceQuery\Socket->Read()
#2 C:\xampp\htdocs\minecraft\View.php(27): xPaw\SourceQuery\SourceQuery->GetInfo()
#3 {main}

Popularity 10/10 Helpfulness 1/10 Language php

Source: henhen1227.com

Tags: php

Link to this answer
Share Copy Link

Contributed on Aug 19 2021

Alive Armadillo

0 Answers Avg Quality 2/10

query sql in php

Contents

More Related Answers

query sql in php

Closely Related Answers

select sql in php

query php

php query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.