Intranet :http://manas9/BareBone_MySQL/Mysqli_query_Tool.php
On Line MySQL-Query-with-PHP ||
IIS in windows 8.1 FastCGI Connecting as
new mysqli("server", "user", "pwd", "test");
Using Object Oriented Style
$conn->query($sql);
$result= $conn->query($sql); re-load()||

SELECT * FROM emp

:" . $sql .""; // //$conn = new mysqli("Manas9", "Manas9", "Manas9237", "world"); $conn = new mysqli("Manas9", "Manas9", "Manas9237", "test"); // if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } // $result= $conn->query($sql); if($result){ echo "
db connected"; } // $fieldcount=mysqli_num_fields($result); echo "Field Count : ". $fieldcount. "
"; //$row = $result->fetch_array(MYSQLI_ASSOC); echo " fetch_array(MYSQLI_ASSOC) worked"; // echo ""; echo ""; //$ncols = oci_num_fields($stmt); for Oracle oci8 $finfo = $result->fetch_fields(); // creating a table hearer with column names //for ($i = 0; $i <= $fieldcount; $i++) { foreach ($finfo as $val) { $column_name = $val->name; echo ""; } // echo "

".$column_name."

\n"; // echo "\n"; //while ($row = $result->fetch_row()) { while ($row = $result->fetch_array(MYSQLI_ASSOC)) { // for loop starts foreach ($row as $item) { //echo "\n"; echo "\n"; } //foreach ends echo "\n"; // }// while loop ends echo "

".($item !== null ? htmlentities($item, ENT_QUOTES):" ")."

".($item)."

\n"; // $row_count=$result->num_rows; echo "row count " . $row_count; // $result->free(); $conn->close(); echo "
database connection closed"; }//isset block ends ?> Also See: "Mysqli_query_Tool14.PHP"
for procedural script