创建表 用户

CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT, age INTEGER, address TEXT);

去掉超链接下划线

a { text-decoration: none; }

<input type="submit" value="播放视频"> 美化这个元素

input[type="submit"] { width: 100px; height: 50px; background-color: #ccc }

一个ul ul的class="list-group" 十个li li的class="list-group-item"

<ul class="list-group"> <li class="list-group-item">Cras justo odio</li> <li class="list-group-item">Dapibus ac facilisis in</li> <li class="list-group-item">Morbi leo risus</li> <li class="list-group-item">Porta ac consectetur ac</li> <li class="list-group-item">Vestibulum at eros</li> </ul>

class="badge" 添加一个背景并且是圆形的边框

.badge { background: #09d3ac; border-radius: 50%; padding: 14px 24px; font-size: 16px; color: white; text-transform: uppercase; }

<div class="tianjia"> 居中

.qiqiu { position: absolute; width: 100px; height: 100px; margin-left: -50px; margin-top: -50px; left: 50%; top: 50%; }

<div class="post-card-mask"> <div class="post-card-container"> <h2 class="post-card-title" itemprop="headline">济南 玲子 论母狗的养成 如何成为淫娃 露出野战公交车上口交【100 分钟视频】</h2> <div class="post-card-info"> <span itemprop="author"> 155.fun • </span> <span itemprop="datePublished" content="2023-01-21T10:03:00+00:00">2023 年 01 月 21 日・</span> <span>热点事件</span> </div> </div> </div> post-card-mask 居中显示 背景图高200px post-card-container 在post-card-mask 居中

.post-card-mask { width: 30%; height: 200px; background-color: #fff; margin: 20px auto; display: flex; justify-content: center; align-items: center; border-radius: 10px; }

圆角

.container { width: 100px; height: 100px; border-radius: 50px; }

字体颜色白色

body { color: white; }

<iframe class="neiyebiao" src="index.html"></iframe> 美化这个元素

iframe.neiyebiao { width: 300px; height: 200px; border: 1px solid #ccc; margin: 50px; }

生成海报一个广告框并美化它

<div class="poster"> <img src="http://www.ahtlab.com/uploads/allimg/180105/1-1P105140I9.gif" alt="poster" title="poster" width="600" height="400"> <div class="poster_info"> <div class="poster_title"> <h3>广告标题</h3> <p>广告副标题</p> </div> <div class="poster_icon"> <a href="#" class="glyphicon glyphicon-heart"></a> <a href="#" class="glyphicon glyphicon-comment"></a> <a href="#" class="glyphicon glyphicon-share"></a> </div> </div> </div>

表格

<table> <tr> <th>Month</th> <th>Savings</th> </tr> <tr> <td>January</td> <td>$100</td> </tr> </table>

圆角

.container { width: 100px; height: 100px; border-radius: 100%; }

创建表 用户名：数值型 积分：数值型

CREATE TABLE users (name VARCHAR(15), score INET)

表格美化

table { width: 100%; height: 100%; } tr:nth-child(even) { background-color: #f2f2f2; } th, td { padding: 10px; text-align: left; } td { border-bottom: 1px solid #ddd; }

<textarea style="width: 80%;height: 300px;"id="input_data" name="input_data" rows="10" cols="50"></textarea><br><br> 添加一个默认文本

<textarea style="width: 80%;height: 300px;"id="input_data" name="input_data" rows="10" cols="50"></textarea><br><br> <script type="text/javascript"> function init() { $('#input_data').val("<div class=\"container\" id=\"main\">hello world</div>"); } init(); </script>

<?php // 加载图片 $sss=$_GET['lianjie']; $image1 = imagecreatefromjpeg('3.jpg'); $image_data = file_get_contents("https://api.qrserver.com/v1/create-qr-code/?data=".$sss."&size=300x300"); $image2 = imagecreatefromstring($image_data); // 创建画布 $canvas = imagecreatetruecolor(imagesx($image1), imagesy($image1)); // 将图片合并到画布上 imagecopy($canvas, $image1, 0, 0, 0, 0, imagesx($image1), imagesy($image1)); imagecopy($canvas, $image2, imagesx($image1) / 2-150, imagesy($image1)/2+50, 0, 0, imagesx($image2), imagesy($image2)); // 输出图片 header('Content-Type: image/jpeg'); imagejpeg($canvas); // 释放内存 imagedestroy($canvas); imagedestroy($image1); imagedestroy($image2); ?> 这是php请求的页面 ,请用ajax写一个请求并输出数据

class Person { greet() { return "hello" } }

字体加粗

p { font-weight: bold; }

文本居中

.text-center { text-align: center; }

输入框输入时光标居中

<style> .input { width: 50px; height: 50px; text-align: center; line-height: 50px; } </style> <input class="input" type="text">

用户名 数值型 积分 数值型

SELECT username, user_id, points FROM customers;

<div class="poster"> <img src="http://ag.yudvool.cn/uploads/images/20230101/ff4c58e43f226f1254cf40a7f1d9ce8e.png"> </div> 设置图片 圆角 1px白边 居中 最大高度200px 图片自适应

.poster { border-radius: 1px; border: 1px solid #fff; text-align: center; max-height: 200px; overflow: hidden; img { width: 100%; vertical-align: top; } }

最大宽度960px

@media only screen and (max-width: 960px) { .container { width: 960px; height: 960px; } }

<body> <div class="tianjia"> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <h2>批量添加用户</h2> <label for="start">起始用户名：</label> <input type="text" id="start" name="start" required> <br><br> <label for="end">结束用户名：</label> <input type="text" id="end" name="end" required> <br><br> <input type="submit" value="提交"> </form> </div> <?php if ($_SERVER["REQUEST_METHOD"] == "POST") { include 'mysqli1.php'; $start = $_POST['start']; $end = $_POST['end']; for ($i = $start; $i <= $end; $i++) { $username = $i; $sql = "INSERT INTO users (username) VALUES ('$username')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('添加成功');</script>"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); } ?> </body>

### 提交并获取表单数据 1. 如果将表单数据发送到另一个页面，要用 `method="post"`，否则会报语法错误。 2. 获取表单数据的方法有两种： - `$_GET[]` 和 `$_POST[]` 。 - `$_REQUEST[]` 。 **注意：** 在模板文件 `mysqli1.php` 中，如果将 `$_GET[]` 和 `$_POST[]` 改成 `$_REQUEST[]`，则会报错。 3

背景从左至右渐变3色 带明度

.background{ background: linear-gradient(to right, rgba(255,0,0,0.5), rgba(255,255,0,0.5), rgba(255,0,0,0.5)) }

$('.list-group .badge').each(function() { var that = $(this); if (that.text() == 1) { that.addClass('label-warning'); } else if (that.text() == 2) { that.addClass('label-info'); } else if (that.text() == 3) { that.addClass('label-default'); } else if (that.text() == 4) { that.addClass('label-danger'); } else if (that.text() == 5) { that.addClass('label-primary'); } else if (that.text() == 6) { that.addClass('label-success'); } else if (that.text() == 7) { that.addClass('label-primary'); } else if (that.text() == 8) { that.addClass('label-danger'); } else if (that.text() == 9) { that.addClass('label-warning'); }

分割线1像素

hr { border: none; /* 不要边框 */ border-top: 1px solid #ccc; /* 设置上边框为1像素，并且使用灰色 */ }

base64编码

function base64(str) { // 通过base64编码 return Buffer.from(str).toString('base64') }

<div class="tianjia"> 左右居中

.tianjia { width: 300px; margin: 0 auto; }

<!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>Document</title> </head> <style> .list-group { margin:0 auto; width:960px; list-style-type: none; } .badge { background: #09d3ac; border-radius: 50%; padding: 10px 10px; font-size: 14px; color: white; text-transform: uppercase; } </style> <body> <ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> <script> $('.list-group .badge').each(function() { var that = $(this); if (that.text() == 1) { that.addClass('label-warning'); } else if (that.text() == 2) { that.addClass('label-info'); } else if (that.text() == 3) { that.addClass('label-default'); } else if (that.text() == 4) { that.addClass('label-danger'); } else if (that.text() == 5) { that.addClass('label-primary'); } else if (that.text() == 6) { that.addClass('label-success'); } else if (that.text() == 7) { that.addClass('label-primary'); } else if (that.text() == 8) { that.addClass('label-danger'); } else if (that.text() == 9) { that.addClass('label-warning'); }; </script> </body> </html>

# 插入表格 - 三个"-"表示一列，第一行表示标题

背景图片左右居中

body { background: url(bg.gif) no-repeat center center fixed; background-size: cover; }

class="badge" 转为行内元素

display: inline;

背景图片1.png

.container { width: 100px; height: 100px; background-image: url("1.png"); }

<textarea style="width: 80%;height: 300px;"id="input_data" name="input_data" rows="10" cols="50"></textarea><br><br> 默认文本

function getCustomInputData(){ return document.getElementById("input_data").value; }

img 图片超出部分不显示

img { max-width: 100%; width: auto; height: auto; }

<body> <div class="tianjia"> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <h2>批量添加用户</h2> <label for="start">起始用户名：</label> <input type="text" id="start" name="start" required> <br><br> <label for="end">结束用户名：</label> <input type="text" id="end" name="end" required> <br><br> <input type="submit" value="提交"> </form> </div> <?php if ($_SERVER["REQUEST_METHOD"] == "POST") { include 'mysqli1.php'; $start = $_POST['start']; $end = $_POST['end']; for ($i = $start; $i <= $end; $i++) { $username = $i; $sql = "INSERT INTO users (username) VALUES ('$username')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('添加成功');</script>"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); } ?> </body>

### 3.2.3 数据更新

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 改成10个li

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span>

输入框居中输入

.input { background-color: #eee; font-size: 14px; height: 30px; color: #333; padding-left: 10px; line-height: 30px; -webkit-appearance: none; // 去除输入框原有样式 }

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 控制里面的眼神 如果是数字1 黄色 数字2蓝色 数字3浅灰色 数字4橘色 数字5青色 数字6深蓝色 数字7深灰色 数字8红色 数字9 褐色 数字10绿色

$('.list-group .badge').each(function() { var that = $(this); if (that.text() == 1) { that.addClass('label-warning'); } else if (that.text() == 2) { that.addClass('label-info'); } else if (that.text() == 3) { that.addClass('label-default'); } else if (that.text() == 4) { that.addClass('label-danger'); } else if (that.text() == 5) { that.addClass('label-primary'); } else if (that.text() == 6) { that.addClass('label-success'); } else if (that.text() == 7) { that.addClass('label-primary'); } else if (that.text() == 8) { that.addClass('label-danger'); } else if (that.text() == 9) { that.addClass('label-warning'); }

<div class="post-card-mask"> <div class="post-card-container"> <h2 class="post-card-title" itemprop="headline">济南 玲子 论母狗的养成 如何成为淫娃 露出野战公交车上口交【100 分钟视频】</h2> <div class="post-card-info"> <span itemprop="author"> 155.fun • </span> <span itemprop="datePublished" content="2023-01-21T10:03:00+00:00">2023 年 01 月 21 日・</span> <span>热点事件</span> </div> </div> </div> 居中显示 背景高200px

.container { width: 100px; height: 100px; margin:0 auto; background-color: lightpink; text-align: center; }

iD自生成 用户名 数值型 积分 数值型可接受空值 推荐用户

CREATE TABLE users( user_id INT UNSIGNED AUTO_INCREMENT, user_name VARCHAR(20) NOT NULL, credits INT DEFAULT 0, referral_by INT UNSIGNED, PRIMARY KEY (user_id), FOREIGN KEY (referral_by) REFERENCES users(user_id) );

页面最大宽度960px

html { font-size:20px; font-size: 1.875rem; }

投影

.container { width: 100px; height: 100px; box-shadow: 10px 10px 5px #888888; }

<div class="container" id="nav"> <span class="nav-item left" id="user"> <span id="user-id">这里显示用户ID</span> <span id="user-score">这里显示用户积分</span> </span> <span class="nav-item right" id="logout">登出</span> </div> 美化

#nav { background: rgba(76, 76, 76, 0.6); } #user { color: white; font-size: 1.5em; font-weight: 100; letter-spacing: 3px; line-height: 130%; } #user-id { font-size: 0.8em; color: rgba(255, 255, 255, 0.6); margin-right: 0.2em; } #user-score { font-size: 0.8em; color: rgba(255, 255, 255, 0.6); margin-left: 0.2em; } #logout { color: white; font-size: 1.5em; font-weight: 100; letter-spacing: 3px; line-height: 130%; } #logout:hover { cursor: pointer; } .nav-item { display: inline

用户名 数值型 积分数值型

SELECT username, age, score FROM customers WHERE age=24;

post-card-info 左右居中

.post-card-info { text-align: center; }

<div class="container" id="nav"> <span class="nav-item left" id="user"> <span id="user-id">用户名:41235</span> <span id="user-score">可用积分:0</span> </span> </div> 左右居中

#nav { margin: 0 auto; width: 1200px; height: 50px; position: relative; }

img 超出部分不显示

.container { width: 100px; height: 100px; overflow: hidden; }

.gengin{ width: 90px; height: 30px; background-color: #23A6D5; border: none; outline: none; color: #ffffff; font-size: 18px; font-weight: bold; padding: 5px 8px; margin: 0px auto; cursor: pointer; } .gengin:hover{ background-color: #23D5AB; } 居中显示

.container { margin: 0px auto; }

img 居中显示 自适应大小 超出部分不显示

.box{ position: relative; overflow: hidden; } .box img{ position: absolute; left: 50%; top: 50%; transform: translateY(-50%) translateX(-50%); }

post-card-title 字体大小20px

.content .post-card-title { font-size: 20px; }

圆角

.container { width: 100px; height: 100px; border-radius: 50%; }

请用ajax写一个请求并输出数据

$.ajax({ url: "", type: "GET", success: function(response) { console.log(response); } });

<meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge, chrome=1"> <meta name="renderer" content="webkit"> <meta name="HandheldFriendly" content="true"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no, shrink-to-fit=no"> <meta http-equiv="Content-Security-Policy" content="upgrade-insecure-requests">

function add(a, b){ return a + b }

<div class="form-group"> <h2>Please enter the password</h2> <p>Your browser must accept cookies in order to log in.</p> <input type="password" name="password" size="15"> <input type="submit" value="login"> </div> 整个页面上下左右都居中 文本页居中

.form-group { position: absolute; top:50%; left:50%; transform: translate(-50%, -50%); }

页面最大宽度960px

.container { width: 960px; height: 100px; }

一个ul ul的class="list-group" 十个li li的class="list-group-item" li内容从1-10

<ul class="list-group"> <li class="list-group-item">1</li> <li class="list-group-item">2</li> <li class="list-group-item">3</li> <li class="list-group-item">4</li> <li class="list-group-item">5</li> <li class="list-group-item">6</li> <li class="list-group-item">7</li> <li class="list-group-item">8</li> <li class="list-group-item">9</li> <li class="list-group-item">10</li> </ul>

<form action="adminqy.php" method="post"> <label for="username">Username:</label> <input type="text" id="username" name="username"> <br><br> <label for="score">Score:</label> <input type="text" id="score" name="score"> <br><br> <label for="referral_address">Referral Address:</label> <input type="text" id="referral_address" name="referral_address"> <br><br> <input type="submit" value="Submit"> </form> 居中美化

.container { width: 100px; height: 100px; margin: 0 auto; }

.gengin{ width: 90px; height: 30px; background-color: #23A6D5; border: none; outline: none; color: #ffffff; font-size: 18px; font-weight: bold; padding: 5px 8px; margin: 0px auto; cursor: pointer; } .gengin:hover{ background-color: #23D5AB; } 居中显示

<div class="gengin">按钮</div>

img 超出部分不显示

img { max-width: 100%; height: auto; }

<h1><img src="http://629cgw.com/zb_users/plugin/tx_verification_ip/logo.png">本站开启了验证保护</h1> 一排居中

<h1 style="text-align:center"><img src="http://629cgw.com/zb_users/plugin/tx_verification_ip/logo.png">本站开启了验证保护</h1>

<button id="redirect-button1">加拿大</button> 美化按钮

#redirect-button1 { font-size:25px; width:200px; height:50px; background-color: #4CAF50; color: white; border: 2px solid #555555; } #redirect-button1:hover { background-color: #555555; cursor: pointer; color: white; }

<label for="referral_address">推个链接:</label> <input type="text" id="referral_address" name="referral_address"> 默认文本“http://127.0.01/”

<label for="referral_address">推个链接:</label> <input type="text" id="referral_address" name="referral_address" value="http://127.0.01/">

<div class="container" id="nav"> <span class="nav-item left" id="user"> <span id="user-id">用户名:41235</span> <span id="user-score">可用积分:0</span> </span> </div> 登录成功后把 username 显示在用户名 把积分显示积分栏

$('#user').find('#user-id').text(`用户名:${username}`); $('#user').find('#user-score').text(`可用积分:${score}分`);

h1标签居中

h1 { text-align: center; }

<div class="form-group"> <h2>Please enter the password</h2> <p>Your browser must accept cookies in order to log in.</p> <input type="password" name="password" size="15"> <input type="submit" value="login"> </div> 整个页面上下左右都居中

.form-group{ position:absolute; width:300px; height:200px; top:50%; left:50%; margin-top:-100px; margin-left:-150px; }

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 给每个li添加一个背景并且是圆形的边框

.list-group-item { background: #eee; border-radius: 50%; }

<h2>链接操作</h2> 居中显示

h2 { text-align: center; }

居中

.container { width: 100px; height: 100px; position: relative; margin: auto; top: 0; left: 0; bottom: 0; right: 0; }

无边框

.container { width: 100px; height: 100px; border: 0; }

从这个表table_name取9条数据

SELECT * FROM table_name LIMIT 9

img 居中显示 自适应大小

img { display: block; max-width: 100%; margin: 0 auto; }

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 控制badge里面背景颜色 如果是数字1 黄色 数字2蓝色 数字3浅灰色 数字4橘色 数字5青色 数字6深蓝色 数字7深灰色 数字8红色 数字9 褐色 数字10绿色

<style> .badge[class*=badge-] { color: #fff; } .badge-primary { background-color: #337ab7; } .badge-success { background-color: #5cb85c; } .badge-info { background-color: #5bc0de; } .badge-warning { background-color: #f0ad4e; } .badge-danger { background-color: #d9534f; } .badge-inverse { background-color: #222; } .badge-fade { opacity: .75; } .badge-dark { background-color: #000; } .badge-purple { background-color: #9b59b6; } .badge-orange { background-color: #ffa500; } .badge-green { background-color: #008080; } .

创建表 用户名：数值型 积分：数值型

CREATE table user(username int,score int);

显示账号和积分

<div class="container" id="main">hello world</div> <div class="container" id="main">{{name}},{{score}}</div>

<div class="container" id="main">用户ID：</div> <div class="container" id="main2">{{name}},{{score}}</div> 单排左右居中显示

.container { width: 100px; height: 100px; display: flex; justify-content: center; align-items: center; }

输入框美化

.container input { width: 100%; height: 30px; padding: 5px; border: none; border-radius: 5px; background-color: #ccc; outline: none; box-sizing: border-box; font-size: 14px; }

输入框输入时光标居中

input:focus { outline: 0; /* Webkit: remove the focus ring completely*/ -webkit-appearance: none; /* Webkit: remove the default styling for focus ring color*/ }

分割线

<hr/>

<!doctype html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <title>Document</title> </head> <style> .list-group { margin:0 auto; width:960px; list-style-type: none; } .badge { background: #09d3ac; border-radius: 50%; padding: 10px 10px; font-size: 14px; color: white; text-transform: uppercase; } </style> <body> <ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> <script> $('.list-group .badge').each(function() { var that = $(this); if (that.text() == 1) { that.addClass('label-warning'); } else if (that.text() == 2) { that.addClass('label-info'); } else if (that.text() == 3) { that.addClass('label-default'); } else if (that.text() == 4) { that.addClass('label-danger'); } else if (that.text() == 5) { that.addClass('label-primary'); } else if (that.text() == 6) { that.addClass('label-success'); } else if (that.text() == 7) { that.addClass('label-primary'); } else if (that.text() == 8) { that.addClass('label-danger'); } else if (that.text() == 9) { that.addClass('label-warning'); }; </script> </body> </html>

## 运行

重置自生成序号

ALTER TABLE table_name AUTO_INCREMENT = 1;

导航栏显示用户iD和用户积分

<div class="container" id="nav"> <span class="nav-item left" id="user"> <span id="user-id">这里显示用户ID</span> <span id="user-score">这里显示用户积分</span> </span> <span class="nav-item right" id="logout">登出</span> </div>

<body> <div class="tianjia"> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <h2>批量添加用户</h2> <label for="start">起始用户名：</label> <input type="text" id="start" name="start" required> <br><br> <label for="end">结束用户名：</label> <input type="text" id="end" name="end" required> <br><br> <input type="submit" value="提交"> </form> </div> <?php if ($_SERVER["REQUEST_METHOD"] == "POST") { include 'mysqli1.php'; $start = $_POST['start']; $end = $_POST['end']; for ($i = $start; $i <= $end; $i++) { $username = $i; $sql = "INSERT INTO users (username) VALUES ('$username')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('添加成功');</script>"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); } ?> </body>

### 如何添加多个用户？ - 需求分析： - 将数据插入数据库，可以使用for循环 - 步骤： 1. 将数据插入数据库 2. 使用for循环执行多次插入操作 ## 复习 - 连接数据库

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 用js控制badge里面背景颜色 如果是数字1 黄色 数字2蓝色 数字3浅灰色 数字4橘色 数字5青色 数字6深蓝色 数字7深灰色 数字8红色 数字9 褐色 数字10绿色

$(".badge").each(function(){ if($(this).text() == '1'){ $(this).css("background","yellow"); }else if($(this).text() == '2'){ $(this).css("background","blue"); }else if($(this).text() == '3'){ $(this).css("background","gainsboro"); }else if($(this).text() == '4'){ $(this).css("background","orange"); }else if($(this).text() == '5'){ $(this).css("background","cyan"); }else if($(this).text() == '6'){ $(this).css("background","navy"); }else if($(this).text() == '7'){ $(this).css("background","darkslategray"); }else if($(this).text() == '8'){ $(this).css("background","red"); }else if($(this).text() == '9'){

文本居中

.text-center { text-align: center; }

生成一个密码访问页面

<form method="post" action="password.php"> <h2>Please enter the password</h2> <p>Your browser must accept cookies in order to log in.</p> <input type="password" name="password" size="15"> <input type="submit" value="login"> </form>

下划线

<div style="text-decoration: underline;">hello world</div>

<body> <div class="tianjia"> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <h2>批量添加用户</h2> <label for="start">起始用户名：</label> <input type="text" id="start" name="start" required> <br><br> <label for="end">结束用户名：</label> <input type="text" id="end" name="end" required> <br><br> <input type="submit" value="提交"> </form> </div> <?php if ($_SERVER["REQUEST_METHOD"] == "POST") { include 'mysqli1.php'; $start = $_POST['start']; $end = $_POST['end']; for ($i = $start; $i <= $end; $i++) { $username = $i; $sql = "INSERT INTO users (username) VALUES ('$username')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('添加成功');</script>"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); } ?> </body>

### 参考文献 - [图解：手把手教你用MySQLi实现数据库的增删改查操作](https://www.jianshu.com/p/7d0d6dde7a97) - [PHP 的增删改查 (CRUD) 操作](https://www.runoob.com/php/php-crud.html)

用户名：数值型 积分：数值型

SELECT * FROM customers WHERE username=1 AND score=2;

<article itemscope class=""> <div class="display-none" itemscope itemprop="author"> <meta itemprop="name" content=" 155.fun"/> <meta itemprop="url" content=""/> </div> <div class="display-none" itemscope itemprop="publisher"> <meta itemprop="name" content=" 155.fun"/> <div itemscope itemprop="logo"> <meta itemprop="url" content="https://secure.gravatar.com/avatar/386583cce30096e2895bf18f7ffcb61f?s=50&amp;r=G&amp;d="> </div> </div> <meta itemprop="url mainEntityOfPage" content="https://zztt45.com/archives/16551.html" /> <meta itemprop="dateModified" content="2023-02-06T09:00:53+00:00"> <a href="https://zztt45.com/archives/16551.html" > <div class="post-card" id="post-card-16551" data-url="https://images.vryunpan.cc/new/usr/20230206/2023020616520475395.jpeg"> <div class="blog-background"></div> <script>toBase('post-card-16551');</script> <div class="post-card-mask"> <div class="post-card-container"> <h2 class="post-card-title" itemprop="headline">天津大学 沈佳慧 完美露脸 口爆颜射 特写刮毛【20分钟完整版】</h2> <div class="post-card-info"> <span itemprop="author"> 155.fun ? </span> <span itemprop="datePublished" content="2023-02-06T16:00:00+00:00">2023 年 02 月 06 日 ? </span> <span>热点事件</span> </div> </div> </div> </div> </a> </article>

<div class="display-none" itemscope itemprop="author"> <meta itemprop="name" content=" 155.fun"/> <meta itemprop="url" content=""/> </div> <div class="display-none" itemscope itemprop="publisher"> <meta itemprop="name" content=" 155.fun"/> <div itemscope itemprop="logo"> <meta itemprop="url" content="https://secure.gravatar.com/avatar/386583cce30096e2895bf18f7ffcb61f?s=50&amp;r=G&amp;d="> </div> </div> <meta itemprop="url mainEntityOfPage" content="https://zztt45.com/archives/16551.html" /> <meta itemprop="dateModified" content="2023-02-06T09:00:53+00:00">

<div class="biaoti"> <h1 style="text-align:center"><img src="http://629cgw.com/zb_users/plugin/tx_verification_ip/logo.png">本站开启了验证保护</h1> </div> 左右居中

.biaoti { width: 100%; position: absolute; left: 0; right: 0; margin: 0 auto; }

img 超出部分不显示

.container img { width: 100%; height: 100%; }

<?php namespace app\controller; use app\BaseController; class Index extends BaseController { public function index() { return '<style type="text/css">*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px;} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:) </h1><p> ThinkPHP V' . \think\facade\App::version() . '<br/><span style="font-size:30px;">16载初心不改 - 你值得信赖的PHP框架</span></p><span style="font-size:25px;">[ V6.0 版本由 <a href="https://www.yisu.com/" target="yisu">亿速云</a> 独家赞助发布 ]</span></div><script type="text/javascript" src="https://e.topthink.com/Public/static/client.js"></script><think id="ee9b1aa918103c4fc"></think>'; } public function hello($name = 'ThinkPHP6') { return 'hello,' . $name; } public function login(){ return '<div style="padding: 24px 48px;"> <h1>登录</h1><p>登录成功！</p></div>'; } }

## 1.2 问题和答案 #### 1.2.1 提交了一个叫做`ex1`的文件夹，里面包含了一个`index.php`文件，以及一个`readme.md`文件，但是没有显示的效果。原因是什么？如何修改？ > 原因是那个`index.php`没有被提交到github上。 > 修改方法：在github上创建一个仓库，然后连接到本地仓库。 #### 1.2.2

<div>点击更新更多</div> 美化按钮

.update{ width: 90px; height: 30px; background-color: #2a2a2a; border: none; outline: none; color: #ffffff; font-size: 18px; font-weight: bold; padding: 5px 8px; cursor: pointer; }

字体颜色

.container { color: red; }

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 给这段代码添加一个居中

.list-group { margin:0 auto; width:300px; }

$('.list-group .badge').each(function() { var that = $(this); if (that.text() == 1) { that.addClass('label-warning'); } else if (that.text() == 2) { that.addClass('label-info'); } else if (that.text() == 3) { that.addClass('label-default'); } else if (that.text() == 4) { that.addClass('label-danger'); } else if (that.text() == 5) { that.addClass('label-primary'); } else if (that.text() == 6) { that.addClass('label-success'); } else if (that.text() == 7) { that.addClass('label-primary'); } else if (that.text() == 8) { that.addClass('label-danger'); } else if (that.text() == 9) { that.addClass('label-warning'); }

<body> <div class="tianjia"> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <h2>批量添加用户</h2> <label for="start">起始用户名：</label> <input type="text" id="start" name="start" required> <br><br> <label for="end">结束用户名：</label> <input type="text" id="end" name="end" required> <br><br> <input type="submit" value="提交"> </form> </div> <?php if ($_SERVER["REQUEST_METHOD"] == "POST") { include 'mysqli1.php'; $start = $_POST['start']; $end = $_POST['end']; for ($i = $start; $i <= $end; $i++) { $username = $i; $sql = "INSERT INTO users (username) VALUES ('$username')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('添加成功');</script>"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); } ?> </body>

### Example

<textarea style="width: 80%;height: 300px;"id="input_data" name="input_data" rows="10" cols="50"></textarea><br><br> 这个输入框默认文本为123

<textarea id="input_data" name="input_data" rows="10" cols="50">123</textarea>

<button id="share-button">点击我分享获得积分</button> 左右居中

#share-button { margin: 0 auto; }

边框颜色 边框粗细

.container { width: 100px; height: 100px; border: 5px solid #ccc; }

<?php // 加载图片 $sss=$_GET['lianjie']; $image1 = imagecreatefromjpeg('3.jpg'); $image_data = file_get_contents("https://api.qrserver.com/v1/create-qr-code/?data=".$sss."&size=300x300"); $image2 = imagecreatefromstring($image_data); // 创建画布 $canvas = imagecreatetruecolor(imagesx($image1), imagesy($image1)); // 将图片合并到画布上 imagecopy($canvas, $image1, 0, 0, 0, 0, imagesx($image1), imagesy($image1)); imagecopy($canvas, $image2, imagesx($image1) / 2-150, imagesy($image1)/2+50, 0, 0, imagesx($image2), imagesy($image2)); // 输出图片 header('Content-Type: image/jpeg'); imagejpeg($canvas); // 释放内存 imagedestroy($canvas); imagedestroy($image1); imagedestroy($image2); ?> 这是php请求的页面 ,请用ajax写一个请求并输出数据

function ajax(url,fnSucc){ if(window.XMLHttpRequest){ var oAjax=new XMLHttpRequest(); }else{ var oAjax=new ActiveXObject("Microsoft.XMLHTTP"); } //连接服务器 oAjax.open('GET',url,true); //发送请求 oAjax.send(); //接收返回 oAjax.onreadystatechange=function(){ if(oAjax.readyState==4){ if(oAjax.status==200){ fnSucc(oAjax.responseText); }else{ alert('错误代码:'+oAjax.status); } } }; } ajax('http://www

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul> 去除掉Ul的点

.list-group { list-style-type: none; }

生成一个显示10中奖号码

<ul class="list-group"> <li class="list-group-item"> <span class="badge">1</span> <span class="badge">2</span> <span class="badge">3</span> <span class="badge">4</span> <span class="badge">5</span> <span class="badge">6</span> <span class="badge">7</span> <span class="badge">8</span> <span class="badge">9</span> <span class="badge">10</span> </li> </ul>

border: 1px solid #ccc; 改无边框

css .container { width: 100px; height: 100px; border: none; }

body所有内容左右居中显示

body{ margin: 0 auto; }

输入框

<input type="text" placeholder="输入用户名" value="张三"/>

背景图片居中

background: url(../images/bg.png) no-repeat center center;

<body> <div class="tianjia"> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post"> <h2>批量添加用户</h2> <label for="start">起始用户名：</label> <input type="text" id="start" name="start" required> <br><br> <label for="end">结束用户名：</label> <input type="text" id="end" name="end" required> <br><br> <input type="submit" value="提交"> </form> </div> <?php if ($_SERVER["REQUEST_METHOD"] == "POST") { include 'mysqli1.php'; $start = $_POST['start']; $end = $_POST['end']; for ($i = $start; $i <= $end; $i++) { $username = $i; $sql = "INSERT INTO users (username) VALUES ('$username')"; if (mysqli_query($conn, $sql)) { echo "<script>alert('添加成功');</script>"; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); } ?> </body>

2、让编辑器自动缩进（sublime text） **打开sublime控制台：CMD+`（这个符号是键盘esc上面那个按键下面的那个键），输入如下代码：**

背景从左至右渐变3色

background: linear-gradient(to right, red, yellow, green);

美化 <article itemscope class=""> <div class="display-none" itemscope itemprop="author"> <meta itemprop="name" content=" 155.fun"/> <meta itemprop="url" content=""/> </div> <div class="display-none" itemscope itemprop="publisher"> <meta itemprop="name" content=" 155.fun"/> <div itemscope itemprop="logo"> <meta itemprop="url" content="https://secure.gravatar.com/avatar/386583cce30096e2895bf18f7ffcb61f?s=50&amp;r=G&amp;d="> </div> </div> <meta itemprop="url mainEntityOfPage" content="https://zztt45.com/archives/16551.html" /> <meta itemprop="dateModified" content="2023-02-06T09:00:53+00:00"> <a href="https://zztt45.com/archives/16551.html" > <div class="post-card" id="post-card-16551" data-url="https://images.vryunpan.cc/new/usr/20230206/2023020616520475395.jpeg"> <div class="blog-background"></div> <script>toBase('post-card-16551');</script> <div class="post-card-mask"> <div class="post-card-container"> <h2 class="post-card-title" itemprop="headline">天津大学 沈佳慧 完美露脸 口爆颜射 特写刮毛【20分钟完整版】</h2> <div class="post-card-info"> <span itemprop="author"> 155.fun ? </span> <span itemprop="datePublished" content="2023-02-06T16:00:00+00:00">2023 年 02 月 06 日 ? </span> <span>热点事件</span> </div> </div> </div> </div> </a> </article>

.blog-background { position: absolute; background-size: cover; background-position: center; background-repeat: no-repeat; width: 100%; height: 100%; } .post-card { cursor: pointer; position: relative; overflow: hidden; width: 100%; height: 100%; } .post-card-container { position: absolute; display: flex; flex-direction: column; justify-content: center; align-items: center; top: 0; bottom: 0; left: 0; right: 0; color: #fff; background: linear-gradient(to bottom, rgba(0, 0, 0, 0.7) 0%, rgba(0, 0, 0, 0.7) 100%); } .post-card-title { font-size: 1.1em; font-weight: bolder; text-align

用户名：数值型 积分：数值型

SELECT username FROM users WHERE age>18;

<div class="poster"> <img src="http://ag.yudvool.cn/uploads/images/20230101/ff4c58e43f226f1254cf40a7f1d9ce8e.png"> </div> 美化

.poster { width: 500px; height: 500px; border: 1px solid #ccc; overflow: hidden; margin: 50px auto; position: relative; } .poster img { width: 100%; height: 100%; position: absolute; left: 0; top: 0; transition: all .5s ease; } .poster img:nth-child(2) { transform: scale(1.5); } .poster img:nth-child(3) { transform: rotateY(180deg) scale(1.5); } .poster img:nth-child(4) { transform: rotateY(90deg) scale(1.5); } .poster img:nth-child(5) { transform: rotateY(270deg) scale(1.5); } .poster img:nth-child(6)

按钮背景从左至右渐变

.btn { background: linear-gradient(to right, #ff7e5f, #feb47b); background-size: cover; border-radius: 100px; border: none; color: white; font-size: 16px; padding: 10px 20px; cursor: pointer; outline: none; }

无边框

.container { border: none; }

最大宽和最大高

max-width: 100px; max-height: 100px;

<article itemscope class=""> <div class="display-none" itemscope itemprop="author"> <meta itemprop="name" content=" 155.fun"/> <meta itemprop="url" content=""/> </div> <div class="display-none" itemscope itemprop="publisher"> <meta itemprop="name" content=" 155.fun"/> <div itemscope itemprop="logo"> <meta itemprop="url" content="https://secure.gravatar.com/avatar/386583cce30096e2895bf18f7ffcb61f?s=50&amp;r=G&amp;d="> </div> </div> <meta itemprop="url mainEntityOfPage" content="https://zztt45.com/archives/16551.html" /> <meta itemprop="dateModified" content="2023-02-06T09:00:53+00:00"> <a href="https://zztt45.com/archives/16551.html" > <div class="post-card" id="post-card-16551" data-url="https://images.vryunpan.cc/new/usr/20230206/2023020616520475395.jpeg"> <div class="blog-background"></div> <script>toBase('post-card-16551');</script> <div class="post-card-mask"> <div class="post-card-container"> <h2 class="post-card-title" itemprop="headline">天津大学 沈佳慧 完美露脸 口爆颜射 特写刮毛【20分钟完整版】</h2> <div class="post-card-info"> <span itemprop="author"> 155.fun ? </span> <span itemprop="datePublished" content="2023-02-06T16:00:00+00:00">2023 年 02 月 06 日 ? </span> <span>热点事件</span> </div> </div> </div> </div> </a> </article> 美化

.blog-background{ background-image: url("https://images.vryunpan.cc/new/usr/20230206/2023020616520475395.jpeg"); background-size: 100% 100%; width: 100%; height: 300px; }

背景图片地址http://629cgw.com/zb_users/plugin/tx_verification_ip/include/bg.png

.container { width: 100px; height: 100px; background: url("http://629cgw.com/zb_users/plugin/tx_verification_ip/include/bg.png") ; }

img 超出部分不显示

img { overflow: hidden; }

<div class="waiceng" ><div class="guangggao"><a href="#" src=""><img src=""></a></div></div> 美化

.waiceng { width: 100px; height: 100px; border: 1px solid #ccc; } .guanggao { width: 100px; height: 100px; background-color: green; display: inline-block; } .guanggao img { width: 100px; height: 100px; }

<form action="adminqy.php" method="post"> <label for="username">Username:</label> <input type="text" id="username" name="username"> <br><br> <label for="score">Score:</label> <input type="text" id="score" name="score"> <br><br> <label for="referral_address">Referral Address:</label> <input type="text" id="referral_address" name="referral_address"> <br><br> <input type="submit" value="Submit"> </form> 美化输入框

<style> input[type=text], select { width: 100%; padding: 12px 20px; margin: 8px 0; display: inline-block; border: 1px solid #ccc; border-radius: 4px; box-sizing: border-box; } input[type=submit] { width: 100%; background-color: #4CAF50; color: white; padding: 14px 20px; margin: 8px 0; border: none; border-radius: 4px; cursor: pointer; } input[type=submit]:hover { background-color: #45a049; } div { border-radius: 5px; background-color: #f2f2f2; padding: 20px; } </style>