How to fix PHPMyAdmin error, incorrect format parameter that appeared while importing a database?

First of all, we have to see some basic settings which are situated in php.ini. whenever we upload a database…

Read more »

PHP Tutorial for Beginners

PHP FRONT TO BACK **What is PHP?:- PHP: Hypertext Preprocessor(Recursive Acronym)Server Side Programming/Scripting LanguageCan be embedded directly within HTML (<?php?>)Files…

Read more »

How to fetch data in excel or generate excel file in PHP

File structure for this tutorial : config.php (database connection file) index.php (For fetching data ) genrate-excel.php (For genrating excel file…

Read more »

Password Hashing in PHP

Functions for hashing password password_hash() password_verify() password_hash() – Syntax: [code language=”php”] string password_hash(string $password , integer $algo [, array $options…

Read more »

How to delete records?

1) Write the delete statement: [code language=”php”] $sql = "DELETE FROM users WHERE id=:id"; [/code] 2) Prepare the query: [code…

Read more »

How to use PDO to update the database?

1) Write the regular update statement and again, instead of values, assign the named placeholders. For example: [code language=”php”] $sql…

Read more »

How to use PDO to read data from the database?

1) Write the regular select statement and again, instead of values, put named placeholders. For example: [code language=”php”] $sql =…

Read more »

How to use PDO to insert data into the database?

The SQL code for the users table: [code language=”sql”] CREATE TABLE IF NOT EXISTS users (id int(11) NOT NULL AUTO_INCREMENT,…

Read more »

PDO – PHP database extension

PDO – PHP database extension PDO (PHP Data Objects) is a PHP extension through which we can access and work…

Read more »

TURN OFF DISPLAY ERROR IN PHP

Method 1 & 2 & 3 https:///…-standards-error-fix Method 4 error_reporting(0); ini_set(‘display_errors’, ‘0’);     # don’t show any errors… error_reporting(E_ALL…

Read more »