| Bible mysq
site, PHP-MYSQL Course |
|
In the steps of this tutorial, I will be using the XAMPP
server for Windows ... |
Mars
2015
| |
General Info:
All pages of this Application have : |
| |
Server Name =
"localhost"
User Name = "root"
Password =
"" |
| |
| | |
| |
| |
If you wish to install a local testing server, you can download the
XAMPP package for Windows http://www.apachefriends.org/en/xampp.html
Once
XAMPP is a completely installed. XAMPP is an easy to install Apache
distribution containing MySQL, PHP and Perl.
You can use the
XAMPP Control Panel to start your testing server.
- Click Start next to both Apache and MySQL to start the services.
Starting these services can take a few seconds. When it is complete,
'Running' will display beside each option.
To make your testing server start automatically
when your computer starts, you can check the Svc checkbox beside both
options.
If the XAMPP Control Panel is not already running, go to
C:\xampp\control.exe to open the panel. |
1- XAMPP Control Panel
|
|
|
| |
|
With your testing server now installed and running, there are a few
final steps you should take to make sure everything is configured to work
perfectly.
- Open a web browser such as Firefox or Internet Explorer.
- In the Address bar, enter http://localhost.
You should see a
XAMPP splash screen with language options.
- Choose your preferred language.
You should now see a confirmation
window informing you that 'You have successfully installed XAMPP on your
system' |
2-
List of Files
the
php files and Folders corresponding, stored at \22-Course, Bible
mysq site, PHP-MYSQL\Bible mysq Folder.
the main File -
Bible.php |
|
|
| |
| Defining a Dreamweaver
Site |
| Once a testing server is set up, either locally or using
a remote hosting service, you will need to define a site for Dynamic
Development in Dreamweaver |
| |
|
In Dreamweaver go to Site -> New Site.
Note:
you can edit an existing site definition by going to Site -> Manage
Sites. Select the site you wish to modify, then click the edit
button. |
| |
Step 2: Enter the local
Information
In the
first section of the site definition, you will set the Local Information.
This sets the Site Name, and local path for files in your
site.
When using XAMPP in a windows system, it may be that the site
root is mapped to: C:\xampp\htdocs
so the new site folder would be created under
that location: C:\xampp\htdocs\Bible-mysq-site
In this screen shot, using DW CS6 on a Windows system with XAMPP
installed. you will set the Local Information. This sets the Site Name,
and local path for files in your site.
Site
Name:
Bible-mysq-site
local Site Folder: C:\xampp\htdocs\Bible-mysq-site |
|
|
| |
|
The next setting is to connect to servers. In DW CS6 and above, this
done by selecting the servers section: |
|
|
| |
and clicking the plus icon to define a new server
connection.
at Basic tab, For the Name you can enter the same
name as the Site definition, When using a local testing server, set
Connect Using to "Local/Network" |
|
|
Set the Server Folder to the same location as the local
files set in the initial Site Settings.
Server
Name:
Bible-mysq-site
connect
using:
Local/Network
Server
Folder:
C:\xampp\htdocs\Bible-mysq-site
Web
URL:
http://localhost/Bible-mysq-site |
|
|
| |
| at Advanced tab, |
Click the advanced button and set the Application model
to PHP / MySQL
Server Model: PHP MySQL |
|
|
then click Save.
Once the connection is
defined, there are check boxes to set the connection as a testing or
remote connection, check the testing option. |
|
|
| and then Click Save, the Dreamweaver dialog box
display: |
| |
| Step 4:
Manage Sites |
| you can edit an existing site definition by going to Site
-> Manage Sites. Your Sites: Bible-mysq-site |
|
|
| then click Done |
| Setup the site's Testing Server and then click
OK |
|
|
| |
| Plan of the Application
- Bible mysql site |
| The Bible, Old
and New Testament . Application Developed by PHP language and MySql
database, using the Pagination and Search Operations. to Read and Search
from The Bible |
|
|
| |
|
|
Note: in this
phpMyAdmin 4.2, the Max size of the
import sql file = 2048 KB.
for this, the Data of The
Bible - Old and New Testament stored at 6 databases sql files, 2 sql files
store the New Testament and 4 sql files store the Old
Testament:
1- the 2 sql files corresponding to the New
Testament : a-Bible_en.sql,
a-Bible-new2-en.sql
2- the 4 sql files corresponding to
the Old Testament : a-bible-olde1.sql,
a-bible-olde2.sql, a-bible-olde3.sql and a-bible-olde4.sql |
| |
| These sql files store the corresponding
Books of The Bible - Old and New Testament: |
| Old Testament - Part
1 |
Old Testament - Part 2 |
Old Testament - Part 3 |
Old Testament - Part 4 |
New Testament - Part 1 |
New Testament - Part 2 |
| a-bible-olde1.sql |
a-bible-olde2.sql |
a-bible-olde3.sql |
a-bible-olde4.sql |
a-Bible_en.sql |
a-Bible-new2-en.sql |
|
|
|
|
|
|
| |
| |
| |
| A- Create Database -
a-Bible-new2-en.sql |
in this section, we'll look into how to create a
database. A database is used to store information for your site.
Copy
a-Bible-new2-en.sql file
from ...\\\22-Course, Bible mysq site, PHP-MYSQL\Bible mysq
Folder to folder C:\xampp\htdocs\Bible-mysq-site |
| Most web hosts use a control panel for managing your
site, in the control panel they will have a way to create a MySQL
Database. Once a database has been created, you can use phpMyAdmin to edit
it. |
phpMyAdmin is also available using most Local Testing
server packages like XAMPP. The Start pages for those server will have a
link to open phpMyAdmin.
In phpMyAdmin, go to the Import tab. Use
this .sql script
(C:\xampp\htdocs\Bible-mysq-site\a-Bible-new2-en.sql) to create the
a-Bible-new2-en database that we will be using
:.
Step
1: import SQL file
On the import tab, Click the chose
file button, and select the a-Bible-new2-en.sql file that
you downloaded, and click the Go
button to have the database created:
|
|
|
| |
| Message about a-Bible-new2-en.sql display: Import has been
succcessully ... |
|
|
| |
the Database "a-Bible-new2-en" stores 1
table: bibletablenew2
On the Structure tab, to be
Displays: the Table "bibletablenew2" of Database
"a-Bible-new2-en" |
|
|
| |
Repeat
previous point A, to Create the other Database sql
files
1- 1 sql files corresponding to
the New Testament : a-Bible_en.sql
2- 4 sql files corresponding to
the Old Testament : a-bible-olde1.sql,
a-bible-olde2.sql, a-bible-olde3.sql and a-bible-olde4.sql
|
|
Information
about all PHP files stored at this Application - Bible mysq
site
All files of
this application stored at folder: ...\22-Course, Bible mysq site,
PHP-MYSQL\Bible mysq Folder |
| A- Main files of this
application |
|
|
Bible.php, it is main file of this Application, it
is the link file
Readme.php, stores general information about
this application |
| |
| B- The files of the New
Testament Folder |
|
|
- index.php - Main file of this Folder - New Testament,
it is Links file.
- index-Group1.php - Pagination Operation, Display 1st part
of New Testament, used the a-Bible_en.sql database file and
the part files of index-Group1.php: css/style.css,
css/pagination.css, css/grey.css, function.php, values1.php and
valuess.php.
- index-Group2.php - Navigation Operation, Display 2nd part
of New Testament, used the a-Bible-new2-en.sql database file
and the part files of index-Group2.php: css/style.css.
- search-Bible_NT1.php - Search Operation, Select Combo or
Input data. Display data from 1st part of New Testament, used the
a-Bible_en.sql database file and the part file of
search-Bible_NT1.php: serchdisplay2.php.
- search-Bible_NT2.php - Search Operation, Select Combo or
Input data. Display data from 2nd part of New Testament, used the
a-Bible-new2-en.sql database file and the part file of
search-Bible_NT2.php: serchdisplay2.php.
|
| |
| C- The files of the Old
Testament Folder |
|
|
- index.php - Main file of this Folder - Old Testament,
it is Links file.
- index-Group1.php - Pagination Operation, Display 1st part
of Old Testament, used the a-bible-olde1.sql database file
and the part files of index-Group1.php: css/style.css,
css/pagination.css, css/grey.css, function.php, values1.php and
valuess.php.
- index-Group2a.php - Navigation Operation, Display 2nd part
- a of Old Testament, used the a-bible-olde2a.sql database
file and the part files of index-Group2a.php:
css/style.css.
- index-Group2b.php - Navigation Operation, Display 2nd part
- b of Old Testament, used the a-bible-olde2b.sql database
file and the part files of index-Group2b.php:
css/style.css.
- index-Group3.php - Pagination Operation, Display 3th part
of Old Testament, used the a-bible-olde3.sql database file
and the part files of index-Group3.php: css/style.css,
css/pagination.css, css/grey.css, function.php, values1.php and
valuess.php.
- search-Bible_OT1.php - Search Operation, Select Combo or
Input data. Display data from 1st part of Old Testament, used the
a-bible-olde1.sql database file and the part file of
search-Bible_OT1.php : serchdisplay2.php.
- search-Bible_OT2a.php - Search Operation, Select Combo or
Input data. Display data from 2nd part - a of Old Testament, used
the a-bible-olde2a.sql database file and the part file of
search-Bible_OT2a.php : serchdisplay2.php.
- search-Bible_OT2b.php - Search Operation, Select Combo or
Input data. Display data from 2nd part -b of Old Testament, used
the a-bible-olde2b.sql database file and the part file of
search-Bible_OT2b.php : serchdisplay2.php.
- search-Bible_OT3.php - Search Operation, Select Combo or
Input data. Display data from 3th part of Old Testament, used the
a-bible-olde3.sql database file and the part file of
search-Bible_OT3.php : serchdisplay2.php.
|
|
| |
|
|
in Dreamweaver, select or open (php) files,
Go
to File -> Preview in Browser -> IExplore or chrome, to Show
and display the Search Operations... |
| Bible.php |
|
| |
| Readme.php |
|
|
| |
| New Testament -
index.php |
|
|
| New Testament -
index-Group1.php |
|
|
| New Testament -
index-Group2.php |
|
|
| New Testament -
search-Bible_NT1.php |
|
|
| New Testament -
search-Bible_NT2.php |
|
|
| |
| Old Testament -
index.php |
|
|
| Old Testament -
index-Group1.php |
|
|
| Old Testament -
index-Group2a.php |
|
|
| Old Testament -
index-Group2b.php |
|
|
| Old Testament -
index-Group3.php |
|
|
| Old Testament -
search-Bible_OT1.php |
|
|
| Old Testament -
search-Bible_OT2.php |
|
|
| Old Testament -
search-Bible_OT2b.php |
|
|
| Old Testament -
search-Bible_OT3.php |
|
|
| |
| |
| |
|
|
