How to pass the array value to the function

[Fabio_Siqueira]

Hello guys!!

I want to build a function that read and save csv file in MySql.

 

The problem is that I can't pass the while array in function 'cause i want to change the variable $sql sometimes just to reduce my code in the future.

 

Ex:

function connect(){

@mysql_connect("localhost", "root", "");

mysql_select_db("school");

}

 

function import($sql=null){

 

$filename = $_GET['file'];

$openfile = fopen($filename, "r");

while(($row = fgetcsv($openfile,2048,";"))!==FALSE) {

 

 

mysql_query($sql) or die(mysql_error());

 

 

}

 

 

fclose($openfile);

}

 

$report = "Insert into table (DocumentoSD,Descricao,Cod_Client,Cliente) values('$row[0]','$row[1]','$row[2]','$row[3]')";

 

connect();

Import($report);

[benanamen]

Before even dealing with your question, you need to stop using deprecated Mysql code and stop suppressing errors with @. You need to use PDO with prepared statements.

[Fabio_Siqueira]

Yes I know that!!

Actually i'm using Mysqli

Edited February 9, 2016 by Fabio_Siqueira

[Jacques1]

Actually i'm using Mysqli

 

Then post the updated code.

[Barand]

Closing this topic as you have reposted it in another of the forums