How to Check if a Record Exists in SQL Database Table with PHP

Last Updated on Saturday, 12 January 2013 12:01 Written by Richi González Saturday, 12 January 2013 12:00

Hello,

Have you been in a situation where you need to check if either a phone number or a user, for example, exists in your database? When I didn’t know how to do that, I looked through several articles looking for the best and most efficient way of doing it until I found this one.

1. Let’s say we have a table called ‘users’ and it has two columns: id, name. This is our table:

How to Efficiently Count Records of an SQL Table with PHP

Last Updated on Friday, 4 January 2013 12:00 Written by Richi González Friday, 4 January 2013 12:00

Hello,

For the last website I made, I created a really flexible and friendly administration panel where there were a lot of statistics to analyze how the website was performing. I came across different ways of counting records in a table, yet stuck with this one, the most efficient:

The query is really simple, we will use SELECT COUNT(1), then mysql_fetch_row() that count. The code would look like this:

How to Optimize a MySQL Database in cPanel

Last Updated on Sunday, 20 November 2011 12:43 Written by Arian Jahansouz Friday, 23 July 2010 01:03

Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Add Databases and Users Using MySQL Wizard in cPanel
3. How to Allow Remote Access to a MySQL Database in cPanel
4. How to Change the Password of a MySQL User in the cPanel

This article will give you a step by step guide on how to optimize a MySQL database’s tables in the cPanel.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click phpMyAdmin