NETTİM
← Kod Sonuçlarına Dön
PHP MariaDB SQL sorguları API örnekleri Form işlemleri Lisans: GPL

PHP — edit.php

PHP MariaDB entegrasyonlu — SQL sorguları, API örnekleri, Form işlemleri. SQL sorgusu içerir.
edit.php • PHP
<?php
if (!isset($_GET["id"])) {
    exit();
}

$id = $_GET["id"];
include_once "database.php";
$statement = $database->prepare("SELECT * FROM person WHERE id = ?;");
$statement->execute([$id]);
$person = $statement->fetch(PDO::FETCH_OBJ);
if ($person === false) {
    #not found
    echo "Person not found!";
    exit();
}

#If the person exists, this code is executed
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Edit person</title>
</head>
<body>
	<form method="post" action="update.php">
		<!-- Put the id hidden in the form so we can use it later -->
		<input type="hidden" name="id" value="<?php echo $person->id; ?>">

		<label for="nombre">Name:</label>
		<br>
		<input value="<?php echo $person->first_name ?>" name="first_name" required type="text" id="first_name" placeholder="First name">
		<br><br>
		<label for="last_name">Last name:</label>
		<br>
		<input value="<?php echo $person->last_name ?>" name="last_name" required type="text" id="last_name" placeholder="Last name">
		<br><br>
		<label for="gender">Gender</label>
		<select name="gender" required name="gender" id="gender">
			<!--
			Para seleccionar una opción con defecto, se debe poner el atributo selected.
			Usamos el operador ternario para que, si es esa opción, marquemos la opción seleccionada
			 -->
			<option value="">--Please select--</option>
			<option <?php echo $person->gender === 'M' ? "selected='selected'" : "" ?> value="M">Male</option>
			<option <?php echo $person->gender === 'F' ? "selected='selected'" : "" ?> value="F">Female</option>
		</select>
		<br><br><input type="submit" value="Save">
	</form>
</body>
</html>

Tespit Edilen SQL Sorguları

SELECT * FROM person WHERE id = ?

Benzer Kod Örnekleri

PHP — HelloWorldTest.php
PHP • SQL sorguları
PHP — HelloWorld.php
PHP • SQL sorguları
PHP: Constants - Manual
PHP • SQL sorguları
PHP — delete.php
PHP • SQL sorguları