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 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. Then add this line of code but replace "databasename" with the name of your database:

Fetch MySQL Row - Fetch a specific MySQL row and display it in a simple table

This week we are going to work with a common use of PHP and MySQL, fetching results from MySQL and displaying them We will first take a look at the code and then explain it in depth.

PHP Script Tips - Working with MySQL Database

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. Topics included in this collections: 1. How To Install MySQL? 2. How To Use MySQL Command Line Interface? 3. What Do You Need to Connect PHP to MySQL? 4. How To Connect to MySQ

Dumping mySQL Tables to HTML all Explained in This Detailed Tutorial

In this tutorial we are going to expose basic mySQL queries, and how they can be used to print all data from a mySQL table into an HTML table. This might be useful if you want to display all the data for review reasons. A couple of things to take into consideration however when following this tutorial; For one thing, this tutorial will assume that the mySQL table we will print does not contain a lot of records. Obviously, if the table contains thousands of records, the script will take a long

Large 3 Page Tutorial on Basic mySQL Queries And PHP

With the development and availability of open source and powerful tools like PHP and mySQL, combining the power of HTML and dynamic data has never been easier. Now with just a simple learning curve, anyone can get started in creating a truly dynamic web site, one that interacts with its users in every possible way. This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial,

MySQL Basics - Simple MySQL integration for your website with PHP

In this tutorial I will tell you how to use the basics of mySQL Databases and how to use them with PHP. What will you learn: - Connect to the mySQL Database - Select the mySQL Database - Query the mySQL Database - Display the mySQL results I am guessing you know what the basics are and what a mySQL Database is and how to set the DB up and add tables in PHPmyadmin. If you don't know what the mySQL tables are then here is a quick and brief explanation. Tables are like fields which stor

mySQL Databasing

This tutorial will give you a basic guide through connecting, adding, modifing and deleting from a mySQL database.If at any time you feel you don't quite follow or require some help, then please feel free to get in touch using our forums!.

Basic mySQL Queries And PHP

With the development and availability of open source and powerful tools like PHP and mySQL, combining the power of HTML and dynamic data has never been easier. Now with just a simple learning curve, anyone can get started in creating a truly dynamic web site, one that interacts with its users in every possible way. This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial,

Checkbox Deletion

Ever used one of those snazzy PM systems where you can check a box (or more than one) and then press a button, then the messages will be deleted? First of all, you'll need a loop echoing database records (in this case, private messages) - and they'll need to have their unique ID with them.

Alternating Row Colors From mysql results and/or array values

Theres two different ways this can be done. The first is by getting results from a mysql query, the second is going through the values of an array. I'll go over both. First the full files (ill break it up into two files, one using mysql, and one using an array).

Create An Install File For Your PHP Scripts

Alright, in this tutorial I'm going to teach you how to make an install file for your PHP scripts that include mysql databases. This is only a basic way to do it, and is intended for people who have not done this before. It can be modified to make a more user friendly install, and I will post a tutorial on that later. Step 1: Functions if the install button is pressed: Ok, first we are going to write the php code that will execute once the install button is pressed. We will include a connect

Non ASCII Characters with MySQL

MySQL can store non ASCII characters in database in a number of encodings, MySQL call them character sets:

MySQLi Timeout

If you're running on a hosting plan where your database is stored on a server other than your own, you might be subject to your database being inaccessible. In some cases, it will just report that it couldn't connect. In other cases, it will wait, wait and wait some more, making you think your web server is offline. This can be bad for a number of reasons. First being that it makes it look like your site is offline or non-existant. The second being that you have no idea what is causing the pr

MySQL with PHP5

If you're moving to PHP5 or haven't really explored the new features of PHP5, you might be interested to know that PHP5 contains a whole new function set to communicate with MySQL. You have a choice of using mySQL or mySQLi. MySQL, is the same set of functions that you used in PHP4. They work entirely the same and have the same results. MySQLi is an improved extention set of functions. I'll be focusing on them as they bring some pretty nifty features that were previously missing.

Alternating table row colors in a MySQL query results page

Many of website use this script to alternate their table row color that selected from mysql database, very useful and cool. In this tutorial create 1 file 1. alternating_color.php Step 1. Create table "test_mysql in database "test". 2. Create file alternating_color.php.

Update multiple rows in MySQL with this detailed tutorial!

This tutorial will show you how to update multiple rows with one time submittion. Easy and simple code teach you step by step. In this tutorial create 1 file 1. update_multiple.php Step 1. Create table "test_mysql" in database "test". 2. Create file update_multiple.php.

Delete multiple rows from mysql with checkboxes in a form

Delete multiple rows from mysql with checkbox. In this tutorial create 1 file 1. delete_multiple.php Step 1. Create table"test_mysql" in database "test". 2. Create file delete_multiple.php.

Printing a MySQL Table in a Dynamic HTML Table with PHP

Have you every wanted to print out all the data in a MySQL table to a clean looking dynamic HTML table? It is a pretty simple process. In this tutorial we will create a function that can be reused anywhere in your site to dynamicly print the contents of a MySQL table in a clean looking HTML table. Here is the breakdown: 1. Construct a query to run on the database. 2. Run the query and store the result. 3. Find the number of fields in the returned table. 4. Construct the html table with the

PHP and MySQL Part 2 - Setting up the database!

Before we go any further the first thing we need to do is create a database so we know what to build our php scripts around. For this tutorial we are going to base our examples on an address book application. Really database construction is a whole tutorial on it own, If you are planning to create a fairly complex site your going to need a database to match. Here is a list of mysql relational database pages. 1. Mysql Relational Database training couse 2. Official MYSQL Relational datab

Accessing a Database Using PHP/MySQL - How to make a mysql connection and query

When you start using PHP more and more, you will start to notice that storing usernames and passwords in files etc is not an easy or quick thing to do, you need to open the file, and read the file.. okay.. thats easy enough.. but what about selecting datafrom within the file. Now thats a different story. The idea is that it isn't very easy, and if you do find a way to do it.. its probably pretty damn CPU intensive. Cue Databases Databases come in different shapes and sizes, but when y