dongyi9484 2018-06-05 12:43
浏览 74

使用PHP的HTML SQL服务器连接

I have a HTML form and I want to use the results to filter the data available in a SQL file. I'm trying to connect to a local MySQL server but It doesn't work, i don't achieve to enter in the table() function.

I use the following code:

<form id="form_id" action="food_values.php" method="post" name="myform">
...
  <input onclick="table" type="button" value="Submit">

</form>

The php file contains the following code:

<html>
<body>
<?php
function table(){
    echo ("INSIDE");
    $con = mysql_connect("localhost","root"," ");
     if (mysqli_connect_errno())
        {
            echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }
    else {
        echo "CONNECTED";
    }
}
?>
</body>
</html>

It doesn't show anything... Do you know where is the error?

  • 写回答

2条回答 默认 最新

  • dongmi4809 2018-06-05 12:54
    关注

    You can not execute a PHP-Function with "onclick". Execute PHP function with onClick

    With a form, you load the whole .php-file if you click on the submit.

    The following code should work for you:

    <html>
<body>
<?php
    echo ("INSIDE");
    $con = mysql_connect("localhost","root"," ");
     if (mysqli_connect_errno())
        {
            echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }
    else {
        echo "CONNECTED";
    }
?>
</body>
</html>

    And the HTML

    <form id="form_id" action="food_values.php" method="post" name="myform">
...
  <input type="submit" value="Submit">

</form>
    评论

报告相同问题？

悬赏问题

  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题！
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像，如何解决？
  • ¥15 求daily translation（DT）偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮
  • ¥15 ads仿真结果在圆图上是怎么读数的
  • ¥20 Cotex M3的调试和程序执行方式是什么样的？
  • ¥20 java项目连接sqlserver时报ssl相关错误
  • ¥15 一道python难题3
  • ¥15 牛顿斯科特系数表表示