Report NF List

[:en][private]

Report NF List

[insert_php]

$servername = “localhost”;
$username = “imaes920_imaes2”;
$password = “dbimaes”;
$current_user = wp_get_current_user()->user_login;
// Create connection
$conn = mysql_connect($servername, $username, $password);
mysql_select_db(“imaes920_dbimaes”);

// Check connection
if (!$conn) {
die(“Connection failed: ” . mysql_connect_error());
}
mysql_set_charset(‘utf8’,$conn);
echo ‘

‘;
$query = mysql_query (“SELECT * FROM `NF` ORDER BY Country ASC”);
$num = 1;
while ($result = mysql_fetch_assoc($query)) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
$num+=1;
}
echo ‘

No. Country Code Country NF Name NF Code Establish Address Tel. E-mail
‘.$num.’ ‘.$result[Code3].’ ‘.$result[Country].’ ‘.$result[Full_Name].’ ‘.$result[Code_NF].’ ‘.$result[Establish].’ ‘.$result[Address].’ ‘.$result[Tel].’ ‘.$result[Email].’

‘;

[/insert_php]



[/private][:th][private]

Report NF List

[insert_php]

$servername = “localhost”;
$username = “imaes920_imaes2”;
$password = “dbimaes”;
$current_user = wp_get_current_user()->user_login;
// Create connection
$conn = mysql_connect($servername, $username, $password);
mysql_select_db(“imaes920_dbimaes”);

// Check connection
if (!$conn) {
die(“Connection failed: ” . mysql_connect_error());
}

echo ‘

‘;
$query = mysql_query (“SELECT * FROM `NF` ORDER BY Country ASC”);
$num = 1;
while ($result = mysql_fetch_assoc($query)) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
$num+=1;
}
echo ‘

No.
NF Code
Country
NF Name
NF Code
Establish
Address
Tel.
E-mail
‘.$num.’ ‘.$result[Code3].’ ‘.$result[Country].’ ‘.$result[Full_Name].’ ‘.$result[Code_NF].’ ‘.$result[Establish].’ ‘.$result[Address].’ ‘.$result[Tel].’ ‘.$result[Email].’

‘;

[/insert_php]
[/private][:]