[SOLVED] $data =implode("','",$dbquery); ???

[djdellux]

i am having trouble with a specific line of code and have been emersed in my A+ cert over the last 2 wks so any help to bring me back to the world of php would be great heres the rest of the code

 

<?php
        $dbvoip = sqlite_open('voip.sqlite');

        if ($dbvoip == false)
        {
                die ('Unable to open database');
        } else {
                echo 'Database created.';
        }

$dbinfo=file("master.csv");

foreach ($dbinfo as  $dbquery) {

    $data =implode("','",$dbquery);
    
    print_r($dbquery);
exit;     

$dbquery = "INSERT INTO voip (C0, number1, number2, type, number3, linetype, c1, dial, c2, date1, date2,
   date3, c3, c4, anw, DOCUMENTATION, unix, C17)
   VALUES ($data)";
   
    
}
           sqlite_close($dbvoip)

?>

[JonnoTheDev]

You need to print the error

[djdellux]

ie print $data  ??

[nadeemshafi9]

ie print $data  ??

 

data is a string, $dbquery is an array , otherwise it wont work cos $data =implode("','",$dbquery); means take $dbquery and implode it seperated by ',' in to a string

[JonnoTheDev]

No, I mean post the error you are receiving from your code. How can we see what is wrong if you dont explain or post the error.

[djdellux]

Warning: implode() [function.implode]: Bad arguments. in c:\program files\Apache\htdocs\csv2.php on line 15

 

sorry bout that lol

[JonnoTheDev]

implode() takes an array and converts to a string. Is your variable an array?

foreach ($dbinfo as  $dbquery) {
    $data =implode("','",$dbquery);
    print_r($dbquery);

 

Also lose the ' in the implode separator

$data = implode(",",$dbquery);

[djdellux]

my whole intention is to insert info into the $dbquery variable

 

new code after tweking

does it look like this is accomplished

 

<?php
        $dbvoip = sqlite_open('voip.sqlite');

        if ($dbvoip == false)
        {
                die ('Unable to open database');
        } else {
                echo 'Database created.';
        }

$dbinfo=file("master.csv");

foreach ($dbinfo as  $dbquery);
{

   // $data =implode(",",$dbquery);
  

   
$dbquery = "INSERT INTO voip (C0, number1, number2, type, number3, linetype, c1, dial, c2, date1, date2,
   date3, c3, c4, anw, DOCUMENTATION, unix, C17)
   VALUES ($dbquery)";
   echo($dbquery);
    
}
           sqlite_close($dbvoip)

?>