收藏
批改狀態(tài)：合格
老師批語：下次把注釋寫上, 時(shí)間長了,你都不知寫了什么?
把原來的php array中的數(shù)據(jù)改為database存放.
1.$sql = 'sql語句'; //設(shè)置SQL語句
2. $preobj = $pdo->prepare($sql) // 建立預(yù)處理對(duì)象
3.$preobj->execute(); //執(zhí)行
4. $arr = $preobj->fetch/fetchAll(PDO::FETCH_ASSOC) //把數(shù)據(jù)存放到數(shù)組中
<?php //connect to database first require __DIR__ . '/../db/connect.php'; //get foods data from database $sql = 'SELECT * FROM `lives`'; //prepare $preObj = $pdo->prepare( $sql ); //execute $preObj->execute(); //input to array $foods = $preObj->fetchAll( PDO::FETCH_ASSOC ); //get category data from database $sql = 'SELECT * FROM `category`'; $preObj = $pdo->prepare( $sql ); $preObj->execute(); $cates = $preObj->fetchAll( PDO::FETCH_ASSOC ); //count array length $cate_count = count( $cates ); $sql = 'SELECT * FROM `system` LIMIT 1'; $preObj = $pdo->prepare( $sql ); $preObj->execute(); $system = $preObj->fetch( PDO::FETCH_ASSOC ); //fetchAll ->using in 多維數(shù)組, fetch->using in 1維數(shù)組 //fetch + LIMIT = fetch ?> <!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <link rel="stylesheet" href="../css/style.css"> <meta name="description" content="<?php echo $system['desc'] ?>"> <meta name="keywords" content="<?php echo $system['key'] ?>"> <title><?php echo $system['title'] ?></title> </head> <body> <div class="header"> <ul class="nav"> <li><a href="index.php">HomePage</a></li> <?php foreach ( $cates as $cate ) : ?> <li><a href="list.php?cat_id=<?php echo $cate['cat_id']; ?>"><?php echo $cate['alias'] ?></a></li> <?php endforeach; ?> </ul> </div>
點(diǎn)擊 "運(yùn)行實(shí)例" 按鈕查看在線實(shí)例
微信掃碼
關(guān)注PHP中文網(wǎng)服務(wù)號(hào)
技術(shù)交流群
QQ掃碼
加入技術(shù)交流群
Copyright 2014-2025 http://ipnx.cn/ All Rights Reserved | php.cn | 湘ICP備2023035733號(hào)