want to join us? register, it's easy | help

browse by tag: database

sort by

newest, oldest, most popular


category icon

How to connect to MySQL database using PHP

in PHP added by goodphptutorials, on 29/11/2006 database databases mysql php

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

comment save report
category icon

Incremental MySQL Backups

in PHP added by goodphptutorials, on 4/12/2005 backup databases mysql

Backing up a database is something that should be done regularly on a dynamic driven website

comment save report
category icon

Get the Size of a MySQL Database

in PHP added by goodphptutorials, on 24/7/2006 databases

Output the size of a MySQL database with this simple script

comment save report
category icon

Simple Search Engine with PHP and MySQL

in PHP added by mckinleysh, on 10/12/2007 database mysql search engine

There might be many reasons why you may be storing data in a database. As Google has showed us, searching data is an invaluable tool that can help minimize the time that it takes to find the information you need.
I would like to show you how you can build your own PHP search engine to find the information you seek in a MySQL database.

comment save report
category icon

5 useful PHP functions for MySQL Data Fetching

in PHP added by AnyExample, on 5/4/2007 database databases fetching data mysql

In this article we present 5 useful functions which greatly simplify majority of real-life MySQL operations: error-checked execution of SQL queries, getting single row from SQL table, getting value from SQL table cell, etc.

comment save report
category icon

MySQL Databases and the SQL Language

in PHP added by goodphptutorials, on 25/5/2007 database databases mysql

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, there are very few that want to use MySQL to teach the SQL syntax and with it a bit about databases for the novice.

comment save report
category icon

Optimize all your databases with one script

in PHP added by goodphptutorials, on 1/9/2006 databases

This script identifies all the databases and all the tables that has access, and if is needed it optimizes them.

comment save report
category icon

How To: Code Your First Web App (Part 1)

in PHP added by goodphptutorials, on 22/8/2007 beginner tutorials database framework mysql user

In its most basic form, a web application is typically comprised of multiple files utilizing PHP and MySQL technologies on a LAMP server. PHP provides a powerful means of carrying out your web application's functions by way of server-side scripting while MySQL is used to store information in a database. In this series of posts I will be showing you how easy it is to create a simple web application framework which you can adapt for almost any purpose - all this with only basic PHP and MySQL knowledge.

comment save report
category icon

SQLite tutorial for PHP 5

in PHP added by goodphptutorials, on 11/10/2006 databases

This quick SQLite tutorial will walk you through how to connect, create, insert and query a SQLite database using PHP 5. Object oriented code is also covered. The tutorial covers SQLite2 and SQLite3.

comment save report
category icon

MySQL Functions

in PHP added by goodphptutorials, on 8/12/2005 databases functions mysql reference

The defacto reference for php's mysql reference

comment save report
category icon

Five common PHP database problems

in PHP added by goodphptutorials, on 11/8/2006 database problems databases mysql troubleshooting

Discover five common database problems that occur in PHP applications -- including database schema design, database access, and the business logic code that uses the database -- as well as their solutions.

comment save report
category icon

Complete Members System

in PHP added by goodphptutorials, on 2/12/2007 databases intermedia user management

Nearly every website allows you (the visitor) to become a member of the site you're visiting. Typically, one will register a desired username, and setup a password, then fill out a bit of information to stock a profile, like: location, interests, etc. and you're done. You can then access parts of the site that were once restricted, participate in forum discussions and cast your vote on polls - you get the idea. But how is that done? How do they distinguish between members? How can I do that with my site? Read on and you will learn how to allow visitors to register as members, and allow them to login/logout of your website.

comment save report
category icon

Image Databasing

in PHP added by goodphptutorials, on 13/5/2006 databases

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.

comment save report
category icon

How To: Code Your First Web App (Part 3)

in PHP added by goodphptutorials, on 25/8/2007 beginner tutorials database framework mysql user

By now you are probably waiting for the final part of this web app series so you can actually begin putting something together from what you've learned in Part 1 and Part 2. I won't disappoint you then. I wrote an example web app available for download at the end of this article.

comment save report
category icon

ADOdb: Making MySQL Efficient

in PHP added by goodphptutorials, on 4/12/2005 ADOdb active data objects databases query

Active Data Objects Data Base (ADOdb) is a set of libraries/classes that standardizes the PHP database functions.

comment save report
category icon

Back To Basics: MySQL Connect

in PHP added by Dale, on 6/10/2007 connect databases die error mysql

This tutorial will teach you, very simply how to connect to your database and show an error if it doesn't connect correctly.

comment save report
category icon

PHP Script Tips - Working with MySQL Database

in PHP added by goodphptutorials, on 7/9/2006 databases

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

comment save report
category icon

DSN and DSN-less connections

in PHP added by goodphptutorials, on 14/9/2006 databases

DSN stands for "Data Source Name". It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN.

comment save report
category icon

How to create a basic rating system

in PHP added by goodphptutorials, on 8/10/2007 beginner tutorials database rating review

In this tutorial I will show you how to create a basic and simple to use rating system. To make the script more simple and database independent we will use simple files to store rating information.

comment save report