read text file in php and use its content to fetch data from mysql database

Question

I'm trying to read a text file using PHP. After I read the content I want to match the content with an existing table in mysql.

My text file has this content

           :mh2045

The file is a .txt file

I use the following php code to read the text file

            <?php
               $file =         file_get_contents("file.txt");
              ?>

How do I use the contents of $file to compare with the field "vehicleid" of table vehicle info in mysql

this is the php code for selecting records after comparing with content in $file

      <?php
       $servername = "localhost";
       $username = "root";
       $password = "password";
       $dbname = "sample";
       $file=file_get_contents("file.txt");
       @var =$file;

         // Create connection
          $conn = new mysqli($servername, $username, $password,             $dbname);
         // Check connection
         if ($conn->connect_error) {
         die("Connection failed: " . $conn->connect_error);
         } 

      $sql = "SELECT *
                   FROM vehicleinfo
                   WHERE vehicleid =    (SELECT vehicleid 
                                      FROM vehicleinfo
                                       WHERE owner= @var)";
       $result = $conn->query($sql);

      if ($result->num_rows > 0) {
       // output data of each row
     while($row = $result->fetch_assoc()) {
              echo "id: " . $row["vehicleid"]. " - Name: " .              $row["name"]. " " . $row["owner"]. "<br>";
 }
   } else {
   echo "0 results";
        }
               $conn->close();

@var seems to be the Problem. For Variables in PHP you use $. @ is for Error Handling — j_s_stack
– j_s_stack, Commented Jan 26, 2015 at 5:35
vardump() $file, u will see ur variable content, and will find out how to use it. — NomNomNom
– NomNomNom, Commented Jan 26, 2015 at 5:35

j_s_stack · Accepted Answer · 2015-01-26 06:49:37Z

1

For Variables in PHP use $ not @. @ is for Error Handling. With a . you can connect Strings, ist a bad Practice to write the Var into a String. And also use ' rather then " for Strings. That makes your proccesing quicker, becouse the Compiler doesn't look vor Variables in the String.

$file = file("file.txt", FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
$sql = 'SELECT *
                   FROM vehicleinfo
                   WHERE vehicleid =    (SELECT vehicleid 
                                      FROM vehicleinfo
                                       WHERE owner= '. $file .')';

answered Jan 26, 2015 at 6:49

j_s_stack

6651 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Shradhaa Deepaque Parkkar Over a year ago

now it doest compare owner's value in the database with the content of $file which seems to be an array of string says zero result altough there is a record in the vehicle info table where owner = content of $file

j_s_stack Over a year ago

Do you get an Error Mesg? You Query might be wrong, try 'SELECT * FROM vehicleinfo WHERE owner = $file

Shradhaa Deepaque Parkkar Over a year ago

$sql = "SELECT * FROM vehicleinfo WHERE owner = ' . $file[0] . ')"; i tried this it says again trying to get non object property

Shradhaa Deepaque Parkkar Over a year ago

if i use $file instead of $file[0] it says tring to convert string into array

j_s_stack Over a year ago

Do you have Access to phpmyAdmin or similar? Try Your Query in there to make sure you Query is not the Problem

|

Aniruddh · Accepted Answer · 2015-01-26 05:36:20Z

0

Get rid of the @var line and use following SQL query:

$file = file("file.txt", FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);

$sql = "SELECT *
                   FROM vehicleinfo
                   WHERE vehicleid =    (SELECT vehicleid 
                                      FROM vehicleinfo
                                       WHERE owner= ". $file[0] .")";

answered Jan 26, 2015 at 5:36

Aniruddh

7,6881 gold badge28 silver badges43 bronze badges

5 Comments

Shradhaa Deepaque Parkkar Over a year ago

I tried doing it,it says,"trying to get property of non object in D :\wamp\www\display.php

j_s_stack Over a year ago

insert vardump($file); and tell us what it says

Shradhaa Deepaque Parkkar Over a year ago

string 'mh2045' (length=6)

Shradhaa Deepaque Parkkar Over a year ago

the content of the text file is string

j_s_stack Over a year ago

then you dont Need the[0] behind the $file in the SQL Query

Collectives™ on Stack Overflow

read text file in php and use its content to fetch data from mysql database

2 Answers 2

6 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related