MMSHFE
دوشنبه 07 اسفند 1391, 07:17 صبح
مثال:
1- فايل config.php
<?php
define('HOST', 'localhost');
define('NAME', 'dbname');
define('PASS', '');
define('USER', 'root');
?>
2- فايل test.php
<?php
require_once 'config.php';
function Connect() {
mysql_connect(HOST, USER, PASS) or die('Connection error');
mysql_select_db(NAME) or die('Database error');
mysql_query('SET NAMES \'utf8\'');
mysql_set_charset('utf8');
}
function Escape($value) {
Connect();
return mysql_real_escape_string($value);
}
function Query($query) {
Connect();
return mysql_query($query);
}
if(isset($_GET['name'])) {
$name = Escape($_GET['name']);
$query = "SELECT * FROM `students` WHERE (`name` LIKE '%{$name}%') ORDER BY `id`";
}
else {
$query = 'SELECT * FROM `students` ORDER BY `id`';
}
$info = Query($query);
if($info && mysql_num_rows($info) > 0) {
echo '<table border="1px" width="100%">';
while($item = mysql_fetch_assoc($info)) {
echo '<tr>';
foreach($item as $field) {
echo '<td>' . htmlentities($field, ENT_QUOTES, 'utf-8') . '</td>';
}
echo '</tr>' . PHP_EOL;
}
echo '</table>' . PHP_EOL;
mysql_free_result($info);
}
else {
echo '<p>Not found.</p>' . PHP_EOL;
}
?>