PHP从另一个页面获取值

debugcn 发表于 Dev

马克图

我有这个页面admin_inquiry.php（page1），它有一个动态表来显示记录的行。我想从2列获取值，ContactNo和message。contactno列包含一个链接，该链接转到admin_sms.php（page2）并在文本字段中显示联系人编号。

第1页：

<td><a href="admin_sms.php?ContactNo=<?php echo $row_ContactUs['ContactNo']; ?>">Send SMS</a></td>

第2页：

<input name='number' type='text' id="number" value="<?php if(isset($_GET['ContactNo'])){echo $_GET['ContactNo'];}else{echo "";}?>">

我也想从第1页上获取列消息的内容，并在第2页的文本区域中显示它。但是它应该显示消息属于特定的id或某些东西。我听说过会议，但还不太清楚。你能告诉我如何吗？

更新我在admin_inquiry.php中尝试过

$_SESSION['message'] = $row_ContactUs['message'];

admin_sms.php

$_SESSION['message'];

<textarea name="frmMsg" id="frmMsg" cols="45" rows="5"><?php echo $_SESSION['message'];?></textarea>

问题是，它显示相同的消息。不是属于某个ID或某物的对应消息。请帮助我。

六月

如果您仍然无法解决此问题，请在表格中添加一个 html form

更新包括分页

第一个解决方案，创建一个文件并将其命名为contact.php

<?php  
$db = new PDO('mysql:host=localhost; dbname=data','root','');
$contacts = $db->query('SELECT * FROM contactdetails');

//creating pagination
$nav_counter = basename($_SERVER['SCRIPT_FILENAME']); //getting name of the current page
$current_page = $nav_counter;
$nav_counter = rtrim($nav_counter, ".php"); //getting the name of the current page and removing the extension

//creating pagination pages
$next_page = $nav_counter + 1;
$prev_page = $nav_counter - 1;

//getting row count, we are going to use it to limit our query and to create pagination
$row_count = $contacts->rowCount();

//number of records to show per page
$num_records = 5;

//getting the last page
$last_page = ($row_count / $num_records) - 1;
    if(!is_int($last_page)){
    $last_page = (int)$last_page + 1;
  }

//displaying records 
$start = 0;
$limit = $num_records; //number of records to show

if ($current_page !== 'admin_inquiry.php'){
    $start = ($limit * $nav_counter);
}

//getting number of rows left in the table
$rows_left = $db->query("SELECT * FROM contactdetails ORDER BY ID limit $start,$limit");
$num_rows = $rows_left->rowCount();

//if records left in the table is less than the number of records to show $num_records
if ($num_rows < $num_records) {
    $limit = $num_rows; //limit is equal to the number of records left in the table
}

//getting number of records from the table
$contacts = $db->query("SELECT * FROM contactdetails ORDER BY ID limit $start,$limit");

//displaying pagination and creating pages if they don't exists
 $pages = array();
for ($counter = 1; $counter <= $last_page; $counter++) { 
 $pages[] = $counter;
}
//storing pages in array and creating a page if it doesn't exist
foreach ($pages as $num) {
$page = $num.'.php';
if(file_exists($page)== false && $num <= $last_page){
    copy('admin_inquiry.php', $page);
 }
} 
?>

创建一个pagination.php文件

<p class="pagenav"><a href="<?php if($current_page == '1.php'){ echo 'admin_inquiry.php';}else{echo $prev_page.'.php';}  ?>" <?php if($current_page == 'admin_inquiry.php'){echo 'class="hide"';} ?>>&lt;</a> <a href="<?php echo $next_page.'.php'; ?>" <?php if($next_page > $last_page){echo 'class="hide"';} ?>>&gt;</a></p>

创建一个CSS文件admin.css

table {
width: 100%;
margin: 0 auto;
}
table, td, th {
border: 1px solid black;
 }

th {
height: 50px;
}
#div{
width: 40%;
margin: 0 auto;
}
.pagenav a{
display: inline;
width: 100px;
padding: 10px;
height: 100px;
border-radius: 50px;
font-size: 20px;
color: #fff;
line-height: 50px;
text-align: center;
text-decoration: none;
background-color: #0186ba;
  }
.pagenav a:hover{
background-color: #fff;
border: 1px solid #000;
color: #000;
}
.hide {
display: none !important;
}
p{
text-align: center;
}

admin_iquiry.php文件

 <?php 
  require_once('contact.php');
 ?>
 <!DOCTYPE html>
 <html>
 <head>
   <title></title>
   <link rel="stylesheet" type="text/css" href="admin.css">
 </head>
 <body>
 <div id="div">
    <table>
      <tr>
         <th>ID</th>
         <th>Contact No.</th>
         <th>Message</th>
      </tr>
     <?php foreach ($contacts as $value) : ?>
          <tr><td><?php echo $value['ID']; ?></td><td><?php echo $value['ContactNO']; ?></td><td><?php echo $value['Message'] ?></td><td><form action="admin_sms.php" method="post"><input type="hidden" name="ContactNo" value="<?php echo $value['ContactNO']; ?>"><input type="hidden" name="Message" value="<?php echo $value['Message']; ?>"><input type="Submit" value="Send SMS" name="send_sms" /></form></td></tr>
      <?php endforeach; ?>
    </table>
    <?php require_once('pagination.php'); ?>
    </div>
   </body>
   </html>

admin_sms.php

<?php 
   if(isset($_POST['send_sms'])){
$contactNo = $_POST['ContactNo'];
$message = $_POST['Message'];
}

?>

HTML代码

<div style="margin:0 auto; width:50%">
 <p>Message for: <?php echo $contactNo; ?></p>
<textarea><?php echo "$message"; ?></textarea>

在此处输入图片说明

第二解决方案使用 $_GET

<?php 
  require_once('contact.php');
 ?>
<!DOCTYPE html>
<html>
<head>
    <title></title>
    <link rel="stylesheet" type="text/css" href="admin.css">
</head>
<body>
<div id="div">
<table>
<tr>
    <th>ID</th>
    <th>Contact No.</th>
    <th>Message</th>
</tr>
foreach ($contacts as $value) : ?>
    <tr><td><?php echo $value['ID']; ?></td>
            <td><?php echo $value['ContactNO']; ?></td>
            <td><?php echo $value['Message'] ?></td>
            //use id of the contact no and in the next page use that id to query data related to that id
            <td><a href="admin_sms.php?id=<?php echo $value['ID']; ?>">Send Sms</a></td></tr>
<?php endforeach; ?>
  </table>
   <?php require_once('pagination.php'); ?>
  </div>
  </body>
  </html>

admin_sms.php

<?php 
 $db = new PDO('mysql:host=localhost; dbname=data','root','');
 if(isset($_GET['id'])){
 $id= $_GET['id'];
 $results = $db->query("SELECT * FROM contactdetails WHERE ID = $id");
 foreach ($results as  $value) {
       $contactNo = $value['ContactNO'];
      $message = $value['Message'];
     }
   }

 ?>

在你的HTML中

<div style="margin:0 auto; width:50%">
  <p>Message for: <?php echo $contactNo; ?></p>
<textarea><?php echo "$message"; ?></textarea>

在此处输入图片说明

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。

编辑于2021-06-10

我来说两句

0条评论

登录后参与评论

来自分类Dev