ejemplo de código de api de php oop crud rest

Luego de de nuestra extensa compilación de información resolvimos este dilema que suelen tener algunos lectores. Te brindamos la respuesta y nuestro deseo es servirte de mucha ayuda.

Ejemplo 1: base de datos php oop crud

<?php

	class Customers
	
		private $servername ="localhost";
		private $username   ="root";
		private $password   ="";
		private $database="blog_database";public  $con;// Database Connection publicfunction __construct()
		
		    $this->con = new mysqli($this->servername, $this->username,$this->password,$this->database);if(mysqli_connect_error()) 
			 trigger_error("Failed to connect to MySQL: ". mysqli_connect_error());
		    else
			return $this->con;
		    
		

		// Insert customer data into customer tablepublicfunction insertData($post)
		
			$name = $this->con->real_escape_string($_POST['name']);
			$email = $this->con->real_escape_string($_POST['email']);
			$username = $this->con->real_escape_string($_POST['username']);
			$password = $this->con->real_escape_string(md5($_POST['password']));
			$query="INSERT INTO customers(name,email,username,password) VALUES('$name','$email','$username','$password')";
			$sql= $this->con->query($query);if($sql==true) 
			    header("Location:index.php?msg1=insert");
			else
			    echo "Registration failed try again!";
			
		

		// Fetch customer records for show listingpublicfunction displayData()
		
		    $query ="SELECT * FROM customers";
		    $result = $this->con->query($query);if($result->num_rows >0) 
		    $data= array();while($row= $result->fetch_assoc()) 
		           $data[]= $row;
		    
			 return $data;
		    else
			 echo "No found records";
		    
		

		// Fetch single data for edit from customer tablepublicfunction displyaRecordById($id)
		
		    $query ="SELECT * FROM customers WHERE id = '$id'";
		    $result = $this->con->query($query);if($result->num_rows >0) 
			$row= $result->fetch_assoc();return $row;
		    else
			echo "Record not found";
		    
		

		// Update customer data into customer tablepublicfunction updateRecord($postData)
		
		    $name = $this->con->real_escape_string($_POST['uname']);
		    $email = $this->con->real_escape_string($_POST['uemail']);
		    $username = $this->con->real_escape_string($_POST['upname']);
		    $id = $this->con->real_escape_string($_POST['id']);if(!empty($id)&&!empty($postData)) 
			$query ="UPDATE customers SET name = '$name', email = '$email', username = '$username' WHERE id = '$id'";
			$sql= $this->con->query($query);if($sql==true) 
			    header("Location:index.php?msg2=update");
			else
			    echo "Registration updated failed try again!";
			
		    
			
		


		// Delete customer data from customer tablepublicfunction deleteRecord($id)
		
		    $query ="DELETE FROM customers WHERE id = '$id'";
		    $sql= $this->con->query($query);if($sql==true) 
			header("Location:index.php?msg3=delete");
		else
			echo "Record does not delete try again";
		    
		

	
?>

Ejemplo 2: base de datos php oop crud

-- Table structure for table `customers`--CREATETABLE`customers`(`id`int(100)NOTNULL,`name`varchar(100)NOTNULL,`email`varchar(100)NOTNULL,`username`varchar(100)NOTNULL,`password`varchar(100)NOTNULL)ENGINE=InnoDBDEFAULTCHARSET=utf8mb4;

Comentarios y valoraciones de la guía

Acuérdate de que tienes la opción de decir .

---

---

Utiliza Nuestro Buscador