dsd57259 2017-04-05 15:19
浏览 30

从SQL表中获取单数值

I am trying to fetch a value from one of my tables, however it doesn't appear to be retrieving it as when I echo the variable nothing is displayed.

Here is my code

<?php
$conn = new mysqli('localhost','root','root','neadatabase'); //Creating 
connection to database



//Connection Error Checking
if ($conn->connect_error) 
{
    die("Connection Failed: " . $conn->connect_error);
}

echo ("Connection Successful");

//selecting bookings
$sqlSelectBookings = "
    SELECT ActivID, DateRequired, TimeRequired
    FROM activbooking
    WHERE ActivID = '$_POST[ActivID]' AND DateRequired = 
   '$_POST[DateRequired]' AND '$_POST[DateRequired]' AND 'TimeRequired = ' 
   $_POST[TimeRequired]'
";

$sqlSelectBookings = $conn->que($sqlSelectBookings);

//getting member limit
$sqlGetMemberLimit = "
    SELECT memberLimit
    FROM activity
    WHERE activID = '$_POST[ActivID]'
";

$sqlGetMemberLimit = ($conn->query($sqlGetMemberLimit)-
>fetchObject(memberLimit));

echo $sqlGetMemberLimit;

Any ideas?

This is what happens when I run the page

Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?