本文介绍了使用php从mysql中检索数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
I am doing one project using php. I want retrieve data from mysql table order by payment plan1,plan2,plan3,Free using php. How?
解决方案
// Initializing connection data.
$host_db = 'localhost';
$name_db = 'article_db';
$user_db = 'username';
$pass_db = 'password';
try {
// Connecting using the PDO object.
$connection = new PDO("mysql:host=$host_db; dbname=$name_db", $user_db, $pass_db);
// Setting the query and runnin it...
$sql = "SELECT * FROM `article` WHERE `category` = 5 ORDER BY 3";
$result = $connection->query($sql);
// Iterating over the data and printing it.
foreach($result as $row) {
echo $row['id']. ' - '. $row['name']. ' - '. $row['category']. ' - '. $row['editor']. '<br />';
}
// Closing the connection.
$connection = null;
}
// Catching it if something went wrong.
catch(PDOException $e) {
echo $e->getMessage();
}
这篇关于使用php从mysql中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！