• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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: