新手,轻拍. 各位大哥大姐们帮我看一下这段php代码问题出在哪-php教程-PHP中文网

新手,轻拍. 各位大哥大姐们帮我看一下这段php代码问题出在哪

php中文网

发布： 2016-06-23 14:02:30

原创

1197人浏览过

Html Code:

[/code]

PHP code:

<html><head><title>Sales Rep Maintenance</title></head><?php// Address error handlingini_set('display_errors',1);error_reporting(E_ALL & ~E_NOTICE);// Attempt to Connectif ($connection = @mysql_connect ('localhost', '***', '***')){	print '<p>successfully connected to mysql.</p>';	//mysql_close(); // close the connection}else {	die('<p>Could not connect to MySQL because: <b>' .mysql_error() .	'</b></p>');}if (@mysql_select_db("PREMIERE", $connection)){	print '<p>The PREMIERE database has been selected.</p>';}else {	die('<p>Cound not select the PREMIERE database because: <b>' .mysql_error().'</b></p>');}if(!$_REQUEST['submit']){	generate_form();}else if($_REQUEST['submit'] == "Search"){	search_rep();}else if($_REQUEST['submit'] == "Add"){	add_rep();}else if($_REQUEST['submit'] == "Delete"){	delete_rep();}else if($_REQUEST['submit'] == "Update"){	update_rep();}function generate_form(){}function search_rep(){// Define the rep Number php variable name$rep = $_POST['rep_num'];print "The rep num chosen was $rep<br/>";// Define the query$query = "SELECT * FROM REP WHERE CUSTOMER_NUM = '$rep'";// Output the resulting query tableif ($r = mysql_query($query)){	while ($row = mysql_fetch_array($r))	{		print "<p>{$row['REP_NUM']}<br/>{$row['LAST_NAME']}<br/>{$row['FIRST_NAME']}<br/>		{$row['STREET']}<br/>{$row['CITY']}<br/>{$row['STATE']}<br/>{$row['ZIP']}<br/>		{$row['COMMISSION']}<br/>{$row['RATE']}<br/></p>
                    <div class="aritcle_card">
                        <a class="aritcle_card_img" href="/ai/1365">
                            <img src="https://img.php.cn/upload/ai_manual/000/000/000/175679975740787.png" alt="腾讯云AI代码助手">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/ai/1365">腾讯云AI代码助手</a>
                            <p>基于混元代码大模型的AI辅助编码工具</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="腾讯云AI代码助手">
                                <span>98</span>
                            </div>
                        </div>
                        <a href="/ai/1365" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="腾讯云AI代码助手">
                        </a>
                    </div>
                <p><span>立即学习</span>“<a href="https://pan.quark.cn/s/7fc7563c4182" style="text-decoration: underline !important; color: blue; font-weight: bolder;" rel="nofollow" target="_blank">PHP免费学习笔记（深入）</a>”；</p>\n";	}}}function add_rep(){}function delete_rep(){}function update_rep(){}?></html>

登录后复制

可以连接到mySQL服务器上, 但是不能显示结果...

回复讨论(解决方案)

error_reporting(E_ALL & ~E_NOTICE);
改作
error_reporting(E_ALL);
可能就知道了

把 $row 的关联键改成小写看看

error_reporting(E_ALL & ~E_NOTICE);
改作
error_reporting(E_ALL);
可能就知道了

把 $row 的关联键改成小写看看

我试了, 错误提示为:
Undefined index: submit ... on line 28
Undefined index: submit ... on line 33

28行是 if(!$_REQUEST['submit']) 接受的是表单提交的数据
但你的表单中并没有名为 submit 的控件

楼上正解，给type为submit的input加name=submit

28行是 if(!$_REQUEST['submit']) 接受的是表单提交的数据
但你的表单中并没有名为 submit 的控件

那应该怎么改呢？
html文件：