MySQL-dan foydalanishni optimallashtirish

3339

Yangi formatda davom etish uchun: https://uzfor.net/view.php?id=10228&page=3

MySQL-dan foydalanishni optimallashtirish

Xabarlar

uDesign [758] [off]
#49 14:37:03, 23 Dec 2018

AZIK, # AZIK (23.12.2018 / 10:47)
Shokha, masalan news tablitsadan
yangilikni "idi" "mavzusi" "matni" "vaqti" "rasmi" shular qanday kodlar bilan chiqariladi

$id = '1'; // bu yerda  id raqami 1 bo`lgan yangiligimizning ma`lumotlari chiqariladi!
$udes = mysql_query("SELECT * FROM `news` WHERE `id` = '$id'");
while ($ud = mysql_fetch_array($udes)) {
echo '<div class="menu">' . $ud['mavzusi'] . '</div>';
echo '<div class="menu">' . $ud['matni'] . '</div>';
echo '<div class="menu">' . $ud['vaqti'] . '</div>';
echo '<div class="menu">' . $ud['rasmi'] . '</div>';
}

+ (1): AZIK,

AZIK [16] [off]
#50 17:32:41, 23 Dec 2018

uDesign, kod uchun rahmat bu kodlarni pustoy php faylga yozsam ishlamaydi bazani ulashniyam urgating
oldin baza bilan ishlamagandiman
mana bu kodlar to'g'rimi va qanday moslasa boladi siz yozgan kodga

$dbhost = "localhost"; // Хост
$dbuser = "dbuser"; // Имя пользователя
$dbpassword = "qwerty"; // Пароль
$dbname = "dbname"; // Имя базы данных
// Подключаемся к mysql серверу
$link = mysql_connect($dbhost, $dbuser, $dbpassword);
// Выбираем нашу базу данных
mysql_select_db($dbname, $link);

AkMaL [413] [off]
#51 20:13:22, 27 Aug 2019

Notice: Trying to get property of non-object in Z:\home\sprut\www\xabar\index.php on line 10

bu yerda nima deyapti iltimos tushunganla yozsin
30 soniyadan keyin yozdi:

$k_post = $db->super_query("SELECT * FROM `xabar_k` WHERE `kim` = '".$user['id']."'")->num_rows;

mana o'sha qator

Akbarali [2384] [off]
#52 15:53:57, 28 Aug 2019

AkMaL, # AkMaL (27.08.2019 / 20:13)
Notice: Trying to get property of non-object in Z:\home\sprut\www\xabar\index.php on line 10

bu yerda nima deyapti iltimos tushunganla yozsin
30 soniyadan keyin yozdi:
$k_post = $db->super_quePDO ? Denwer?

xabar_k tablitsada kim ustuni bormi?