Tell me how to execute an sql query? How to fetch its result?
- 1 Answers
- 1053 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sanjeev Aherwar
"To execute an SQL query, you can use PHP's MySQL extension. Here is an example: nn$db = new mysqli("localhost", "username", "password", "database");nif ($db->connect_error) {n die("Connection failed: " . $db->connect_error);n}nn$sql = "SELECT * FROM table";n$result = $db->query($sql);nnWhile ($row = $result->fetch_assoc()) {n echo $row['columnName'];n}""
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List some features of php that are deprecated in php7?
What is the difference between htmlentities() and htmlspecialchars()?
What is difference between static and final in php?
Write a program using while loop?
sort term descripttion form, report and uery
How to calculate the difference between two dates using php?
What is the current stable version of php? What advance thing in php7?
How to create a web form?
how to detect a mobile device using php
What is the current stable version of php?
if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer
What is trait in php?
How can we extract string "pcds.co.in" from a string "https://info@pcds.co.in" using regular expression of php? More on reg can you explain
hello all, I need some sample placement papers in lion bridge.. can anyone help me?
Name and explain five of the PHP error constants?
