MySQL-dan foydalanishni optimallashtirish

MySQL-dan foydalanishni optimallashtirish (58)

Nodirbek
#41 20:45:58, 10 Dec 2018

Krgold, ishlatib kuring qani
2 daqiqa 12 soniyadan keyin yozdi:
tekshirb ham yozishga vaqt yetmayapdi

AZIK
#42 20:22:26, 21 Dec 2018

bazadan malumot qanday olinadi???
10 daqiqa 8 soniyadan keyin yozdi:
biladiganlar iltimos yozvorelar

Shokha
#43 14:37:10, 22 Dec 2018

AZIK, SELECT * FROM tablitsa nomi

AZIK
#44 20:30:20, 22 Dec 2018

Shokha, toliqroq kodlar bilan iloji yoqmi

Shokha
#45 22:22:10, 22 Dec 2018

AZIK, sizni savolizga chunganimcha yozdim! agar savolni batafsilroq yozsez javobni ham batafsil yozib qoldiraman!

AZIK
#46 23:40:33, 22 Dec 2018

Shokha, mysql bazadan malumotlarni masalan index.php fayliga qanday qilib chiqariladi
???????

Shokha
#47 23:45:09, 22 Dec 2018

AZIK, Hop shu SELECT buyrugi orqali! qaysi tablitsadan nmani ochiqmoqchisz va qanaqa tartibda etsez zaprosini ham yozib beraman

AZIK
#48 10:47:56, 23 Dec 2018

Shokha, masalan news tablitsadan
yangilikni "idi" "mavzusi" "matni" "vaqti" "rasmi" shular qanday kodlar bilan chiqariladi

uDesign
#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>';
}

AZIK
#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
#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
#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?

AkMaL
#53 18:26:31, 28 Aug 2019

Akbarali, Denwer, bor albatta

Tayota
#54 00:04:18, 31 May 2020

SELECT COUNT(`holat`, `bolim`) FROM `ustun` WHERE `holat` = 1 AND `bolim` = 3

Chota xatolik bervotiyu??
Menga 3bolimdagi holati 1 bolgan barcha malumotlarni sanash kerak ...

uDesign
#55 10:37:33, 31 May 2020

Tayota, # Tayota (31.05.2020 / 00:04)
SELECT COUNT(`holat`, `bolim`) FROM `ustun` WHERE `holat` = 1 AND `bolim` = 3

Chota xatolik bervotiyu??
Menga 3bolimdagi holati 1 bolgan barcha malumotlarni sanash kerak ...COUNT( `id`) qiling