Zi 字媒體

Ajax呼叫php存取mysql回傳JSON顯示的基本範例   ajax_php.sql — phpMyAdmin SQL Dump — version 4.0.4.2 — http://www.phpmyadmin.net — — 主機: localhost — 產生日期: 2016 年 06 月 10 日 13:30 — 伺服器版本: 5.6.13 — PHP 版本: 5.4.17 SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”; SET time_zone = “+00:00”; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; — — 資料庫: `ajax_php` — CREATE DATABASE IF NOT EXISTS `ajax_php` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `ajax_php`; — ——————————————————– — — 表的結構 `data` — CREATE TABLE IF NOT EXISTS `data` (   `id` int(6) unsigned NOT NULL AUTO_INCREMENT,   `value` varchar(30) NOT NULL,   PRIMARY KEY (`id`) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; — — 轉存資料表中的資料 `data` — INSERT INTO `data` (`id`, `value`) VALUES (1, ‘test01’), (2, ‘test02’); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;     api.php