所屬章節(jié)課程:PHP開(kāi)發(fā)登入頁(yè)面之資料庫(kù)搭建
<?php header("Content-type:text/html;charset=utf-8"); $servername="localhost"; $username="root"; $password=""; $conn = mysqli_connect($servername,$username,$password); mysqli_set_charset($conn,'utf8'); if(!$conn){ die("鏈接失敗:" . mysqli_connect_error()); } $sql = "CREATE DATABASE login"; if(mysql_query($conn,$sql)){ echo "數(shù)據(jù)庫(kù)創(chuàng)建成功"; }else{ echo "數(shù)據(jù)庫(kù)創(chuàng)建失敗:" . mysql_error($conn); } mysqli_close($conn); ?>
2018-05-100個(gè)贊
推薦::‘/’或‘#’作為定界符
2018-05-140個(gè)贊
所屬章節(jié)課程:資料庫(kù)設(shè)計(jì)
create database onecms;//創(chuàng)建數(shù)據(jù)庫(kù) create table message( id int(11) not null primary key auto_increment, title varchar(255) NOT NULL, content text NOT NULL) ENGINT=innoDB DEFAULT CHARSET=utf8;
2018-05-090個(gè)贊
<form action="insertdb.php" method="post"> 標(biāo)題:<input type="text" id="title" name="title"><br> 內(nèi)容:<br><span><textarea name="content" rows="13" cols="80" id="content"></textarea> <script> KindEditor.ready(fonction(K){ window.editor = K.create('#content',{ afterBlur:function(){this.sync(); } }) }) </script> </span> <input type="submit" name="dosub" id="btn" value="上傳留言"> </form>
2018-05-090個(gè)贊
<?php //conn.inc.php define("HOST",'localhost'); define("USER",'root'); define("PWD",'root'); ?> <?php //mysqli.php include 'conn.inc.php'; $mysqli=new mysqli(HOST,USER,PWD,DBNADM); if($mysqli->connect_errno){ die('數(shù)據(jù)庫(kù)鏈接出錯(cuò)'.$mysqli->connect_error); } ?>
2018-05-090個(gè)贊
include 'mysqli.php'; $sql="select * from message"; $result=$mysqli->query($sql); if($result->num_rows>0){ while($row=$result->fetch_assoc()){ $arr[$row["id"]]["title"]=$row["title"];//$arr[1]["title"]=$row["title"] $arr[$row["id"]]["content"]=$row["content"];//$arr[1]["content"]=$arr["content"] } } echo json_encode($arr);
2018-05-090個(gè)贊
$page= isset($_GET["page"])?$_GET["page"]:1; $num=isset($_GET["num"])?$_GET["num"]:4 $startnum=($page-1)*$num;
2018-05-090個(gè)贊