php中select标签如何显示数据库提交出来数据,php - 如何解决从PHP中的select标记检索数据的问题 - SO中文参考 - www.soinside.com...

我花了几个小时来搜索是否有人遇到类似问题，但似乎没有。我正在使用一个选择标签来创建选项，我应该在数据库中的哪个表中存储信息。通常它可以正常工作，但是这次它拒绝工作。

Select DB :

Training

Wallpaper

Community

Event

BeforeAndAfter

这是如何定义它！if (isset($_POST['table2'])) {

$sql = "SELECT id FROM " . $_POST['table2'];

$lastID = 0;

$firstID = 1;

$first_cnt = 0;

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while ($row = $result->fetch_assoc()) {

$lastID = $row['id'];

if ($first_cnt == 0) {

$firstID = $row['id'];

$first_cnt++;

}

}

}

//End of get Last ID

//Delete Functions --

for ($x = $lastID; $x >= $firstID; $x--) {

$var1 = "Del" . $x;

echo $var1 . "
";

if (isset($_POST[$var1])) {

echo "----";

$sql = "DELETE FROM " . $_POST['table2'] . " WHERE id=" . $x;

if ($conn->query($sql) === TRUE) {

echo "Record deleted successfully";

} else {

echo "Error deleting record: " . $conn->error;

}

}

}

}

这是即时消息用来处理的代码。我尝试了不同的方式(可能有30种不同的方式)，但是我不知道为什么PHP总是将select返回为NOT SET。有什么想法吗？

这是完整的代码，分为两部分：1 /<?php

$servername = "localhost";

$username = "root";

$password = "";

$db = "gallery";

$printRes = "";

// Create connection

$conn = new mysqli($servername, $username, $password,$db);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Delete BLOCK

if(isset($_POST['but_upload'])){

$name = $_FILES['file']['name'];

$target_dir = "upload/";

$target_file = $target_dir . basename($_FILES["file"]["name"]);

// Select file type

$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

// Valid file extensions

$extensions_arr = array("jpg","jpeg","png","gif");

$tbl = $_POST['table'];

//Get last ID

$sql = "SELECT id FROM ".$_POST['table'];

$lastID = 0;

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

$lastID = $row['id'];

}

}

//End of get Last ID

// Check extension

if( in_array($imageFileType,$extensions_arr) ){

// Insert record

$lastID++;

$query = "INSERT into ".$tbl."(id,Photo)

VALUES(".$lastID.",'".$name."')";

if ($conn->query($query) === TRUE) {

$printRes="New record created successfully";

} else {

$printRes= "Error: " . $query . "
" . $conn->error;

}

// Upload file

move_uploaded_file($_FILES['file']['tmp_name'],$target_dir.$name);

}

}

function ShowInfo()

{

$showP = "";

if(isset($_POST['ShowInfo']))

{

$servername = "localhost";

$username = "root";

$password = "";

$db = "gallery";

$bname = "Del";

$conn = new mysqli($servername, $username, $password,$db);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT id,Photo FROM ".$_POST['table2'];

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

$showP .= "

'".$row['id']."'

'".$row['Photo']."'

";

}

} else {

$showP="";

}

}

if(isset($_POST['ResetData']))

{$showP="";}

echo $showP ;

}

$conn->close();

?>

and 2/

function Del()

{

$servername = "localhost";

$username = "root";

$password = "";

$db = "gallery";

$printRes = "";

// Create connection

$conn = new mysqli($servername, $username, $password,$db);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Delete BLOCK

//Get last ID

if(isset($_POST['table2']))

{

$sql = "SELECT id FROM ".$_POST['table2'];

$lastID = 0;

$firstID = 1;

$first_cnt = 0;

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

$lastID = $row['id'];

if($first_cnt==0)

{

$firstID = $row['id'];

$first_cnt++;

}

}

}

//End of get Last ID

//Delete Functions --

for($x = $lastID; $x>=$firstID; $x--)

{

$var1 = "Del".$x;

echo $var1."
";

if(isset($_POST[$var1]))

{

echo "----";

$sql = "DELETE FROM ".$_POST['table2']." WHERE id=".$x;

if ($conn->query($sql) === TRUE) {

echo "Record deleted successfully";

} else {

echo "Error deleting record: " . $conn->error;

}

}

}

}

$conn->close();

}

?>

HTML！

Manage Content

Select DB :

Training

Wallpaper

Community

Event

BeforeAndAfter

选择表单的工作部分

Upload Content

Select DB :

Training

Wallpaper

Community

Event

BeforeAndAfter