NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
PHP MySQL tutorial
37510
PHP MySQL tutorial
http://www.phpf1.com/tutorial/php-mysql-tutorial.html
As you know by the help of PHP you can create dynamic website content. The dynamic content doesn't necessary require a database, however in most cases you have/need one. All of the content management systems, blogs or only a simple form processor use database. In the PHP world the most commonly used database is MySQL. So in the next section I will focus on how to use PHP and MySQL to create dynamic content. In this tutorial I will focus only PHP MySQL usage basics, and I suppose you have already an installed and properly configured system supporting both PHP and MySQL.
PHP > Tips and Tutorials > Database-Related
Mar 17, 2008
PHP F1
send email to PHP F1
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark PHP MySQL tutorial: |
|||
Other links owned by this user
Using the greatest encrypton types available, this product is one of the most secure file-storing applications on the planet. Nobody ever knows what your filenames are, as they are encrypted using MD5, and then stored in the database. PHP does the rest when it comes time to re-download your uploaded file.
Category:
Nice PHP FAQ Script (Knowledge base Script) is a great tool for your website, to provide answers to your visitors most frequently asked questions. Our Nice FAQ Script (Knowledge base Script) reduces webmaster's (or site owner's) burden of replying to similar and repetitive queries
Category:
Personal finance manager is a simple tool for managing accounts and expenses. It was designed and written to be intutive and easy to use for home and small business users not familier with accounting principles like single or double entry accounting. PFM is a basic implementation of double entry accounting principles.
Category:
Your live customer support system is remotely hosted here on our servers , however you have exclusive control over your own system. You manage the operator accounts, services, customer chat sessions, logs, etc. Best of all it's free!
Category:
Ajax is a system that is comprised of a number of different technologies, and some of these include DOM, HTML, JavaScript, and DHTML. These technologies together are used to create an approach that will allow users to transform static web interfaces into those which are highly interactive. To fully understand the power of Ajax, you must be able to first understand how these various technologies work together. One of the most important factors in the success of Ajax is the XMLHttpRequest object. A few years ago, developers who didn't know XML were often not popular among their
Category:
Learn how to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database.
Category:
This tutorial we will show how to create images with PHP.
Requeriments: GD library must be installed in the server (probably it is installed).
Requeriments: GD library must be installed in the server (probably it is installed).
Category:
OK, this is my second tutorial for AJAX Freaks, so bear with me. Have you ever seen or wished you could have live data on your website? Have you got data stored in a database that UPDATEs reguarly? This tutorial will explain how you can achieve this effect using AJAX and PHP. As I mentioned in my first tutorial, this can be achieved in almost any server side scripting langauge, as long as you know how to make database queries in your desired langauge. I suggest that you know how to use the basic XMLHttpRequest object, if not then you might want to check out my first tutorial on introducing you to AJAX found here. You can find the entire
Category:
yuploader is a AJAX-PHP uploader script (support progress bar, and uploading handlers), without patching PHP.
Requirements
In order to use yuploader, users need a browser with Flash Plug-in version 8 or newer. Developer only need a server with pure PHP support
Requirements
In order to use yuploader, users need a browser with Flash Plug-in version 8 or newer. Developer only need a server with pure PHP support
Category:
Start a Video Upload (youtube clone) or Social Networking (myspace clone) or (Facebook Clone)
True White Label, Private, Simple to use, Your Branding, NO License Keys!!!
True White Label, Private, Simple to use, Your Branding, NO License Keys!!!
Category:
In the AJAX tutorial below we will demonstrate how a web page can be loaded 10 time faster using ajax.
This is the HTML page . It contains a simple HTML table,couple css rules and a link to a JavaScript:
This is the HTML page . It contains a simple HTML table,couple css rules and a link to a JavaScript:
Category:
Sunframework is based on PHP5 (OOP,MVC) and is designed to be fast and simple.
DB engines: ORM and Standard Database Object for most databases.
Supported engines: Dte, Smarty, Doctrine ORM, PHPMailer.
Full support for themes, Memcache, Validation and Sessions.
DB engines: ORM and Standard Database Object for most databases.
Supported engines: Dte, Smarty, Doctrine ORM, PHPMailer.
Full support for themes, Memcache, Validation and Sessions.
Category:
Learn how to create appearance picture animation using the shape transformation and mask. This is so attractive animation, and you can use it for flash banner, presentation.... To create this tutorial, you don't have to use action script code.
Category:
The class increases the timelimit for script-execution (if safe-mode is turned off), prevents a browser-timeout by sending pieces auf the progressbar to the browser and gives the user live-feedback on the progress of the running operation.
Category:
A user friendly video player with plenty of features. It’s easy to customize and it comes with the source code so you can learn how it’s been made.
Category:
Stand-alone installers with the widest platform support for professional developers.
Create stand-alone installers for any Windows 32-bit or 64-bit desktop or server platform, with complete customization of all installer actions and dialogs.
Create stand-alone installers for any Windows 32-bit or 64-bit desktop or server platform, with complete customization of all installer actions and dialogs.
Category:
This is a completely free and handy little script that requires no database. It can be used to generate any random number within a range that you define. The best use I have found is to use it for a "fake" useronline script to make a site look busier than it really is. Enjoy!
Category:
In this tutorial I will teach you how using dreamweaver you can create a site search. It is very simple, the main part is creating a database to store the information you will be searching. If you are having problems feel free to e-mail us, or post a message on the forum.
Category:
From personalizing Vim to productivity optimizations: Recipes to make life easier for experienced Vim users
Create, install, and use Vim scripts
Personalize your work-area
Optimize your Vim editor to be faster and more responsive.
Create, install, and use Vim scripts
Personalize your work-area
Optimize your Vim editor to be faster and more responsive.
Category:
One of the newest things to take the web development industry by storm is the use of AJAX (Asynchronous Javascript And XML), which uses the XMLHttpRequest object. The beauty of this new technology is it allows designers and developers to add interactive or live parts to their website without have to reload the page. This can include live information such as stock market values (the FTSE 100 is a great example as its value can change as quickly as every minute) and the number of posts on a forum. All these values could change on a page without having to refresh to page every minute.
This tutorial will hopefully give you some idea on how to use the XMLHttpRequest object in your website apps to improve user interactivity and the general functionality of your website. It is advised that you have some background knowledge of JavaScript, and for this example, PHP (or some other server-side scripting language such as Perl or ASP).
Below is the entire code of the script, so you can see what it will look like at the end. I will go through each part in turn through the tutorial:
This tutorial will hopefully give you some idea on how to use the XMLHttpRequest object in your website apps to improve user interactivity and the general functionality of your website. It is advised that you have some background knowledge of JavaScript, and for this example, PHP (or some other server-side scripting language such as Perl or ASP).
Below is the entire code of the script, so you can see what it will look like at the end. I will go through each part in turn through the tutorial:
Category:
Other links at PHP > Tips and Tutorials > Database-Related
1. SQLite
SQLite is an embedded database library that implements a large subset of the SQL 92 standard. Its claim to fame is the combination of both the database engine and the interface (to said engine) within a single library, as well as the ability to store all the data in a single file. I terms of functionality SQLite resides somewhere between MySQL and PostgreSQL. However, when it comes to performance, SQLite is often 2-3 times faster (or even more). This is thanks to a highly tuned internal architecture, and the elimination of server-to-clientand client-to-server communication.
Category:
Learn how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.
Category:
Sometimes if you want to install a new PHP CMS, blog, wiki, ... you first need to create the necessary database. The installation packages contains the sql file you need to execute, however if you don't have any web based management tool then it can take a bit more time. In this article we will create a simple PHP solution which can execute any sql script on your MySQL database.
Category:
While the word "integrity" connotes "wholeness", it's important to understand what it means specifically in the case of relational database design. Failure to ensure data integrity can result in the database returning incorrect results, or in data becoming unretrievable. This is true of all relational databases, not just MySQL. Fortunately, the principles of data integrity are not difficult to understand. How difficult they are to implement in MySQL and PHP will depend in large degree on how many tables and relationships the database has. This article will start with an overview of relational concepts, and then illustrate each of the concepts with simple examples.
Category:
Main Category
185
2034
801
286
174
1803
1129
909
1161
7393
70
905
59
2200
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19263
Categories: 1275
Registered Users: 734
Mailing List Subscribers: 2043
Unique Outgoing Hits: 228320
Pagerank Statistics
PHP News