eg0060.php
Connecting to the Database Server eg0060.txt
( P247 changes)
Need to go to MYSQL database console...
/ / mysql>create database sample;
// mysql>show databases;
Create another user in MySQL, and grant all privileges
1, Login as root
shell> mysql -u root mysql
mysql> GRANT ALL PRIVILEGES ON
*.* TO harry@localhost
-> IDENTIFIED BY 'elbomonkey' WITH GRANT OPTION;
eg0061.php Connecting to the Database Server eg0061.txt ( P249 changes)
Create a table named "domains"
in MYSQL
mysql>
use sample
Create table domains (id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id),
domain VARCHAR (20),
sex CHAR (1),
mail VARCHAR (20));
eg0062.php Adding a row to a table eg0062.txt (P250 changes)
eg0063.php
Adding User Input to a Database (P251 changes) eg0063.txt
eg0064.php simplified,adding
User Input to a Database (P251 changes) eg0064.txt
eg0065.php Accessing Information (P254 changes) eg0065.txt
eg0066.php Changing data (P258 changes) eg0066.txt
eg0067.htm A simple html file, link to add, query and update (link to eg0064.php, eg0065.php, eg0066.php)
eg0068.php Connecting to Access Database eg0068.txt