cuốn sách gpt4 ai đã làm

用于超链接的变量中的 PHP 空格

In lại Tác giả: Walker 123 更新时间:2023-11-29 02:23:30 28 4
mua khóa gpt4 Nike

我是 php 的新手,我正在尝试将一系列变量添加到 html 超链接中。但是,任何返回空格的变量都会弄乱超链接。

    
<đầu>
Grants Test


// Connect to Database
mysql_connect("XXXXXXXX", "XXXXXXX", "XXXXXXXXXX") or die(mysql_error());
mysql_select_db("XXXXXXXXX") or die(mysql_error());

$mode = $_GET['mode'];
$Name = $_GET['Name'];
$DOP = $_GET['DOP'];
$SRN = $_GET['SRN'];
$SUP = $_GET['SUP'];
$COG = $_GET['COG'];
$CUST = $_GET['CUST'];
$Comments = $_GET['Comments'];
$Upload_T = $_GET['Upload_T'];
$Edit_T = $_GET['Edit_T'];
$PONumber = $_GET['PONumber'];
$self = $_SERVER['PHP_SELF'];


//Edit Mode
if ( $mode=="edit")
{
Print '

Edit




method=GET>


PONumber:

Name:

Date of Purchase:

Service Report:

Supplier:

Cost ex.VAT:

Customer:

Comments:





';
}

if ( $mode=="edited")
{
mysql_query ("UPDATE purchase SET Name = '$Name', DOP = '$DOP', SRN = '$SRN', SUP = '$SUP', COG = '$COG', CUST = '$CUST', Comments = '$Comments', Upload_T = '$Upload_T', Edit_T = NOW() WHERE PONumber = $PONumber");
Print "Data Updated!

";
}

//Delete Mode
if ( $mode=="remove")
{
mysql_query ("DELETE FROM purchase where PONumber=$PONumber");
Print "Entry has been removed

";
}

//Show Table
$data = mysql_query("SELECT * FROM purchase ORDER BY PONumber ASC")
or die(mysql_error());
Print "

Purchase Orders

";
Print "

";
Print "";
while($info = mysql_fetch_array( $data ))
{
Print " ";
Print " ";
Print " ";
Print " ";
Print " ";
Print " ";
Print " ";
Print " ";
Print " ";
Print " ";
Print ""; Print "";
}
Print "
PONumberNameDate of PurchaseService ReportSupplierCost ex.VATCustomerCommentsTime RequestedLast Edited
".$info['PONumber'] . "".$info['Name'] . "".$info['DOP'] . "".$info['SRN'] . "".$info['SUP'] . "".$info['COG'] . "".$info['CUST'] . "".$info['Comments'] . "".$info['Upload_T'] . "".$info['Edit_T'] . "EditRemove
";

这是我遇到的问题,数据是从数据库中提取的,但是任何带有空格的数据都会被截断。

Print "Edit"; Print "Remove"; 

查看输出:

Edit

我怎样才能阻止这种情况发生?

谢谢,授予

câu trả lời hay nhất

您需要使用 urlencode 对 URL 参数进行编码。

另外,不要使用 mysql_ 函数,它们容易出错导致安全漏洞,稍后将从 PHP 中删除。而是学习 PDO。

关于用于超链接的变量中的 PHP 空格,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/27530048/

28 4 0
Xem sitemap của VNExpress