A simple CRUD API test with mysql implemented in php

mysqltest.php

<?php
	header("Content-Type:application/json");

	$dbhost = "DB_HOST";
	$dbuser = "DB_USER";
	$dbpass = "PASSWORD";
	$db = "TABLE";

	$conn = new mysqli($dbhost, $dbuser, $dbpass, $db);

	// $conn = mysqli_connect($dbhost,$dbuser, $dbpass, $db);

	if($conn->connect_errno) {
		echo "Failed to connect to MySQL: ".$conn->connect_error;
		exit();
	}


	/* MYSQL SELECT ALL EXAMPLE */
	// $stm = "SELECT * FROM users;";
	// $result = $conn->query($stm);
	// $rows = $result->fetch_all(MYSQLI_ASSOC);
	// // $rows = $result->fetch_assoc();
	// $json = json_encode($rows);
	// echo $json;

	/* MYSQL SELECT SINGLE - PREPARED STATEMENT */
	$name = "grateful";
	$stm = $conn->prepare("SELECT name, password FROM users WHERE name = ?");
	$stm->bind_param("s", $name);
	$stm->execute();
	// $stm->bind_result($result[0],);
	$result = $stm->get_result();
	$result = $result->fetch_all(MYSQLI_ASSOC);
	echo json_encode($result);
	$stm->close();

	/* MYSQL INSERT - PREPARED STATEMENT */
	// $val = array($_POST["name"], $_POST["email"], $_POST["password"]);
	// $val = array('Grateful', '[email protected]', 'p@33w0rd123');
	// $stm = $conn->prepare("INSERT INTO users (name, email, password) VALUES (?, ?, ?)");
	// $stm->bind_param("sss", $val[0], $val[1], $val[2]);
	// $stm->execute();
	// if($stm->affected_rows > 0) {
	// 	$result = array(
	// 		"success" => true,
	// 		"msg" => "Data inserted",
	// 		"id" => $stm->insert_id
	// 	);
	// 	echo json_encode($result);
	// } else {
	// 	$result = array(
	// 		"success" => false,
	// 		"msg" => "Data not inserted",
	// 		"id" => null
	// 	);
	// 	echo json_encode($result);
	// }
	// $stm->close();

	/* MYSQL UPDATE ONE - PREPARED STATEMENT */
	// $val = array('p@33w0rd321', 'Edwin');
	// $stm = $conn->prepare("UPDATE users SET password = ? WHERE name = ?");
	// $stm->bind_param("ss", $val[0], $val[1]);
	// $stm->execute();
	// if($stm->affected_rows > 0) {
	// 	$result = array(
	// 		"success" => true,
	// 		"msg" => "Data updated",
	// 		"id" => $stm->id
	// 	);
	// 	echo json_encode($result);
	// } else {
	// 	$result = array(
	// 		"success" => false,
	// 		"msg" => "Data not updated",
	// 		"id" => null
	// 	);
	// 	echo json_encode($result);
	// }
	// $stm->close();

	/* MYSQL DELETE ONE - PREPARED STATEMENT */
	// $val = 13;
	// $stm = $conn->prepare("DELETE FROM users WHERE id = ?");
	// $stm->bind_param("s", $val);
	// $stm->execute();
	// if($stm->affected_rows > 0) {
	// 	$result = array(
	// 		"success" => true,
	// 		"msg" => "Data deleted",
	// 		"id" => $stm->id
	// 	);
	// 	echo json_encode($result);
	// } else {
	// 	$result = array(
	// 		"success" => false,
	// 		"msg" => "Data not deleted",
	// 		"id" => null
	// 	);
	// 	echo json_encode($result);
	// }
	// $stm->close();

	
	// mysqli_free_result($result);
	mysqli_close($conn);
?>