Is it possible with phpgrid to export fresh data to csv to a folder on the server?
I solved it with:
$host = "localhost";
$username = DB_SERVER_USERNAME;
$password = DB_SERVER_PASSWORD;
$dbname = DB_DATABASE;
// open connection to mysql database
$connection = mysqli_connect($host, $username, $password, $dbname) or die("Connection Error " . mysqli_error($connection));
// fetch mysql table rows
$sql = "select * from plusinfo_intraship";
$result = mysqli_query($connection, $sql) or die("Selection Error " . mysqli_error($connection));
$fp = fopen('delisprint.csv', 'w');
while($row = mysqli_fetch_assoc($result))
//close the db connection
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?