Description:Object Oriented Style
On Line MySQL-Query-with-PHP ||
IIS in windows 7 ultimate workstation connecting as
new mysqli("server", "user", "pwd", "test");
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(); //for ($i = 1; $i <= $fieldcount; $i++) { foreach ($finfo as $val) { $column_name = $val->name; echo ""; } // echo "

".$column_name."

\n"; // echo "\n"; // while ($row = $result->fetch_row()) { // echo("
". $row[0]."   ". $row[1]."    ". $row[2]."    ". $row[3]."    ". $row[4]); // for loop starts foreach ($row as $item) { echo "\n"; } //foreach ends echo "\n"; // }// while loop ends echo "

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

\n"; // $result->free(); $conn->close(); echo "
database connection closed"; }//isset block ends ?>