nawerreality.blogg.se

• PHP MYSQL CREATE DATABASE UTF8 ENCODED CODE

$this->designation=htmlspecialchars(strip_tags($this->designation)) $this->email=htmlspecialchars(strip_tags($this->email)) $this->name=htmlspecialchars(strip_tags($this->name)) $this->result = $this->db->query($sqlQuery)

$sqlQuery = "SELECT id, name, email, designation, created FROM ".

PHP MYSQL CREATE DATABASE UTF8 ENCODED CODE

Create employees.php with the following code in the project folder. $this->db = new mysqli('localhost','root','','apicruddb') Įcho "Database could not be connected: ". Create database.php with the following code in the project folder. Create api folder under the project folder.Ħ. Create a project folder named apicrudphp.ĥ. INSERT INTO `Employee` (`id`, `name`, `email`, `designation`, `created`) VALUES )ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 This tutorial will help you learn the way to develop REST API with PHP and MySQL from the basics and test the API using the postman app. You can develop REST API CRUD using PHP and MySQL easily.