Daten aus dieser Datenbank art richtig abspeichern uns auslesen.

Wie lese ich hier einzelne Werte aus?

SELECT option_value
FROM option
WHERE option_name = 'siteurl'

SELECT option_value
FROM option

und wie speicher ich welche richtig ab?

UPDATE option
SET option_value = 'http://example.com/',
updated_time = CURRENT_TIMESTAMP()
WHERE option_name = 'siteurl'

und wie speicher ich welche richtig ab?

UPDATE option
SET option_value = 'http://example.com/',
updated_time = CURRENT_TIMESTAMP()
WHERE option_name = 'siteurl'

	<form action="?save=settings" method="post">
		<label for="inputSiteurl">Website URL: 
			<input type="url" id="inputSiteurl" name="siteurl" value="<?php echo $siteurl; ?>" required>
		</label><br>
		<label for="inputSitename">Website Name: 
			<input type="text" id="inputSitename" name="sitename" value="<?php echo $sitename; ?>" required>
		</label><br>
		<label for="inputSitedescription">Website Beschreibung: 
			<input type="text" id="inputSitedescription" name="sitedescription" value="<?php echo $sitedescription; ?>" max="255" required>
		</label><br>
		<label for="inputKeywordsmain">Hauptschlagwörter: 
			<input type="text" id="inputKeywordsmain" name="keywordsmain" value="<?php echo $keywordsmain; ?>" max="255" required>
		</label><br>
		<label for="inputAdminemail">Adminstrator E-Mail: 
			<input type="email" id="inputAdminemail" name="adminemail" value="<?php echo $adminemail; ?>" required>
		</label><br>
		<label for="inputCountry">Land: 
			<select id="inputCountry" name="country" required>
				<option <?php echo $country_germany_select ?> value="germany">Deutschland</option>
				<option <?php echo $country_austria_select ?> value="austria">Österreich</option>
				<option <?php echo $country_switzerland_select ?> value="switzerland">Schweiz</option>
				<option <?php echo $country_luxembourg_select ?> value="luxembourg">Luxemburg</option>
				<option <?php echo $country_lichtenstein_select ?> value="lichtenstein">Lichtenstein</option>
				<option <?php echo $country_unitedstates_select ?> value="unitedstates">Vereinigte Staaten</option>
				<option <?php echo $country_unitedkingdom_select ?> value="unitedkingdom">Vereinigtes Königreich</option>
				<option <?php echo $country_canada_select ?> value="canada">Kanada</option>
				<option <?php echo $country_australia_select ?> value="australia">Australien</option>
				<option <?php echo $country_newzealand_select ?> value="newzealand">Neuseeland</option>
				<option <?php echo $country_ireland_select ?> value="ireland">Irland</option>
			</select>
		</label><br>
		<label for="inputLanguage">Sprache: 
			<select id="inputLanguage" name="language" required>
				<option <?php echo $language_german_select ?> value="german">Deutsch</option>
				<option <?php echo $language_english_select ?> value="english">Englisch</option>
			</select>
		</label><br>
		<label for="inputRobots">Suchmaschienen Indexierung: 
			<select id="inputRobots" name="robots" required>
				<option <?php echo $robots_0_select; ?> value="0" selected>In Suchmaschienen nicht Indexieren</option>
				<option <?php echo $robots_1_select; ?> value="1">In Suchmaschienen Indexieren</option>
			</select>
		</label><br>
		<label for="inputAllowregister">Registrierung im Frontend
			<select for="inputAllowregister" name="allowregister" required>
				<option <?php echo $allowregister_0_select; ?> value="0">Registrieren nicht erlauben</option>
				<option <?php echo $allowregister_1_select; ?> value="1">Registrieren erlauben</option>
			</select>
		</label><br>
		
		<label for="inputBackenddesign">Backend Design: 
			<select id="inputBackenddesign" name="backenddesign" required>
				<?php
					$verzeichnis_design = "../backend/design/";
					if ( is_dir ( $verzeichnis_design )) {
						if ( $handle_design = opendir($verzeichnis_design) ) {
							while (($file_design = readdir($handle_design)) !== false) {
								if ($file_design !== '.' and $file_design !== '..') {
				?>
									<option <?php if($backenddesign == $file_design){ echo 'selected'; } ?> value="<?php echo $file_design; ?>"><?php echo $file_design; ?></option>
				<?php
								}
							}
							closedir($handle_design);
						}
					}
				?>
			</select>
		</label><br>
		
		<label for="inputFrontenddesign">Frontend Design: 
			<select id="inputFrontenddesign" name="frontenddesign" required>
				<?php
					$verzeichnis_frontenddesign = "../website/design/";
					if ( is_dir ( $verzeichnis_frontenddesign )) {
						if ( $handle_frontenddesign = opendir($verzeichnis_frontenddesign) ) {
							while (($file_frontenddesign = readdir($handle_frontenddesign)) !== false) {
								if ($file_frontenddesign !== '.' and $file_frontenddesign !== '..') {
				?>
									<option <?php if($frontenddesign == $file_frontenddesign){ echo 'selected'; } ?> value="<?php echo $file_frontenddesign; ?>"><?php echo $file_frontenddesign; ?></option>
				<?php
								}
							}
							closedir($handle_frontenddesign);
						}
					}
				?>
			</select>
		</label><br>
		
		<label for="inputFont">Schriftart: 
			<select id="inputFont" name="font" required>
				<?php
					$verzeichnis_font = "../include/fonts/";
					if ( is_dir ( $verzeichnis_font )) {
						if ( $handle_font = opendir($verzeichnis_font) ) {
							while (($file_font = readdir($handle_font)) !== false) {
								if ($file_font !== '.' and $file_font !== '..') {
				?>
									<option <?php if($font == $file_font){ echo 'selected'; } else { $nofont = 'selected'; } ?> value="<?php echo $file_font; ?>"><?php echo $file_font; ?></option>
				<?php
								}
							}
							closedir($handle_font);
						}
					}
				?>
				<option <?php echo $nofont; ?> value="none">Keine Schriftart</option>
			</select>
		</label><br>

		<label for="inputMaincolor">Hauptfarbe: 
			<input type="color" id="inputMaincolor" name="maincolor" value="<?php echo $maincolor; ?>" required>
		</label><br>
		
		<label for="inputMainfontcolor">Haupt Schriftfarbe: 
			<input type="color" id="inputMainfontcolor" name="mainfontcolor" value="<?php echo $mainfontcolor; ?>" required>
		</label><br>
		
		<label for="inputMainbackgroundcolor">Haupt Hintergrundfarbe: 
			<input type="color" id="inputMainbackgroundcolor" name="mainbackgroundcolor" value="<?php echo $mainbackgroundcolor; ?>" required>
		</label><br>
		
		<label for="inputMainhovercolor">Haupt hover Farbe: 
			<input type="color" id="inputMainhovercolor" name="mainhovercolor" value="<?php echo $mainhovercolor; ?>" required>
		</label><br>

		<label for="inputAuthor">Author Name/Copyright: 
			<input type="text" id="inputAuthor" name="author" value="<?php echo $author; ?>" required>
		</label><br>
		
		<lable for="inputMindestalter">Mindestalter: 
			<input type="number" id="inputMindestalter" name="mindestalter" value="<?php echo $mindestalter; ?>" required>
		</lable>
		
		<label for="inputMainrole">Standartrolle: 
			<select id="inputMainrole" name="mainrole" required>
				<option <?php echo $mainrole_user_select; ?> value="user">Benutzer</option>
				<option <?php echo $mainrole_member_select; ?> value="member">Mitglied</option>
				<?php if($user['role'] === 'adminstrator' || $setup == true) { ?>
					<option <?php echo $mainrole_supporter_select; ?> value="supporter">Supporter</option>
				<?php } ?>				
			</select>
		</label><br>
		
		<button type="submit">Speichern</button>
	</form><br>

$stmt = $mysqli->prepare(
    "UPDATE option
    SET option_value = ?,
    updated_at = CURRENT_TIMESTAMP()
    WHERE option_name = ?"
);

if (!$stmt) {
    printf("Error: %s\n", $mysqli->error);
}

$stmt = $mysqli->prepare(
    "UPDATE option
    SET option_value = ?,
    updated_at = CURRENT_TIMESTAMP()
    WHERE option_name = ?"
);
$stmt->bind_param("ss", $value, $name);
foreach ($options as $name => $old_value) {
    if (isset($_POST[$name]) && $_POST[$name] != $old_value) {
        $value = $_POST['name'];
        $stmt->execute();
    }
}
$stmt->close();