dongyongmin5711 2018-02-24 10:51 采纳率: 100%
浏览 36
已采纳

PHP:在OOP上使用POST并存储在MySql中

Ok im kinda new to using oop on php, So this what im tryna do. getting the value of the textbox putting them in an array then storing them in database but the problem is it doesnt store the data

<?php
require ('employmentfunc.php');
?>
<html>
<head>
</head>
<body>
<?php 
$arr = array(isset ($_POST['company']), isset ($_POST['position']));

if (isset($_POST['ok']))
{
    $a = new empfunc();
    $a->SaveA($arr);
}
?>
<form name="emp" action="employmentform.php" method="POST">

<TD><input type="text" name="company">
<td><input type="text" name="position">
<input type="submit" class="button1" name="ok">
</form>
</body>
</html>



<?php
class empfunc{

function saveA($array){
    $sqlconnect = mysqli_connect("localhost", "root","","employment");
    $sqlquery = "INSERT INTO info(`Company`, `Position`) VALUES ('$array[0]', '$array[1]')";
    mysqli_query ($sqlconnect, $sqlquery);
}
}
?>
  • 写回答

1条回答 默认 最新

  • dro44817 2018-02-24 11:14
    关注

    Your problem is the way you are building the $arr variable. You are storing boolean results from the isset function calls instead of storing the data itself. I would rewrite that part of the code using a few more lines to make it more readable. Since you are storing the result of isset your values stored in the database will be either 0 or 1. Instead, either do not use the isset function or else change them to a ternary operator to store some default data if they are not set:

    $arr = array(
        isset ($_POST['company']) ? $_POST['company'] : 'No Company', 
        isset ($_POST['position']) ? $_POST['position'] : 'No Position'
    );
    

    or if you just want to skip the isset validation:

    $arr = array($_POST['company'], $_POST['position']);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 数学建模,尽量用matlab回答,论文格式
  • ¥15 昨天挂载了一下u盘,然后拔了
  • ¥30 win from 窗口最大最小化,控件放大缩小,闪烁问题
  • ¥20 易康econgnition精度验证
  • ¥15 msix packaging tool打包问题
  • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能