Hello to all, welcome to therichpost.com. In this post, I am showing PDO select query with case statement. First time I am showing mysql pdo case statements. Here is the working code for PDO select query with case statement: <?php$servername = “localhost”;$username = “root”;$password = “root”; try { $conn = new PDO(“mysql:host=$servername;dbname=user”, $username, $password); //…

Hello to all, welcome to therichpost.com. In this post, I will tell you, How to Use StdClass Object In PDO? PDO means PHP Data Object. PDO is more secure and it is opps based. In this post, I will use php StdClass in pdo query with creating custom StdClass properties. stdClass is PHP feature. With…

Hello to all, welcome to therichpost.com. In this post, I am showing mysql data in table format using pdo. Table format will be same like mysql. This code is very interesting and will show all the data with column names and data structure as same as mysql table structure. Here is the working code for…

Hello to all, welcome to therichpost.com. In this post, I will tell you, How to make like query in pdo mysql? PDO means PHP Data Object. PDO is more secure and it is opps based. Here is the working like query in pdo mysql and you can do like this query: <?php //You can define…

Hello to all, welcome to therichpost.com. In this post, I will tell you, How to Insert data in mysql using pdo? PDO means PHP Data Object. PDO is more secure and it is opps based. Here is the example code for Insert query example in mysql using pdo: To connect with mysql with pdo, you…

Hello to all, welcome to therichpost.com. In this post, I will tell you, How to connect mysql database using pdo? PDO means PHP Data Object. PDO is more secure and it is opps based. Here is the example code for connect mysql database using pdo: define(‘DB_SERVER’, ‘localhost’); define(‘DB_USERNAME’, ‘root’); define(‘DB_PASSWORD’, ‘root’); define(‘DB_DATABASE’, ‘testdatabse’); class Connection{…