Home > List of blog posts > 12月10日php大作业

Blogger Information

Blog 35

fans 3

comment 0

visits 25133

Special Recommendation

More>

Related recommendations

架构上传

部分源码上传

model

`<?php
namespace model;
use PDO;

//数据连接，数据查询

class Db
{
//数据库连接
private $dsn;
private $user;
private $password;
private $pdo;

public function connect()
{
    try {
        $this->pdo = new PDO($this->dsn, $this->user, $this->password);
    } catch (PDOException $e) {
        die('数据库连接失败，错误信息：' . $e->getMessage());
    }
}
public function __construct($dsn = 'mysql:host=localhost;dbname=phpdzy', $user = 'root', $password = 'root')
{

// $this->pdo = new PDO($dsn,$user,$password);
$this->dsn = $dsn;
$this->user = $user;
$this->password = $password;
$this->connect();

}
//获取用户全部信息
public function seleUsers()
{
    $sql = 'SELECT * FROM `category`';
    $stmt = $this->pdo->prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
// 查询多条记function select($table,$fields='*',$where='',$order='',$limit='// 创建SQL语句

// 查询多条记录
function select($table ,$where = ‘’, $limit = ‘’, $fields = ‘*’, $order = ‘’)
{
// 创建SQL语句
$sql = ‘SELECT ‘;
if (is_array($fields)) {
foreach ($fields as $field) {
$sql .= $field . ‘, ‘;
}
} else {
$sql .= $fields;
}
$sql = rtrim(trim($sql), ‘,’);
$sql .= ‘ FROM ‘ . $table;
// 查询条件
if (!empty($where)) {
$sql .= ‘ WHERE ‘ . $where;
}
// 排序方式
if (!empty($order)) {
$sql .= ‘ ORDER BY ‘ . $order;
}
// 分页
if (!empty($limit)) {
$sql .= ‘ LIMIT ‘ . $limit;
}
$sql .= ‘;’;
// 创建PDO预处理对象
$stmt = $this->pdo->prepare($sql);
// 执行查询操作
if ($stmt->execute()) {
if ($stmt->rowCount() > 0) {
$stmt->setFetchMode(PDO::FETCH_ASSOC);
return $stmt->fetchAll();
}
}
return ‘查询失败’;
}

// 查询单条记录
function find($table,$fields,$where=''){
    $sql = 'SELECT ';
    if(is_array($fields)){
        foreach ($fields as $field){
            $sql .= $field . ', ';
        }
    }else{
        $sql .= $fields;
    }
    $sql = rtrim(trim($sql),',');
    $sql .= ' FROM ' . $table;
    if(!empty($where)){
        $sql .= ' WHERE ' . $where;
    }
    $sql .= ' LIMIT 1;';
    $stmt = $this->pdo->prepare($sql);

// print_r($stmt);
if($stmt->execute()){
if ($stmt->rowCount()>0){
$stmt->setFetchMode(PDO::FETCH_ASSOC);
return $stmt->fetch();
}
}
return ‘查询失败’;
}

}
//
// $db = new Db();
//print_r($db->seleUsers());
//$data =$db->select(‘users’);
////print_r($data);
//查询多条记录
// echo ‘<pre>‘ .print_r($db->select(‘article’),true);

// 查询单条记录

//echo ‘<pre>‘ .print_r($db->find(‘users’,’*’,’user = “gzg”‘ ),true);

//$data =new Db();
//$data1=$data->find(‘users’,’*’,’user=”gzg”‘);
//print_r($data1);

控制

`<?php
namespace ph;
use model\Db;
use view\View1;
require DIR . ‘/Model/model.php’;
require DIR . ‘/View/View.php’;

class indexConter
{

public  function  article($table,$where,$limit)
{
    $art = new Db();
    $art1 =$art->select($table,$where,$limit);

// print_r($art1);

    $view =new View1;
    return $view->getData($art1);
}
public function  category($table,$where,$limit)
{
    $cat =new Db();
    $cat =$cat->select($table,$where,$limit);
    $view =new View1;
    return $view->getData($cat);
}

}
$index =new indexConter();
//$index =new indexConter();
// $res=$index->article(‘article’);
// print_r($res);

//$art = new Db();
//$art1 =$art->select(‘article’);
//print_r($art1);
//exit();`

index

`<?php

use ph\indexConter;
require DIR . ‘/head.php’;
require DIR .’./../indexConter.php’;

//$limit1=$index->article(‘article’,’1’);
$limit9=$index->article(‘article’,’cate_id=1’,’9’);
$limit92=$index->article(‘article’,’cate_id=2’,’9’);
// print_r($limit9);
$cat =$index->category(‘category’,’cate_id=1’,’1’);
$cat1 =$index->category(‘category’,’cate_id=2’,’1’);
$pic =$index->article(‘image’,’’,’’);
$pic_con =$index->article(‘image_conten’,’image_id=1’,’2’);
$pic_con_2 =$index->article(‘image_conten’,’image_id=1’,’2,2’);
$phop = $index->article(‘phop’,’’,’’);
$phop_con = $index->article(‘phop_conten’,’phop_id=1’,’4’);
$phop_con_4 = $index->article(‘phop_conten’,’phop_id=1’,’4,4’);
//print_r($phop);
//print_r($phop_con);
//$id=$pic[‘image_id’];
//print_r($id);
//exit;

//print_r($pic_con_2);
//class article1
//{
//
// public function arct1($art1)
// {
//
// foreach ($art1 as $v) {
// // echo $v[‘title’];
// echo ‘<li><span>[新闻]</span><a href=""> ‘;
// echo $v[‘title’];
// echo ‘<br>‘;
// echo ‘</a></li>‘;
// }
//
// }
//
//
//
//}

//echo ‘1110’;
// $data = new article1( );
// print_r($data->arct1($art1));
//print_r($data);
?>

<div class="content">
    <div class="pic">
        <a href=""><img src="/phpdzy/static/images/news.jpg" alt="" class="first-img"></a>
        <a href=""><img src="/phpdzy/static/images/n-2.jpg" alt=""></a>
        <a href=""><img src="/phpdzy/static/images/n-3.jpg" alt=""></a>
        <a href="">三星Note10/10+发布 <br> 搭载挖孔前摄</a>
        <a href="">小米公布6400万 <br> 和1亿像素手机信息</a>
    </div>
    <div class="list">
        <?php foreach ($cat as $c) : ?>

        <a href="article_list.php?id=<?php echo $c['cate_id'] ?>"><?php echo mb_substr($c['name'],0,15 )?></a>
      <?php endforeach;?>
        <ul><?php foreach ($limit9 as $row9) : ?>
                <li><span>[新闻]</span><a href="article.php?id=<?php echo $row9['article_id'] ?>"><?php echo $row9['title'] ?></a></li>
            <?php endforeach;?>

        </ul>
    </div>
    <div class="list">
        <?php foreach ($cat1 as $row1) : ?>

            <a href="article_list.php?id=<?php echo $row1['cate_id'] ?>"><?php echo mb_substr($row1['name'],0,15) ?></a>
       <?php endforeach;?>
        <ul>
           <?php foreach ($limit92 as $row9) : ?>
            <li><span>[新闻]</span><a href="article.php?id=<?php echo $row9['article_id'] ?>"><?php echo $row9['title'] ?></a>
          <?php endforeach; ?>