about dynamic sites front end back end implementations l.
Skip this Video
Loading SlideShow in 5 Seconds..
About Dynamic Sites (Front End / Back End Implementations) PowerPoint Presentation
Download Presentation
About Dynamic Sites (Front End / Back End Implementations)

Loading in 2 Seconds...

play fullscreen
1 / 18

About Dynamic Sites (Front End / Back End Implementations) - PowerPoint PPT Presentation

  • Uploaded on

About Dynamic Sites (Front End / Back End Implementations) by Janssen & Associates Affordable Website Solutions for Individuals and Small Businesses What Are PHP and MySQL?

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'About Dynamic Sites (Front End / Back End Implementations)' - omer

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
about dynamic sites front end back end implementations

About Dynamic Sites(Front End / Back End Implementations)


Janssen & Associates

Affordable Website Solutionsfor Individuals and Small Businesses

what are php and mysql
What Are PHP and MySQL?

PHP is a server-side scripting language designed specifically for the Web. Within an HTML page, you can embed PHP code that will be executed each time the page is visited. Your PHP code is interpreted at the Web server and generates HTML or other output that the visitor will see.

MySQL is a very fast, robust, relational database management system. A database enables you to efficiently store, search, sort and retrieve data. The MySQL server controls access to your data to ensure that multiple users can work with it concurrently, to provide fast access to it and ensure that only authorized users can obtain access.

One of the nice features of PHP is that it is available for Microsoft Windows, for many versions of UNIX (Linux/Apache) , and with any fully functional Web server. MySQL is similarly versatile.

php mysql web development
PHP/MySQL Web Development
  • Mastering the concepts
    • Encompassing advanced PHP and MySQL syntax, database design, Internet application analysis and design and network security
  • Building the applications
    • Creating sophisticated, secure Web applications that meet commercial, real-web needs
php mysql development tools
PHP/MySQL Development Tools
  • PHP
    • The server-side scripting language that allows the website to be truly dynamic
  • MySQL
    • The database construct that enables PHP and Apache to work together to access and display data in a readable format to the browser
  • Apache
    • Acts as your Web server by parsing any file requested by the browser and displaying the correct results according to the code within that file
dynamic site applications
Dynamic Site Applications
  • User Authentication
  • E-commerce Sites (Shopping Carts)
  • Secure Transactions
  • Content Management Systems
  • Web-Based E-mail Service
  • Newsletter and Mailing List Manager
  • Web Discussion Forums (Chat Rooms)
more dynamic site applications
More Dynamic Site Applications
  • Online Address Book
  • Real-time Calendars
  • Log Files
  • Bulletin Board Systems
  • Online Polls
  • Visitor Accounts
  • Project Management
php mysql web development7
PHP/MySQL Web Development
  • A user’s Web browser issues an HTTP request for a particular Web page.
  • The Web server receives the request, retrieves the file and passes it to the PHP engine for processing.
  • The PHP engine begins parsing the script. PHP opens a connection to the MySQL server and sends on the appropriate query.
  • The MySQL server receives the database query and processes it, sending the results back to the PHP engine.
  • The PHP engine finishes running the script and formats the query results nicely in HTML. It then returns the resulting HTML to the Web server.
  • The Web Server passes the HTML back to the browser.
update data that always changes
Update Data That Always Changes

The rates box below that is on this website will automatically be updated once the rate table on the left is modified.

update member profiles
Update Member Profiles

After the member logs in successfully, they can change their password, update the information in their database record and upload a picture if they wish. The changes are then reflected on their website page, which shows the updated information.

shopping cart management
Shopping Cart Management

Below is the dynamic part of a website page, where the customer maintains all product information in a database, which is generated dynamically when this page is selected based on several criteria.

advantages of php
Advantages of PHP
  • Read and write files
  • Gather and process form data
  • Send data via e-mail
  • Access and manipulate database records
  • Read and write cookies
  • Maintain data in session variable
  • Facilitate user authentication
  • High speed and stability over HTML
  • High levels of security
  • PHP is server-side code, so it can’t be viewed
advantages of mysql
Advantages of MySQL
  • Cost-Effective
    • MySQL is free for development
  • Quick and Powerful
    • For small to medium databases, MySQL is extremely fast and is a relational database
  • Improves All the Time
    • The developers release updates frequently and are adding impressive features all the time
static versus dynamic pages
Static Versus Dynamic Pages

There are many limitations when building websites using just plain HTML.

Static content from a pure HTML website is just that --- static.

It stays the same unless you physically update it. Your users can’t interact with the website in any meaningful fashion.

Using a dynamic language such as PHP and a database such as MySQL allows you to make your website dynamic …

Dynamic websites are fully customizable and contain real-time information.