I am trying to read some data from my Database in MySQL which i created via PHPmyAdmin. it seems that i can connect to it but i cannot do mysqli_query cause it's always showing a error message.
I tried looking on other Q & A but nothing seems to fix my problem, i just do not know what i am doing wrong. Can anyone please help me?
this is my index.php
<?php
$adCounter = 0;
//require_once ('conf.php');
// die Konstanten auslagern in eigene Datei
// die dann per require_once ('konfiguration.php');
// geladen wird.
// Damit alle Fehler angezeigt werden
error_reporting(E_ALL);
// Zum Aufbau der Verbindung zur Datenbank
// die Daten erhalten Sie von Ihrem Provider
define ( 'MYSQL_HOST', '');//i deletet those data for security reasons
// bei XAMPP ist der MYSQL_Benutzer: root
define ( 'MYSQL_BENUTZER', ''); //i deletet those data for security reasons
define ( 'MYSQL_KENNWORT', '');//i deletet those data for security reasons
define ( 'MYSQL_DATENBANK', '');//i deletet those data for security reasons // für unser Bsp. nennen wir die DB oglasi
$db_link = mysqli_connect (MYSQL_HOST, //$db_link = mysqli_connect mysqli_select_db
MYSQL_BENUTZER,
MYSQL_KENNWORT,
MYSQL_DATENBANK);
if ( $db_link )
{
echo 'Good: Veza uspesno postavljena sa Serverom: ';
print_r( $db_link);
}
else
{
// hier sollte dann später dem Programmierer eine
// E-Mail mit dem Problem zukommen gelassen werden
die('nije mogucce postaviti vezu sa Serverom: ' . mysqli_error());
}
//damit sprska slova nicht vorkommen
mysqli_set_charset($db_link, 'utf8');
$sql = "SELECT * MYSQL_DATENBANK ORDER BY date DESC LIMIT 30";
$db_erg = mysqli_query( $db_link, $sql );
if ( ! $db_erg )
{
die('Error: Ungültige Abfrage: ' . mysqli_error());
}
echo "<br>";
echo "<br>";
while ($zeile = mysqli_fetch_array( $db_erg))
{
echo '<span style="color:ORANGE; font-size:18px;">';
echo "<td>". $zeile['date'];
echo '</span>';
echo '<span style="color:orange; font-size:;">';
echo' (Godina-Mesec-Dan)';
echo '</span>';
echo "<br>";
echo '<strong>';
echo "<td>". $zeile['title'] . ": ";
echo '</strong>';
echo "<td>". $zeile['text'] . " --> ";
echo "<td>Tel. ". $zeile['number'] . "";
echo "</tr>";
echo "<br>";
echo "<br>";
$adCounter = $adCounter+1;
if($adCounter > 10){
echo '<div class="adsDiv"></div>';
echo '<div class="adsDiv"></div>';
}
}
echo "</table>";
mysqli_free_result( $db_erg );
mysqli_close($db_link);
?>
this is the message I Get
Good: Veza uspesno postavljena sa Serverom:
mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 0 [host_info] => sql302.epizy.com via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.6.41-84.1 [server_version] => 50641 [stat] => Uptime: 5082420 Threads: 8 Questions: 732608614 Slow queries: 6316 Opens: 5723522 Flush tables: 1 Open tables: 10000 Queries per second avg: 144.145 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 18480269 [warning_count] => 0 )
Error: Ungültige Abfrage: