21,886
社区成员
发帖
与我相关
我的任务
分享
CREATE DEFINER=`root`@`localhost` PROCEDURE `News_getAll`()
select * from news;
function News_getAll() {
$allnews = array ();
$i = 0;
$result = mysql_query("select * from news");
while ($row = mysql_fetch_row($result)) {
$allnews[$i] = $row;
$i++;
}
return $allnews;
}
<?php
include "smarty_inc.php";
include "mysql.class.php";
$db = new mysql('localhost', 'root', '', 'tianmei', 'GBK');
$allnews=$db->News_getAll();
$smarty->assign('allnews', $allnews);
$smarty->display('index.html');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title> New Document </title>
</head>
<body>
{foreach item=v from=$allnews }
{$v[0]}
{$v[1]}
{$v[2]}
{$v[3]}<br>
{/foreach}
</body>
</html>
$result = mysql_query("select * from news");
$result = mysql_query("call News_getAll()");
function News_add($title, $cont) {
mysql_query("call News_add('" . $title . "','" . $cont . "')");
}
function News_deleteById($id){
mysql_query("call News_deleteById(".$id.")");
}
function News_modify($title,$cont,$id){
mysql_query("call News_modify('".$title."','".$cont."',".$id.")");
}
$db = new mysql('localhost', 'root', '', 'tianmei', 'GBK');
$db->News_deleteById(18);
$db->News_News_modify('XXX','XXX',18);
$db->News_News_add('XXX','XXXX');