dragon456101 2018-03-08 06:38
浏览 60
已采纳

使用PDO根据另一个表的第一个值查询MYSQL数据库

Hi I am having trouble querying a mysql table based on the first value of another table here is my code.

<?php

$host    = 'localhost';
$db      = 'msdds';
$user    = 'root';
$pass    = '';
$charset = 'utf8';



$dsn = "mysql:host=$host;dbname=$db;charset=$charset";



$opt = [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
        ];


$dbh = new PDO($dsn, $user, $pass, $opt);



$sql  = $dbh->query("SELECT name FROM employee WHERE remarks != 'done' and branch ='EGYPT' and tenure=""");
$rows = $sql->fetchAll();
echo json_encode($rows);



?>

I want to add a query on tenure based on the first value of another table. I need to query from another table currently it is connected to employee table but I have another table that contains tenure and based on the first value there will be the content of tenure

  • 写回答

1条回答 默认 最新

  • doujuegai8830 2018-03-08 06:40
    关注

    Replace your Query with this

    $sql = $dbh->query("SELECT name FROM employee WHERE remarks != 'done' AND (branch ='EGYPT' and tenure='')");

    $rows = $sql->fetchAll();

    tenure is also equal to single quote.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 我需要全国每个城市的最新小区名字等数据。
  • ¥15 开发一个小区生态的小程序
  • ¥15 MddBootstrapInitialize2失败
  • ¥15 LCD Flicker
  • ¥15 Spring MVC项目,访问不到相应的控制器方法
  • ¥15 esp32在micropython环境下使用ssl/tls连接mqtt服务器出现以下报错Connected on 192.168.154.223发生意外错误: 5无法连接到 MQTT 代理,如何解决?
  • ¥15 关于#genesiscsheel#的问题,如何解决?
  • ¥15 Android aidl for hal
  • ¥15 STM32CubeIDE下载程序报错
  • ¥15 微信好友如何转变为会员系统?(相关搜索:小程序)