duanqiang2617 2014-06-15 16:30
浏览 13

在数据库中插入记录

I have a file called functions.php which contains many functions, now what i want to do is store whatever those functions return in a database. What i am currently doing is that i am starting a database connection in every function and closing it as well in every connection. Which what it does it that, it stores the data in database but it also increments the rows in my database. each value returned by a function is being stored in a different row. I want them to be in the same row. What should i do? This is my code so far,

function h3() {

$con=mysqli_connect("localhost","root","","fyp");
// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$url=$_POST["urlo"];

$counter = 0;
include_once('simple_html_dom.php');

$html = file_get_html($url);

foreach($html->find('h3') as $element){
    $counter++;
}

echo $counter;

mysqli_query($con,"INSERT INTO results(h3) VALUES ('$counter')");
mysqli_close($con);
}

function paragraph() {
$con=mysqli_connect("localhost","root","","fyp");
// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$url=$_POST["urlo"];

$counter = 0;
include_once('simple_html_dom.php');

$html = file_get_html($url);

foreach($html->find('p') as $element){
    $counter++;
}

echo $counter;
mysqli_query($con,"INSERT INTO results(p) VALUES ('$counter')");
mysqli_close($con);
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 我的代码无法在vc++中运行呀,错误很多
    • ¥50 求一个win系统下运行的可自动抓取arm64架构deb安装包和其依赖包的软件。
    • ¥60 fail to initialize keyboard hotkeys through kernel.0000000000
    • ¥30 ppOCRLabel导出识别结果失败
    • ¥15 Centos7 / PETGEM
    • ¥15 csmar数据进行spss描述性统计分析
    • ¥15 各位请问平行检验趋势图这样要怎么调整?说标准差差异太大了
    • ¥15 delphi webbrowser组件网页下拉菜单自动选择问题
    • ¥15 wpf界面一直接收PLC给过来的信号,导致UI界面操作起来会卡顿
    • ¥15 init i2c:2 freq:100000[MAIXPY]: find ov2640[MAIXPY]: find ov sensor是main文件哪里有问题吗