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

query php

Add Answer

Clean Code Dev answered on February 5, 2020 Popularity 10/10 Helpfulness 5/10

answer query php

related query sql in php

related php query

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

Closely Related Answers

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

Link to this answer
Share Copy Link

Contributed on Feb 05 2020

Terrible Toucan

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 php

Contents

More Related Answers

query php

Closely Related Answers

query sql in php

php query

Grepper

Documentation

Social

Legal

Contact

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