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
Do You Need to Know How to Draw or Sketch to be a Graphic Designer?
Plenty of graphic designers have gotten jobs without knowing how to draw at all. Nevertheless, learning how to draw or sketch can be invaluable for three big reasons.
![]() |
![]() |
|
![]() |
![]() |
|
Minimalist Website Design Can Now Improve Search Engine Position
A minimalist web design makes your webpage load faster, which is now one of the criteria Google uses to determine a website's search engine position.
Tips for Taking the Guesswork out of Web Design
Web design can sometimes feel a little like mind reading–clients trying to express abstract ideas about what they want, you trying to divine what they mean, all of you hoping to land on some kind of common ground. But the design process doesn?t have to be such a scary leap into the unknown.
Expert user experience [...]
Quick Ways to Bump up Your Web Design Skills
MediaBistro is offering one killer deal for anyone looking to bump up his/her web design skills. Right now you can get a year subscription to their On Demand Video library for just $97–that?s more than half off the usual price!
The On Demand Videos are a great resource for any designer, and include practical online tutorials [...]
How to Design an iPhone Application: Part 2
So the last post started you down the road to iPhone app stardom. Now let?s talk about how to execute your big idea and actually get it up and running in the iTunes store:
5. Get going on the design work.
While you?re waiting for Mac?s Software Development Kit (SDK) and Xcode files to download, work on [...]
How to Design an iPhone Application: Part 1
Earlier this week, the New York Times reported that Apple banished app developer Thuat Nguyen and all of his applications from the iTunes online store. It was a severe punishment for a prolific book app provider, but a necessary one. It seems that Nguyen was breaching user?s accounts to make purchases (of his own applications) [...]
Time-saving Tools You Shouldn?t Miss
Smashing Magazine recently posted an excellent roundup of powerful time savers for web designers–a whopping 50 of them. Funny, trolling through a list of 50 web design tools built to help you save time doesn?t seem very efficient. That?s why you can find a recap of 4 of the most helpful/innovative/time saving ones below. They?re [...]
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.
15 Beautiful and Inspiring Nature Photographs ? Whoaa!
Need a good captcha generating php script
Removing background from images
Purdy Picture...
selling photography and illustrations as stock photos
Photo
Amatus-Grey
iMac vs Mac Pro
What Camera Do You Use?
What are some really good design schools in NC & California?
HDR photography ( High Dynamic Range)