Work #xx TinyDB & Web Databases

shie

http://appinventor.mit.edu/explore/ai2/custom-tinywebdb.html

https://mouse.ee.aeust.edu.tw/Data/AI2/Demo/ch13/ch13_2%20%A4U%B8%FC%A4%CE%A6w%B8%CBTinyWebDB%AC%DB%C3%F6%AA%BA%B3n%C5%E9/

https://www.python.org/downloads/

https://cloud.google.com/appengine/downloads?hl=zh-TW

https://appengine.google.com/

http://ai2.appinventor.mit.edu/r ... customtinywebdb.zip

作業 :
將學號和姓名的輸入和輸出結果放置 Mysql , 並可顯示.需有Listpicker

http://Your_IP/db_insert.php?ID=123456789&Name=Shie

db_insert.php

<?php
header("Content-Type:text/html;charset=utf-8");
$db=mysqli_connect("localhost","root","");
mysqli_select_db($db,"abc");
if (!$db)
{
    die("connect error" . mysql_connect_error());
}
else
{
    echo "Success!";
}
mysqli_query($db,"set names 'utf8'");
$ID = $_GET['ID'];
$Name = $_GET['Name'];
$query = "INSERT INTO `test`(`ID`, `Name`) VALUES ($ID, '$Name');";
echo "<br><br>".$query."<br>";
$result = mysqli_query($db,$query) or trigger_error("Query MySQL Error;".mysqli_error($db));
mysqli_close($db);
?>