Dynamic dropdown menu using PHP and MySQL [closed]
تبليغسؤال
يرجى شرح بإيجاز لمإذا تشعر أنك ينبغي الإبلاغ عن هذا السؤال.
I`m trying to make a dynamic dropdown menu using PHP and MySQL. The menu should fetch the pages’name and number from the database. I’ve already looked up online but cannot find out why the code does not work.
<!DOCTYPE html>
<html>
<head>
<title>Bootstrap index</title>
<script src=”bootstrap-5.0.2-dist/js/bootstrap.js”></script>
<link rel=”stylesheet” type=”text/css” href=”bootstrap-5.0.2-dist/css/bootstrap.css”>
</head>
<body>
<div>
<form action=”buildBlock.php” method=”post”>
<fieldset>
<label>Password</label>
<input type=”password” name=”password”>
<select name=”blockType”>
<option value=”1″>head</option>
<option value=”2″>menu</option>
<option value=”3″>content1</option>
<option value=”4″>content2</option>
<option value=”5″>footer</option>
</select>
<label>Title</label>
<input type=”text” name=”title” maxlength=”45″>
<label>Content</label>
<textarea name=”content” rows=”10″ cols=”40″></textarea>
<select name=”pageID”>
<?php
$con = new PDO(‘mysql:host=localhost; dbname=test’, ‘root’, ”);
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $con->prepare(‘SELECT * FROM cmspages’);
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($result as $row){
?>
<option value=”<?php echo $result[“pageID”];?>”><?php echo $result[“pageName”];?></option>
<?php
}
?>
</select>
<button type=”submit”>submit</button>
</fieldset>
</form>
</div>
</body>
</html>
أضف إجابة