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

browse by tag: database

sort by

newest, oldest, most popular


category icon

Using Oracle Forms

in PHP added by webdotdev, on 2/4/2007 databases form forms oracle using

Oracle forms, is a component of the Oracle SQL database. The Oracle technology is to design and build enterprise application in a quick way and efficiently.

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

PHP/MySQL Paging System

in PHP added by AKnife, on 18/5/2007 class database databases mysql object oo paging

A simple class with just a few easy to use functions makes PHP/MySQL paging easier than ever before

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

How to efficiently paginate database results

in PHP added by quipo, on 1/7/2007 PEAR advanced tutorials database pager

PEAR::Pager was written with the purpose of paginating arrays. While you can fetch all the records from a database, store them into an array and pass it to Pager, this method isn't particularly efficient. If you have large resultsets, it isn't efficient at all. There's a better solution: please welcome Pager_Wrapper.

comment save report
category icon

Save bandwidth with PHProxy and ip2nation

in PHP added by finalwebsites, on 8/7/2007 advanced tutorials database proxy

If your website becomes a little busy the websites bandwidth becomes very valuable. With the proxy script PHProxy and the data from ip2nation it's very easy to block visitors and safe this way used bandwidth from countries which are not from your target group. In this tutorial you will learn how to add the required code to your proxy website.

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

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

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

In Part 1 of How To: Code Your First Web App, I covered the basics of setting up a MySQL database, connecting to it with PHP and then I introduced a few functions to create and manage users. At the end, I briefly went into setting up the header file which will be used with every file created from here on out. The next step is creating the main files that actually do things.

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

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

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
category icon

PHP MySQL By Example

in PHP added by goodphptutorials, on 19/10/2007 database databases mysql

PHP and MySQL are two different languages that work hand in hand very well. PHP is an excellent and versatile programming language with thousands of examples and applications while MySQL is one of the world's best solution when it comes to storing and managing your data. Learn by examples how to manipulate your database using PHP

comment save report
category icon

What is new in PHP 5.3 - part 3: mysqlnd

in PHP added by goodphptutorials, on 18/11/2007 database news php5

In the first two parts of this series I wrote about namaspaces and late static binding. In this part I will cover mysqlnd (MySQL native driver for PHP), which is also a really cool feature of PHP 5.3. This a replacement library (not an extension) for libmysql (MySQL Client Library) offering a lot of advantage over it.

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

Uploading Image Files with PHP

in PHP added by bs0d, on 9/12/2007 beginner tutorials database file handling mysql upload files

This article will guide you through step-by-step to learn how to upload and manage files using PHP.

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

Using Stored Procedures & MySQLI in PHP 5

in PHP added by rvdavid, on 11/12/2007 beginner tutorials database mysql oo programming php5

For the occasions that you want to use a stored procedure you've written in MySQL 5 through PHP , the semantic tool to use is PHP's built in mysqli objects/package.

comment save report
category icon

Display how many visitors online

in PHP added by ineedtutorials, on 3/1/2008 beginner tutorials database general oo programming php5

Ever wonderd how to display how many visitors you have online. In this tutorial i will show you an easy but effective way to display the amount of online visitor’s.

comment save report
category icon

Database design fundamentals (PHP, MySQL, SQL)

in PHP added by woork, on 7/1/2008 database how-to mysql sql

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. Very useful for web developers.

comment save report
category icon

Using PHP To Backup MySQL Database

in PHP added by mahmoudcasey, on 12/1/2008 backup database mysql sql

in this tutorial you will learn how to do a backupfile like (back.sql) of one of your database tables or all the database

comment save report
category icon

LAMP performance for dummies

in PHP added by goodphptutorials, on 15/1/2008 advanced tutorials blog caching database mysql performance

I've spent the last six months combing Google for 'slow mysql' results. It was enlightening. Now in the spirit of giving back to the community I give you:

comment save report
category icon

Complete advanced login member system

in PHP added by ineedtutorials, on 17/1/2008 advanced tutorials content management database login mysql security

This tutorial will show you how to create an advanced member login system with PHP, users can register, change password, email activation is included.

comment save report
category icon

Easy as Pie - Working with a Database

in PHP added by goodphptutorials, on 20/1/2008 beginner tutorials database mysql

This post is the third in a continuing series of DIY tutorials, which aims to make things as simple as possible. 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.

comment save report
category icon

Using prototype.js to add record into database with ajax

in PHP added by woork, on 14/2/2008 AJAX Prototype database mysql

This tutorial explains how to use prototype.js framework to enable a simple ajax request which add a new record (an user name) into a database table using PHP like server side language.

comment save report
category icon

Fuzzy Searching in PHP

in PHP added by porteightyeight, on 8/3/2008 AI advanced database search sql

This tutorial discusses creating an advanced fuzzy search engine using PHP and a database. The tutorial uses the example of a wiki application, but the concepts can easily be applied to other applications in different languages.

comment save report