/ Published in: PHP
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
<?php //script per il controllo del supplier e verifica se le songs sono ancora attive $db_host = "soundreef.cgwpjynqhrxz.eu-west-1.rds.amazonaws.com"; $db_username = "dbuser"; $db_password = "yatudob"; $db_name = "soundreef"; mysql_connect("$db_host","$db_username","$db_password") or die("Sorry we could not connect to our database."); $a = 0; foreach ($fileArrN as $value){ $a++; } $csv=''; $not_found=''; $q="SELECT active, supplier_id, artist, title from song where TRIM(title) like '".$title_trimmed."' and TRIM(artist) like '".$artist_trimmed."'"; $csv .= $result[0].";".$result[1].";".$artist_trimmed.";".$title_trimmed."\n"; } ?> ?>