sairwolf course - 線上書籍

:::

mysql
=====

修改HTML

```
<pre class="brush:xml;">
<p style="text-align:center"><span style="font-size:24px">腦筋急轉彎-修改</span></p>

<p><input name="submit" type="submit" value="修改" /></p>
</form>
```

修改PHP

```
<pre class="brush:php;">
<?php
include("config.php");
header("Content-Type: text/html; charset=utf-8");

if($_POST['submit'])  {
    $sql_query = "update think set q='$_POST[xxxx]',a='$_POST[xxxx]' where tid='$_POST[xxxx]' ";
    $db_link->query($sql_query) or die("錯誤:".$sql_query);
    //echo $sql_query."<br>";  
}

$sql_query = "SELECT * FROM think where tid = $_GET[xxxx] ";
$result = $db_link->query($sql_query);
$row = $result->fetch_array();
?>
```

刪除HTML

```
<pre class="brush:xml;">
<td>動作</td>

<td><a href="list.php?tid=<?php echo $row[tid]; ?>">刪</a>、
    <a href="update.php?tid=<?php echo $row[tid]; ?>">修</a>
</td>
```

刪除PHP

```
<pre class="brush:php;">
if($_GET[xxxx])  {
    $sql_query = "delete from think where xxxx = $_GET[xxxx] ";
    $db_link->query($sql_query) or die("錯誤:$sql_query");    
}
```

刪除時的警告

```
<pre class="brush:jscript;">
onclick="javascript:return confirm('確定要刪除這筆資料嗎？');" 
```

:::

書籍列表

scratch & AI (32)
Minecraft (58)
mBot2 (120)
LEGO spike (158)
廣達游於智 (249)
吸管機器人 (267)
雷切 (325)
3D列印 (712)
arcade (732)
OpenShot (562)
audacity (497)
python (612)
webduino (640)
InkScape (720)
TELLO空拍機 (662)
micor:bit teacher (274)
mBot (776)
micro:bit開發板 (1045)
mysql (2120)
PhotoImpact (885)
KODU (1204)
網站輕鬆架 (781)
PHP程式設計 (1224)
AppInventor2 (1122)
EXCEL (1474)
打字練習 (1903)
PhotoCap (868)

雷達回波圖

萌典查詢

查生字

MarkDown

書籍列表

雷達回波圖

萌典查詢

溫度分布圖