Execute sql query using php

Question

I have connected the sql database server using FreeTDS in php. I am trying to execute sql select query in php. I can't able to execute query. I mentioned the program below

 <?php
    $empid = 10068;
    try
    {
        $db = new PDO('odbc:Driver=FreeTDS; Server=XXXXXXX; Port=1433; Database=XXXX; UID=XXXXXX; PWD=XXXXX;');
    }
    catch(PDOException $exception)
    {
        die("Unable to open database.<br />Error message:<br /><br />$exception.");
    }
    echo '<h1>Successfully connected!</h1>';
    echo gettype($empid);
    $query = "select Employee_ID from REPT_Employee where Employee_ID=$empid";
    echo $query
    **$statement = $db->prepare($query);** //Getting error in this line
    $statement->execute();
    $result = $statement->fetchAll(PDO::FETCH_NUM);
    echo $result 
 ?>

I Can't able to execute the query. Can anyone help me to find out what mistake i did.

i didn't get the error log. the line doesn't work which i highlighted above... now i found the solution.. will answer it... — Python Team, Jun 25 '14 at 10:16
now i want to get values from database. can't able to fetch data.. — Python Team, Jun 25 '14 at 10:18
In PDO you can check query errors by `if(!$statement->execute()) print_r($statement->errorInfo());` — turson, Jun 25 '14 at 10:21
when i try to fetch data from database am getting the the result like "Array".. I need to get value of particular id which i passed in that query. — Python Team, Jun 25 '14 at 10:25
Ohh, I recommend read PHP manual and check how to display array: `foreach()` — turson, Jun 25 '14 at 10:28

score 0 · Accepted Answer · answered Jun 25 '14 at 10:19

0

To change like this

 $statement = $db->query("select Password from REPT_Employee where Employee_ID=$empid");
 $statement->execute();

answered Jun 25 '14 at 10:19

Python Team

1,143
4
21
50

score 0 · Answer 2 · answered Jun 25 '14 at 10:49

0

if you don't use the bindParam function you have to use prepare function in this way :

$statement = $db->prepare("select Employee_ID from REPT_Employee where Employee_ID='$empid'");

Just add quotes '' to $empid string in the $query string.

answered Jun 25 '14 at 10:49

Davide

113
2
11

Try to use `bindParam` function : `$statement = $db->prepare("select Employee_ID from REPT_Employee where Employee_ID=:empid"); $statement->bindParam(":empid",$empid); $statement->execute();` – Davide Jun 25 '14 at 11:17

Execute sql query using php

2 Answers2