Print Design Templates Take a look at these creative Graphic Design templates for brochures, flyers, newsletters, stationery, postcards, ads, menus and posters for a variety of businesses.
Invoicing 4 Freelancers A complete, secure, online billing application that maintains hourly service billing, flat fee billing and recurring charges. Integration with Authorize.Net and other leading payment gateways provides hands-free recurring billing with a sophisticated CRM system.
Free Design Magazines Browse through our extensive list of free Graphic Design, Web Design, Business, Computer, and Computer Graphics magazines, white papers, downloads and podcasts to find the titles that best match your skills and interests; topics include management, marketing, operations, sales, and technology. Simply complete the application form and submit it. All are absolutely free to freelance professionals who qualify.
Suggested Links Photoshop Tutorials
Logo Designer's Logos
Web Design Tools List
Layouts & Templates Directory
Web Design & Graphic Design Blog
Photoshop, Flash, 3D Studio Max Tutorials
Web Designers & Developers
Crafts for Kids
Photoshop Tutorial Man
Tutorial Guide -- Free Webmaster Tutorials
Design Contests
How to Draw
Work From Home Job Search
OTHER SITES WE OWN
AllFreelance
Graphic Design Resources Directory
Graphics Tutorials Directory
Social Networking Articles
Design Sites Up
All Freelance Work & Portfolios
Graphic Design Community
Education & Learning Directory
![]() |
home > Web Design Tutorials > Programming Tutorials > PHP TUTORIALS AND PHP RESOURCES
PHP-Nuke
PHP-Nuke is a web based automated news publishing and content management system T-CMS) assists an organization to manage e-commerce transactions.
PHP-Setting Up The Database
Before you actually start building your database scripts, you must have a database to place information into and read it from.
PHP-Inserting Information
Over the past two parts I have explained what I am planning to do in this tutorial and have shown you how to create a database to use with the tutorial.
PHP-Displaying Data
So far in this tutorial, you have created a database and put information into it.
PHP-more outputs
Throughout this tutorial you have learnt how to create a database and table, insert information and display the database information.
![]() |
![]() |
![]() |
||
![]() |
![]() |
![]() |
||
PHP-single record and eror traping
In the past two parts of this tutorial I have shown you how to take data out of the database and display it on screen.
mySQL & phpMyAdmin
MySQL & phpMyAdmin: The MySQL option in your control panel automates MySQL.
Introduction to mySQLand PHP
syntax that PHP has made to deal with mySQL.
Displaying Fields and Data of a MySql Table
MySQL tables in a tabular form without the SQL query console.
MySQL in PHP
MySQL will have to be added to your PHP
PHP-updating and deleting
So far you have learnt how to put information into your MySQL database, view the information in it and select which information you would like to view.
interesting PHP/MySQL thread
If you want to exploit this opportunity (which I fervently recommend) than> you should make a big push to have postgres be THE database for PHP.
PHP-finishinh the sciript
Throughout this tutorial I have taught you how to use PHP to interact with a MySQL (or SQL) database and how to use the most common commands available.
PHP-Nuke
For many people, the main reson for learning a scripting language like PHP is because of the interaction with databases it can offer.
MySQL and PHP
MySQL is chosen to power web-based database applications is PHP.
PHP-Nuke
PHP and MySQL when used together become powerful tools that are used to create dynamic and interactive websites.
PHP-php/sql
how to connect to MySQL using PHP. However, if you haven't installed PHP and MySQL go visit the first section. It explains how to install PHP, MySQL and Apache. And if you are a newcomer in PHP go to the second section to learn the basics of PHP.
PHP-Statistics script
Output of the processed information as graphs. In this section images in *.gif format are used.
PHP-How To Install Apache + PHP + MySQL
Update on 6/8/02: My primary development environment is Apache, PHP and MySQL under Windows.
PHP-Introducing PHP and MySQL
Unless you've been living on Mars for the last six to eight months, you've heard of open source software (OSS).
PHP-Installing MySQL
Let's jump straight in, grab ourselves a copy of these great packages, and get hacking! This isn't simple stuff.
PHP-Installing PHP
Phew! Hopefully you've got MySQL all up and running by now. That was almost fun! Now for PHP ... This process is slightly easier, but the array of options is dazzling.
PHP-Your First Script
You'll be glad to know that the really tricky stuff is behind you. Installation of software is always a black hole because so much changes from system to system.
PHP- Load Up a Database
So now we're ready to plug in MySQL. One handy way of knowing what options are available in PHP and what's going on in your server is to use the phpinfo() function.
PHP-Pull It Back Out
OK, now we've got our data in the database. Let's do something with it. Copy and paste the following into a text file and save it in your Web server document tree with a .php3 extension.
PHP-Getting Loopy
In this lesson, we're going to dive right in and create some simple yet useful pages using PHP and MySQL.
PHP-Stay Informed
There are a number of new features introduced here, but they're quite simple. First, there's the mysql_fetch_array() function.
PHP- Link Intelligently
We're going to take that looping power we just learned and use it in a more practical example.
MySQL Using PHP
a server with PHP and one MySQL database
PHP-Throw in Some Forms
We've managed to get data from a database without much difficulty. PHP scripting language's power truly comes to life when used in conjunction with a powerful database like MySQL.
PHP/MySQL
PHP and MySQL are the world's best combination for creating data-driven sites.
Accessing MySQL from PHP
use PHP and MySQL.
PHP- Make the Forms Smarter
Throughout this tutorial, I've been loading the SQL statement into a variable ($sql) before firing the query at the database with mysql_query(). This is useful for debugging. If something goes wrong, you can always echo the SQL to the screen to examine it for mistakes.
PHPAll Together Now
We'll finish up this lesson by putting everything into a single page that can add, edit, and remove entries from the database.
PHP- A Place for Everything
you already know the essentials for installing and writing useful scripts with MySQL and PHP. We're going to look at some useful PHP functions that should make your life a lot easier. First, let's look at include files.
PHP- Simple Validation
Imagine for a moment that we've got our database nicely laid out and we're now requesting information from users that will be inserted into the database.
PHP-Not-So-Simple Validation
Let's talk a bit about using regular expressions with the ereg() and eregi() functions.
PHP- Functions
Enjoy that last regex expression? Fun, wasn't it? Wouldn't it be even more fun to enter that chunk on a dozen different pages that need to process email addresses?!
PHP-Nuke
PHP-Nuke
MySQL is the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create dynamic and powerful server applications.
PHP-connect to my sql using php
Opening a connection to MySQL database from PHP is easy.
PHP-install mysql using php
Installing apache is easy if you download the Microsoft Installer ( .msi ) package. Just double click on the icon to run the installation wizard.
PHP-
adding new user and managing users
PHP-Nuke
PHP-creat new database
You need to use mysqladmin to create MySQL database. The command is simple just write mysqladmin in a dos window followed by the database name you want to create
PHP-creat mysql table in php
The first one describe the species of animals available in a pet store and the second will store the data of a pet in the store. The table names will be species and pet
PHP-insert table in my sql
You can insert data to the tables directly from mysql> prompt or by loading a file containing the data. The values will be tab separated one line represent one record
PHP-retriving data
Retrieving the table data is easy, just use the SELECT statement like this
PHP-MySQL Update And Delete
The statement UPDATE is used to change the value in a table.
PHP-Overview
Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL. According to Graeme, PHP and MySQL are the world's best combination for creating data-driven sites
Introducing PHP and MySQL
Enter PHP and MySQL. These two make up what must be the best combination for data-driven Web sites on the planet.
getting loop
The loop says that as long as there are new rows of data to be grabbed (using the mysql_fetch_row() function), assign that row to the $myrow variable.
PHP-working with files
you use require() and the file you're including does not exist, your script will halt and produce an error
Beginners guide to PHP and MySQL
In this tutorial we will build step by step a small web site using PHP and MySQL with the following features.
PHP-Build your own Database Driven Website using PHP & MySQL
This tutorial is aimed at intermediate or advanced Web designers looking to make the leap into server-side programming. You'll be expected to be comfortable with simple HTML, as the tutorial makes use of it without much in the way of explanation.
PHP-Database backed Web application development environment for Windows 95/98/ME platform using open-source tools
Apache, PHP4 and MySQL are open source technologies that allow you to create powerful and fast database-generated Web site applications.
PHP-Building a Simple Affiliate System in PHP/MySQL
Today, we're going to discuss building a simple Affiliate System. Affiliate Systems are useful for people who want to have affiliates on their sites to help boost
PHP-database application and the web
Most of the services we enjoy on the Web are provided by web database applications. Web-based email, online shopping, forums and bulletin boards, corporate web sites, and sports and news portals are all database-driven.
PHP-PHP MySQL Introduction
PHP and MySQL when used together become powerful tools that are used to create dynamic and interactive websites.
PHP-Advanced Data Handling
This article is part three of an introduction to application development for the Nennius engine. If you have not yet read part one or two, you should do so before continuing. We will be enhancing the News Manager application
PHP-creating a web application
PHP-Introducing Nennius
PHP has grown in popularity over the years, in part due to its rapid speed of development. Through the use of PHP, simple dynamic elements may be added to existing websites without extensive modifications.
PHP-starting MySQL & PHP
The first thing we need to do is verify that the two major components of this tutorial are working correctly. If you do this now, it will rule out a whole host of potential errors when you are attempting to debug the minor scripts written in this tutorial.
PHP-Basic Selects
you can select the name of any particular person if you already have the ID. The function call QueryItem returns a scalar value.
PHP-Insert, Update and Delete
The easiest way around these problems is to create an HTML form which asks them nicely for the information you want. When the form is submitted, a PHP script will read the information and stuff the results into the database
PHP- Dealing with Time
MySQL has a 14 byte datetime type which is very useful
PHP-Naming Columns PHP-Naming Columns
MySQL allows you to name the displayed columns. So instead of f_name or l_name etc.
PHP-Connecting to the MySQL Server
Before you can perform any operation on a database you must connect to the MySQL server.
PHP-Creating a Table
A database will contain a variable number of tables of data which are arranged in columns and rows.
PHP-Parsing Multiple Selections
Very often a form will allow a user to select more than one choice from a list of choices.
PHP-Create a Simple Poll
Create the database through your PHPMySQL Admin Panel or modify the birthday scripts to create a table.
PHP-HAVING clausePHP-HAVING clause
To list the average salary of employees in different departments (titles), we use the GROUP BY clause.
PHP-Updating records
The SQL UPDATE command updates the data in tables.
PHP-PHP/MySQL
MYSQL-Introduction
In this tutorial I will show you how to use PHP and the MySQL database to store information on the web and include it into your website
MYSQL-Setting Up The Database
Before you actually start building your database scripts, you must have a database to place information into and read it from
MYSQL-Inserting Information
in this tutorial and have shown you how to create a database to use with the tutorial.
MYSQL-Displaying Data
in this tutorial, you have created a database and put information into it
MYSQL-More Outputs
Throughout this tutorial you have learnt how to create a database and table, insert information and display the database information.
MYSQL-Single Records & Error Trapping
In the past two parts of this tutorial I have shown you how to take data out of the database and display it on screen.
MYSQL-Updating & Deleting
So far you have learnt how to put information into your MySQL database, view the information in it and select which information you would like to view.
MYSQL-Finishing the scripts
Throughout this tutorial I have taught you how to use PHP to interact with a MySQL (or SQL) database and how to use the most common commands available
RECENT ARTICLES from Graphic Design BloG
3D Photoshop Object Projects and Tutorials - Part II
More 3D for Fun and FunctionIn our last article we presented some nifty examples of what you can do with Photoshop in creating your own 3D objects. There are literally thousands of PS objects that you can download from the Internet, but the process of making your own Photoshop 3D items is not only fun [...]
![]() |
![]() |
|
![]() |
![]() |
|
Got (Photoshop) Gadgets? Part I
Spruce Up Your Website
Are you tired of the same old button gadgets everyone else uses on their websites? If you are, here are a few gadgets you can create in Photoshop that may bring some bling to your webpages. A big thanks to Hongkiat for assembling most of these tutorials.
Flash Drive Gadget
For all those tech [...]
Things You Won?t Hear About Successful Web Designers - Part II
Got Customers?
Take the case of “Jesse,” a brilliant web designer. It’s obvious that he has serious skills in design and can run circles around other web designers when it comes to talent. But oddly enough, he doesn’t have many customers.
On more than one occasion he tells his customers that he is “overworked” and complains about [...]
Things You Won?t Hear About Successful Web Designers - Part I
What You Need
If you ask most employed web designers what factors were most important in their development as a web designer you’ll probably hear “experience” and “school” at the top of their lists.
Outside of coding skills there are other elements that make a web designer successful. The following traits are things that you won’t usually [...]
How to Select a Good Web Design College
Some Guidelines and Tips
If you are seriously considering going to college for your graphic design education or web design degree you already know that there are no shortages of available colleges, universities, and online education centers that constantly vie for your attention. But how can you distinguish between the good schools and the bad ones? [...]
Twas the Night Before Debugging
Happy Holidays!
We just wanted to say thanks for visiting this site and to wish everyone a restful and happy New Year. We’ve done a little parody of a famous poem for all you web designers out there. We hope you like it.
Twas the Night Before Debugging
by Frank Ling aka “Admin”
Twas the night before debugging when [...]
Got Scripts and Website Design Resources? Part I
Got Scripts?
In this week’s article we’ve spotlighted some websites that provide various script resources for web designers. You’ll find everything from hit counters, animated menu scripts to useful tutorials and other useful helps.
When you need that certain something for your next project, you’ll probably find it on one of these websites.
.
.
.
PHP Junkyard
Here is a great [...]
All Web Design Resources is a Directory & Blog Full of Tools for Web Site Designers
All Web Design Resources Portal is a Web Site Design education directory with resources & articles for Graphic Designers, Web Developers, & Web Designers including a Web Design forum, blog, graphics software tips, web development resources, web programming tools, web design jobs, advice for new web designers about web design schools and education as
well as tips for freelance web design business owners, and much more.
Hey - it's a MOVIE thread!
Tunes while you design
A whole lot of unessesary quotations.
Is Mozilla the best browser???
Finally!
Bad Photograph?
What should I minor in?
My Photos
PLEASE HELP: Would a two year degree hurt me?
My new photo website
Dreamweaver Won't Preview In Browser
Prints made from original artwork?
Best of Brochure Design the sequel