PHP Database Related Tips and Tutorials, Scripts resource, functions |
|
|
|
|
Database Related tutorials
|
|---|
 Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data in order for the customer to perform the check - the customer's personal login details; and the customer's purchased items.
| | Hits:402 Rate: 5.0(out of 5) Vote:1 Submit Date :2006-10-06
Rate It | Error | Review |
|
| | | |
|---|
| Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.
| | Hits:253 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-09-25
Rate It | Error | Review |
|
| | | |
|---|
| This code shows you how to convert a image stored in the database back to a image and show it in a html page
| | Hits:170 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-04-02
Rate It | Error | Review |
|
| | | |
|---|
 This tutorial will show you how to take data that is stored in your mySQL database and easily turn it into XML. From there you can use the XML however you wish. This is useful for blogs, shoutboxes, guestbooks, or even larger things such as back-end CMS (content management systems) for your site or sites. While writing this tutorial I am making the assumption that if you are looking at this tutorial then you already have a decent grasp of some of the basics of PHP and also that you know basic XML syntax rules. I will not show you how to setup your database in this tutorial, nor will I go over every single PHP function that is used. Resources to check out are PHP: Introduction and PHP: mySQL With that said...
| | Hits:131 Rate: 1.0(out of 5) Vote:1 Submit Date :2007-01-08
Rate It | Error | Review |
|
| | | |
|---|
 Create, insert, update, delete, count and select rows in a database.
| | Hits:122 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-02-09
Rate It | Error | Review |
|
| | | |
|---|
| A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.
| | Hits:104 Rate: 0.0(out of 5) Vote:0 Submit Date :2006-12-13
Rate It | Error | Review |
|
| | | |
|---|
| This tutorial will teach you how to connect to a MySQL database through PHP.
| | Hits:101 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-06-06
Rate It | Error | Review |
|
| | | |
|---|
| This tutorial should do two things. In the first part, I will guide you around installing PHP and MySQL, and preparing the database we will use later. We will also install a tool for writing PHP.
Then we will write a small program to query the database and display the records in a grid.
| | Hits:91 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
| | | |
|---|
| So you want to create a guestbook but you don't have a database like MySQL at your disposal? Then this tutorial might come in handy. The things you'll need are Flash, a PHP script and the XML file that will hold your data.
| | Hits:73 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
| | | |
|---|
| If you are looking at this tutorial then you probably have a good idea in your head about what XML is and what you can do with it. However, for those of you that stumbled across this tutorial on accident and are interested in learning more, I will briefly explain what XML is and what it is used for. XML stands for eXtensible Markup Language and is used primarily for data storage and organization. It is useful for many things but the main thing I like about it is that there are no predefined tags; the author of the code completely creates the tags as he goes along. A sample xml code could look like this:
| | Hits:66 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
| | | |
|
|---|
| This tutorial will teach you how to connect to a MySQL database through PHP.
| | Hits:101 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-06-06
Rate It | Error | Review |
|
|
|---|
| This code shows you how to convert a image stored in the database back to a image and show it in a html page
| | Hits:170 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-04-02
Rate It | Error | Review |
|
|
|---|
| Create, insert, update, delete, count and select rows in a database.
| | Hits:122 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-02-09
Rate It | Error | Review |
|
|
|---|
| This tutorial will show you how to create and query a database using SQL and the mySQL command terminal. If you don't currently have mySQL installed head over to www.mysql.com and go grab yourself a copy after all its totally free!! With mySQL installed on your system you are good to go and create your first database.
| | Hits:45 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
|---|
| If you are looking at this tutorial then you probably have a good idea in your head about what XML is and what you can do with it. However, for those of you that stumbled across this tutorial on accident and are interested in learning more, I will briefly explain what XML is and what it is used for. XML stands for eXtensible Markup Language and is used primarily for data storage and organization. It is useful for many things but the main thing I like about it is that there are no predefined tags; the author of the code completely creates the tags as he goes along. A sample xml code could look like this:
| | Hits:66 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
|---|
| This tutorial is a continuation of the previous XML tutorial I have written. Because I have already written some background information (very little) I will not add that into this tutorial in order to save space and time. The other tutorial can be found at this link.
| | Hits:46 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
|---|
| So you want to create a guestbook but you don't have a database like MySQL at your disposal? Then this tutorial might come in handy. The things you'll need are Flash, a PHP script and the XML file that will hold your data.
| | Hits:73 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
|---|
| This tutorial will show you how to take data that is stored in your mySQL database and easily turn it into XML. From there you can use the XML however you wish. This is useful for blogs, shoutboxes, guestbooks, or even larger things such as back-end CMS (content management systems) for your site or sites. While writing this tutorial I am making the assumption that if you are looking at this tutorial then you already have a decent grasp of some of the basics of PHP and also that you know basic XML syntax rules. I will not show you how to setup your database in this tutorial, nor will I go over every single PHP function that is used. Resources to check out are PHP: Introduction and PHP: mySQL With that said...
| | Hits:131 Rate: 1.0(out of 5) Vote:1 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
|---|
| This tutorial should do two things. In the first part, I will guide you around installing PHP and MySQL, and preparing the database we will use later. We will also install a tool for writing PHP.
Then we will write a small program to query the database and display the records in a grid.
| | Hits:91 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
|---|
| 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. could cause irreparable damage to the data contained in your database. It's better for you to be prepared, and this tutorial will provide you with the information you need to protect your data!
There are two ways of backing up your data. You can use a program such as phpMyAdmin and use a graphical web-based interface to back up your database, or you can use a slightly more ancient command-line prompt. I will explain how to use the command line prompt method because the phpMyAdmin method times out when backing up large databases. Also, while the command line method is a bit more complicated, it does, in my view, provide you with greater control over your data.
| | Hits:0 Rate: 0.0(out of 5) Vote:0 Submit Date :2007-01-08
Rate It | Error | Review |
|
|
WebmastersHome.com
Discussion about programming, SEO, WebHosting and more! |
|
Pages : 1 2 |
|
