Programmer Kingdom

How to Handle Relationships

2010-03-29T00:00:00-07:00

This tutorial is intended for those developers who come across the situation where they need to cater for what is known as a 'many-to-many' relationship. This tutorial will show a technique that has been successful for me for many years. How to Handle a Many-to-Many Relationship with PHP and MySQL Intended Audience This tutorial is intended for those developers who come across the sit...........

Accessing MySQL Database Data

2010-03-29T00:00:00-07:00

Ok, we now have our data in the database, so how do we actually put this data to use? Ok, we now have our data in the database (if you don't know what I'm talking about, see last weeks informant). PHP and Accessing MySQL Database Data If you are new to the TheScripts.com series of tutorials on PHP and MySQL tutorials, I will restate a few things... This tutorial is based on...........

PHP / MySQL Tutorial

2010-03-29T00:00:00-07:00

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 / MySQL Tutorial MySQL is currently 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 powerful an...........

MySQL Admin

2010-03-29T00:00:00-07:00

This lesson covers the different options you have available to you for administering your MySQL service after it is successfully installed. If you already have that base covered feel free to skip on to the next lesson. MySQL Admin This lesson covers the different options you have available to you for administering your MySQL service after it is successfully installed. If you already ...........

MySQL Database Backups

2010-03-29T00:00:00-07:00

If you're storing anything in MySQL databases that you do not want to lose, chances are you should be doing weekly or even daily backups. You may or may not know that MySQL databases are just files that are stored on your web server. MySQL Database Backups If you're storing anything in MySQL databases that you do not want to lose, chances are you should be doing weekly or even daily b...........

Sending queries to mySQL

2010-03-29T00:00:00-07:00

PHP send quesries to mySQL using mysql_query function. mysql_query function returns boolean (True or False) value which your quesry does not return any records.If query is true, returning value must pass to mysql_fetch_array(). Sending queries to mySQL PHP send quesries to mySQL using mysql_query function. mysql_query function returns boolean (True or False) value which your quesry d...........

Running Some Queries

2010-03-29T00:00:00-07:00

Ours is not to reason why, ours is just to do and query. Consequently we'll continue with queries without further ado! For our MySQL database this means using the mysql_query ( ) function. Databases in PHP - MySQL in PHP - Running Some Queries Continuing the process of adding access to a MySQL Database to our HTML pages, we now need to interact with the database we previously ...........

Using MySQL with PHP

2010-03-29T00:00:00-07:00

This chapter describes: How to configure PHP with a MySQL server. What are the basic functions to use a MySQL server and a test script with a MySQL server. Using MySQL with PHP This chapter describes: How to configure PHP with a MySQL server. What are the basic functions to use a MySQL server. A test script with a MySQL server. Configuring PHP with MySQL ...........

Putting PHP & MySQL To Work

2010-03-29T00:00:00-07:00

In this tutorial, a link at the top of the Web page brings visitors to the login page, where they can sign in or create a new account. To create a new account, the visitor enters an e-mail address and a password. Putting PHP and MySQL to work The days of static Web sites are gone. Most major Web sites now offer the ability for each visitor to customize the site to their liking. S...........

Script Web Databases Quickly

2010-03-29T00:00:00-07:00

You'll learn how to install and configure PHP for use with the Apache Web server on UNIX or the Microsoft Internet Information Server on Windows NT. You'll see by example how to use PHP to route HTML, to develop a simple database-driven Web application. Flexible Open Source Tools Find out how to script in PHP, an open-source embedded scripting language for HTML. You'll learn how to i...........

Connecting to a Database

2010-03-29T00:00:00-07:00

You need to have a connection to mysql before you can send and recieve data. This first code will define the DB variables, so you will need to enter all of your database info! Connecting to a Database You need to have a connection to mysql before you can send and recieve data. This first code will define the DB variables, so you will need to enter all of your db info! adsens...........

Saving & Downloading

2010-03-29T00:00:00-07:00

This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. Uploading, Saving and Downloading Binary Data in a MySQL Database This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a My...........

Get Size of a MySQL Database

2010-03-29T00:00:00-07:00

This simple tutorial will show you how to get the size of a MySQL database using PHP in just a few simple steps. First of you'll need my formatfilesize() function; for this script to work you will obviously need to connect to your MySQL database. Get the size of a MySQL database with PHP This simple tutorial will show you how to get the size of a MySQL database using PHP in just a few...........

Creating OO MySQL Abstraction

2010-03-29T00:00:00-07:00

In this tutorial you will learn how to create an object oriented database abstraction class for MySQL databases. Besides the basic functions this manager class can summarize total time spent with db connections, query executions, and more. Creating an object oriented MySQL abstraction class In this tutorial I will show you how you can create an object oriented database abstraction...........

Simple DB Management System

2010-03-29T00:00:00-07:00

In this tutorial, you will the steps that ar needed to not only learn but create a simple but effective database management system. Simple DB Management System Here is a simple dbms that I made.

Create A Database On The Fly

2010-03-29T00:00:00-07:00

Need to have databases created with a back end application?This tutorial shows the database that was created from this online application. It was pre filled with tables and data from another script that ran right after the database was made. Create a database on the fly In some recent work I needed to have databases created with a back end application. Once the database was created fr...........

PHP/MySQL Select Data and Split

2010-03-29T00:00:00-07:00

This tutorial is going to show you how to SELECT data from a MySQL database, split it on multiple pages and display it using page numbers. PHP / MySQL select data and split on pagesThis tutorial is going to show you how to SELECT data from a MySQL database, split it on multiple pages and display it using page numbers. We have MySQL table called “students” holding 90 reco...........

PHP MYSQL Functions

2010-03-29T00:00:00-07:00

The MySQL functions allows you to access MySQL database servers. For the MySQL functions to be available, you must compile PHP with MySQL support. For compiling, use --with-mysql=DIR (the optional DIR points to the MySQL directory). PHP MySQL Functions PHP: indicates the earliest version of PHP that supports the function. mysql_affected_rows() Returns the number of affected rows ...........

Displaying MySQL Table Structures

2010-03-29T00:00:00-07:00

You can get information about tables using SHOW TABLE STATUS query. This query gives you a detailed info about all tables in your database. Code sample will show you find next Autoindex in selected table. Displaying mySQL table structures in PHP You can get information about tables using SHOW TABLE STATUS query. This query gives you a detailed info about all tables in your database. ...........

What Are Databases?

2010-03-29T00:00:00-07:00

Databases are programs that are built to store and manage information. You can think of a database as a virtual filing cabinet … with extra bells and whistles. Read this article to find out more! WHAT ARE DATABASES Databases are programs that are built to store and manage information. You can think of a database as a virtual filing cabinet … with extra bells and w...........

Stored Procedure With mySQL

2010-03-29T00:00:00-07:00

MySQL Stored Procedures and PHP can prove to be a great combination! This article explains about MySQL Stored Procedures in detail including its Syntax, Application areas and an example that uses PHP coding along with MySQL SP. Using Stored procedure with mySQL and PHP Writing external scripts to perform complex data handling is a tedious affair. The best way to automate tasks strai...........

Web Database Access

2010-03-29T00:00:00-07:00

In this tutorial, we will explore a straightforward solution that is used to access web databases using desktop applications, and that you can use in your own systems. We will be using MySQL, but the principles apply to any other online RDBMS. Web Database Access from Desktop Applications There may be growing interest in moving computer applications from the desktop to the Web. B...........

PHP Snurk

2010-03-29T00:00:00-07:00

When you run a database-driven website, it makes sense to generate pages on the fly. PHP, MySQL, and Apache let you do just that. But they don't make it pretty. The PHP Snurk lets you make such search-engine friendly URLs for dynamically-generated pages. The PHP Snurk - v0.02 When you run a database-driven website, it makes sense to generate pages on the fly. PHP, MySQL, and Apache...........

Working with checkboxes

2010-03-29T00:00:00-07:00

Over in the php help forum, the question of how to deal with checkboxes arises pretty often. Usually, people want to be able to select which rows of a database to update/delete/throw out the window. Working with checkboxes and a database Introduction Over in the php help forum, the question of how to deal with checkboxes arises pretty often. Usually, people want to be able to selec...........

PHP Basic Database Handling

2010-03-29T00:00:00-07:00

"Handling a database with PHP" can be a bit misleading. PHP is not the one responsible for doing anything to your database. All it does is send the query string to your database and your database executes the query. PHP Basic Database Handling "Handling a database with PHP" can be a bit misleading. PHP is not the one responsible for doing anything to your database............

Working with a Database

2010-03-29T00:00:00-07:00

The [Easy as Pie] series focuses on tasks that most people consider too challenging and presents it in a way that is easy (as pie!) to understand. If you're like me, you learn really well from example. EASY WORKING WITH DATABASE The [Easy as Pie] series focuses on tasks that most people consider too challenging and presents it in a way that is easy (as pie!) to understand. C...........

Next-Previous Links

2010-03-29T00:00:00-07:00

If you have a myriad of data on your database and want to display it in a nice orderly manner, then you might want to display only part of the data per page so that all the data doesn't makes a scrolling nightmare. Next-Previous Links This tutorial will show you how to make next previous links for a mySQL database. If you have a myriad of data on your database and want to display i...........

Database design fundamentals

2010-03-29T00:00:00-07:00

This is a mini-guide with hot tutorials to learn, step-by-step, how to design a database from relationships-entities model to final implementation using SQL, MySQL and PHP. If you are a newbie to design database you can find it very useful. DATABASE DESIGN FUNDAMENTALS This is a mini-guide with hot tutorials to learn, step-by-step, how to design a database from relationships-enti...........

MySQL Databases (PART 1)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. MySQL Databases and the SQL Language Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed ...........

MySQL Databases (PART 2)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Part 2 - Structures and Data CREATE-ing tables and INSERTing data. Requirements You should have completed the Part 1 of this tutortial in this series. Important information to understand before be...........

MySQL Databases (PART 3)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc Part 3 - Manipulating Data UPDATEs, DELETEs and Advanced SELECTs. Introduction In the previous part we have looked at logging into MySQL, creating tables, adding and selecting data using SQL stateme...........

MySQL Databases (PART 4)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Manipulating Structures ADDing, ALTERing and DELETE-ing Columns and Tables. Introduction By this point you should be very familiar with SQL statements and manipulating data within database TABLEs. In...........

MySQL Databases (PART 5)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Part 5 - Joins Using SQL Statements to retrieve data from multiple tables. Introduction In this Virtual Workshop we will look at retrieving data from a relational database structure, i.e. with multip...........

MySQL Databases (PART 6)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Part 6 - Adminstration CREATE-ing databases, creating users, managing permissions and backing up data. Introduction In the other MySQL Virtual Workshops we have used commands that are pretty much a...........

MySQL Databases (PART 7)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Part 7 - Normalisation A look at database theory that aims to be accessible for the novice developer. Introduction In the previous workshops in the MySQL series, I've hinted at elements of database t...........

MySQL Databases (PART 8)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Part 8 - Advanced Queries Aliasing and referencing, Self-Joins, Temporary Tables, Full Text Searches. Introduction Earlier in this series when we looked at SQL statements we were primarily concerned w...........

MySQL Databases (PART 9)

2010-03-29T00:00:00-07:00

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc. Part 9 - Built-in Functions Date Functions, Mathmatics Functions, String Functions. Introduction Thus far when retrieving stored data we have simply displayed the results of any query. MySQL can do m...........

Build a Query Processor Class

2010-03-29T00:00:00-07:00

In this article you will learn how to use some useful PHP networking functions that will help you perform a variety of common networking tasks. To that end, you will build a simple networking query application in PHP 5. Build a Query Processor Class for Networking in PHP 5 Welcome to the first of three tutorials in a series that covers network programming in PHP. In this article yo...........

Export Database

2010-03-29T00:00:00-07:00

The script below reads the schema from a MySQL database and outputs XML that describes the schema. At first we connect to a MySQL database and use the SHOW TABLES command to return all the tables in the database. PHP: Export Database Schema as XML Sometimes it can be useful to have a dump of the current database schema. The script below reads the schema from a MySQL database and ...........

Install Firebird/Interbase

2010-03-29T00:00:00-07:00

This simple tutorial assumes you already have a working PHP installation. There's plenty of guides on how to set up PHP, here I'm only showing how to make it interact with Firebird. How toInstall Firebird/Interbas(A step by step tutorial) This simple tutorial assumes you already have a working PHP installation. There's plenty of guides on how to set up PHP, here I'm only showing ho...........

PHP database problems

2010-03-29T00:00:00-07:00

You can create database design, database access, and the PHP business logic code that sits on top of it in any number of ways, and you often end up getting it wrong. This article illustrates five common problems in database design. Five common PHP database problems If only there were one way to use databases correctly ... You can create database design, database access, and t...........

Unit tests

2010-03-29T00:00:00-07:00

There are many unit test frameworks in the PHP world, mostly based on Junit. We didn't develop another one for symfony, but instead we integrated the most mature of them all, Simple Test. There is a thing that has not been described until now, despite its importance in the life of web applications. Unit tests are one of the greatest advances in programming since object orientation. Th...........

Web Database Access

2010-03-29T00:00:00-07:00

There may be growing interest in moving computer applications from the desktop to the Web. But desktop applications are still a huge market, whose demise has been prematurely reported by the media in the past, and will most likely be reported in future. Web Database Access from Desktop Applications There may be growing interest in moving computer applications from the desktop to the ...........

Script Web Databases

2010-03-29T00:00:00-07:00

Find out how to script in PHP, an open-source embedded scripting language for HTML. You'll learn how to install and configure PHP for use with the Apache Web server on UNIX or the Microsoft Internet Information Server on Windows NT. Script Web Databases Quickly with PHP Scripting Language Flexible open-source tool works with seven databases Find out how to script in PHP, an open-s...........

Record locking in Web apps

2010-03-29T00:00:00-07:00

In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot know if the user left the page. We used lock confirmation technique combined with lock expiration to solve this problem. Record locking in Web applications Record locking...........

Storing Images in a Database

2010-03-29T00:00:00-07:00

This tutorial teaches you how to upload images into a MySQL database using PHP. Even though it sounds complicated, it is fairly simple and has many practical applications. One example of an application would be Forum User Images. Storing Images in a Database This tutorial teaches you how to upload images into a MySQL database using PHP. Even though it sounds complicated, it is fairly ...........

PHP Database

2010-03-30T00:00:00-07:00

With an ODBC connection, you can connect to any database, on any computer in your network, as long as an ODBC connection is available. Here is how to create an ODBC connection to a MS Access Database. Create an ODBC Connection With an ODBC connection, you can connect to any database, on any computer in your network, as long as an ODBC connection is available. Here is how to create ...........

Flexible Database Driven Menu

2010-03-30T00:00:00-07:00

In this tutorial we'll see how to create a fully database driven menu. Our menu will work fine also if we decide to insert some links later in time as we'll use a position index to sort the menu links. Flexible Database Driven Menu In this tutorial we'll see how to create a fully database driven menu. Our menu will work fine also if we decide to insert some links later in time a...........

Flat File Databases

2010-03-30T00:00:00-07:00

PHP is a very powerful language, even without the use of a database, but you can only go so far without the need to store and retrieve data. One way to do this is by using flat files. Flat File Databases PHP is a very powerful language, even without the use of a database, but you can only go so far without the need to store and retrieve data. One way to do this is by using flat ...........

Restoring MySQL Databases

2010-03-30T00:00:00-07:00

If you happen to have data stored in a MySQL database, it is good for you to learn how to backup and restore the database. While MySQL is pretty reliable, random human/comp errors, corrupted data, unwanted intruders, etc. Backing Up/Restoring MySQL Databases If you happen to have data stored in a MySQL database, it is good for you to learn how to backup and restore the ...........

Databases and SQL

2010-03-30T00:00:00-07:00

As if PHP wasn't enough, now you find out you have to be able to work with databases as well! Well, never fear, Timothy has a database primer that will get you headed in the right direction. Databases are stores of information. Databases and SQL As if PHP wasn't enough, now you find out you have to be able to work with databases as well! Well, never fear, Timothy has a database prime...........

Managing Tables

2010-03-30T00:00:00-07:00

A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages. A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on cr...........

Build a PHP Link Scraper

2010-03-30T00:00:00-07:00

We're going to build a robot that scrapes links from web pages and dumps them in a database. Then it reads those links from the database and follows them, scraping up the links on those pages, and so on ad infinitum. Build a PHP Link Scraper with cURL We're going to do WHAT? You heard me! We're going to build a robot that scrapes links from web pages and dumps them in a...........