BUG Problem with basic function of MYSQL

giuseppe

New member
Messages
1
Likes
0
Points
1
#1
By your plugin I created, in Wordpress, a snippet like this:

PHP:
$today=date('Ymd');

echo DB_HOST;

echo DB_USER;

echo DB_NAME;

echo DB_PASSWORD;

$connection = mysql_connect('DB_HOST', 'DB_USER', 'DB_PASSWORD') or die ("Impossibile connettersi al server host.");

$dbase="zonapastcg892";

mysql_query("SET NAMES 'utf8'");

mysql_select_db("$dbase") or die("Impossibile selezionare il database.");

$res_parametri = mysql_query("SELECT * FROM  vangelo where (DataOrdinata = $today )",$connection) ;

$row_parametri = mysql_fetch_array($res_parametri);

$video               =  $row_parametri['NomeFileMp3'];

$testo               =  $row_parametri['NomeFileTxt'];

$titolo                 =  $row_parametri['Titolo'];



echo $video;

echo $testo;

echo $titolo;

$a='<audio style="width: 400px;" controls="controls">

<source src=http://zonafossolo.it/wp-content/uploads/';

$b=' type="audio/mpeg" />';

echo $a.$video.$b;

In my local environment ( localhost by xampp) this code work ( with the appropriate user and password!)
Can you help me?
 
Last edited: