Category Archives: PHP Lessons

What is the difference between MySql and MySqli? MySqli is the new and improved extension for MySql. The difference between MySql and MySqli is the way your write the code. For instance to connect to a database in MySql you would write the code something like this. [code]<?php $link = mysql_connect(‘localhost’, ‘mysql_user’, ‘mysql_password’); if (!$link) {     die(‘Could not connect: ‘ . mysql_error()); } echo ‘Connected successfully’; mysql_close($link); ?>[/code] Read More

If you want to Drop a table from a database with PHP MySqli you must make sure that the table is there in the first place. If you have not done so please see Create a New Table in a MySqli Database.  To drop a table use the following code. You must make sure of the following Read More

Connect to a Database Using PHP MySqli, you can follow these general steps: Choose a database management system (DBMS) to use with PHP, such as MySQL, PostgreSQL, or SQLite. Install the appropriate PHP extension for the chosen DBMS. Create a new database in the chosen DBMS and create the necessary tables and fields. Set up Read More

Insert Into Database Using PHP MySqli using the following procedures. You must first make sure that you have these steps set up before you proceed. You Created A Database You Granted Privileges to the database Created a config.php file to access the database Make sure you Connect to a Database before using this code. Prepared Read More

  To Create a new Table in a MySqli Database you will have to be sure of the following. You Created A Database You Granted Privileges to the database Created a config.php file to access the database If you have those 3 steps done you will now be able to create a new table in a Read More

In order to connect to a database you need to make a key file. Make a Config file to connect to MySql Database. This is a fairly simple process. You take the information that you assigned to a database when you granted privileges to it and make a  file and call it config.php. You can Read More

Grant Privileges to a Database in MySqli MySqli is a PHP extension used to connect and communicate with MySQL databases. One of the key features of MySqli is the ability to grant privileges to users for accessing databases. This feature allows the database administrator to have better control over who can access and modify the Read More

In order to Create a MySql Database in PHP in MySqli you will need to have the following set up before you proceed. Hosting plan A FTP or sFTP connection in order to upload files. The login to your cPanel in order to create a database and user privileges. Here is the code you will need Read More

If you’re a blogger or website owner using WordPress or the Genesis framework, you may be interested in displaying advertisements or additional content after the first post on your homepage. This can help increase engagement and revenue by providing readers with relevant content and advertising opportunities. Here’s how you can add advertisements or content after Read More

Optimizing Images With PHP Optimizing images is a big part of website development and optimization. For most webmasters I do not have to go into detail on why you should optimize your images. It was pretty standard, yet it was quite hard to achieve. As far as I know, even casino sites like https://www.daisyslots.com are Read More

Php Web Development Php web development in a nutshell is a company or developer that uses a computer language that is called php or “Hypertext Preprocessor”. This type of acronym is called a recursive acronym. However years ago it stood for “Personal Home Page”. Yet as the years evolved this computer language its capabilities became wider and Read More

PHP Variable In the last PHP Lesson we learned how to echo out a line of text in a browser in this lesson we will learn about a php variable. A variable in php stores information. In the example below we see that a variable starts with a $ sign and is followed by text. Read More

PHP for Beginners So are you looking for some PHP for beginners lessons? Well you have come to the right place. Recently I have been asked to do some of these tutorials because people are curious about how PHP works. I think it is a fascinating thing to learn and if you are curious here is a Read More