Mavzu: MySQL so'rovlar bo'yicha yordam (INTERNET VA DASTURLASH/Sayt yaratishda yordam) QaLQoN (30 Jan 2017 08:14) Bu mavzuda kimda kim MySQL so'rovlar bilan muammoga duch kelgan bo'lsa qoldirishi mumkin.
Savol bilan birga baza strukturasini keltirilsa savolga javob berish yana ham tezlashadi.
Boshladik.. Viruzbek (30 Jan 2017 08:37) Bunday mavzu bor adashmasam QaLQoN (30 Jan 2017 08:44) --Javob-- Viruzbek (30 Jan 2017 08:37): Bunday mavzu bor adashmasam ---------- Viruzbek, bumaganligi uchun ham ochdim Tayotabek (30 Jan 2017 16:27) strukturasini manashetga tushunmadim nima bu? QaLQoN (30 Jan 2017 16:31) --Javob-- Tayotabek (30 Jan 2017 16:27): strukturasini manashetga tushunmadim nima bu? ---------- Tayotabek, sodda qilip aytganda usha sahifani scren qip kursatish Tayotabek (30 Jan 2017 17:49) Menda bita savol bor u menimcha sqlga kiradi.

John 620 orginal skriptni ishlatim skriptni xechnimasini özgartirmadim faqat instal qildim tamom. Xulas ösha skriptni ishlatgan saytmi sayt/forum da mavzu ochib bömayapti ochaman disam qoidalarni yozvoti roziman dib mavzu nomi 1# pastni yozsam yana qoidalarni yozib z qivoti 5 6ta qildim baribir bömadi bita döstmdan sörasam forum papkasiga sql köd yozish kerak devoti.
=
menimcha pastm mavzuga tög'ri keladi Prince_Abdul (1 Apr 2017 09:05) Balans reyting di sql so'rovini Kim biladi walterhack (1 Apr 2017 10:08) Menda ham muommo script o'rnatdim endi bazaga ma'lumot yozishni bilmayapman Tayotabek (1 Apr 2017 21:18) Id2 da id7gacha userni udalit qilish sqlsi qanaqa?
John 620:) Bez pravil babnik (1 Apr 2017 21:52) Id1ni log parolini spldan koradimi?? Bez pravil babnik (1 Apr 2017 21:54) --Javob-- walterhack (1 Apr 2017 10:08): Menda ham muommo script o'rnatdim endi bazaga ma'lumot yozishni bilmayapman ---------- walterhack, man orgataman:Bitta spl ochasz oshani koprivat qb paroli bn berseyz install qb beraman 5ta 6ta + i raxmat ketadi xolos szdan ;) rtyfgh (2 Apr 2017 19:10) Sayt yaratiw ucun nma qiliw kere LoysonSity (10 Apr 2017 21:28) :koz: nima u ozi mysql Bez pravil babnik (10 Apr 2017 22:00) --Javob-- LoysonSity (10 Apr 2017 21:28): :koz: nima u ozi mysql ---------- LoysonSity, SayTizNi MaluMot BazaSi Da Bez pravil babnik (10 Apr 2017 22:01) SizLar Ga SaVol id-1 ni MySQL BazaDan QanDe QlaDi? LoysonSity (10 Apr 2017 22:04) Hostingda boladimi u manga hosting keridide Tayotabek (10 Apr 2017 22:05) --Javob-- Bez pravil babnik (10 Apr 2017 22:01): SizLar Ga SaVol id-1 ni MySQL BazaDan QanDe QlaDi? ---------- Bez pravil babnik, nima qimoqchisiz? Tushuntiribroq yozing Bez pravil babnik (10 Apr 2017 22:07) --Javob-- Tayotabek (10 Apr 2017 22:05): Bez pravil babnik, nima qimoqchisiz? Tushuntiribroq yozing ---------- Tayotabek, SayTGa id-1QmoQcHiMan Tayotabek (10 Apr 2017 22:11) --Javob-- Bez pravil babnik (10 Apr 2017 22:07): Tayotabek, SayTGa id-1QmoQcHiMan ---------- Bez pravil babnik, install qisez admin özi shundog'am id 1 böladi. Agar -1 ni aytayapgan bösez. Mysql bazaga kirib bazezga kiras users ustuniga kiras va id degan joydan yoki name deganga kirib xoxlagan userni id pid balo batarlarni özgartiras tamom) Bez pravil babnik (10 Apr 2017 22:22) --Javob-- Tayotabek (10 Apr 2017 22:11): Bez pravil babnik, install qisez admin özi shundog'am id 1 böladi. Agar -1 ni aytayapgan bösez. Mysql bazaga kirib bazezga kiras users ustuniga kiras va id degan joydan yoki name deganga kirib xoxlagan userni id pid balo batarlarni özgartiras tamom) ---------- Tayotabek, Axa RaxMat Id-1 KereGiDi RaxMat Tayotabek (10 Apr 2017 22:26) MySQL — bu eng mashhur va juda ko‘p
foydalaniladigan ma’lumotlar bazasini boshqarish
tizimi(MBBT) hisoblanadi. Bu tizim juda katta
ma’lumotlar bilan ishlash uchun yaratilmagan,
aksincha biroz kichik hajmdagi bazalar bilan katta
tezlikda ishlash uchun yaratilgan. Uning asosiy
ishlash doirasi, saytlar hisoblanadi. Hozirgi kunda
juda ko‘p sayt va bloklarning ma’lumotlari aynan
shu MBBT saqlanadi.
Ho‘sh, saytlarning nimalari bazada saqlanishi
mumkin? Dastlab, ma’lumotlar saqlash uchun
dasturchilar fayllardan foydalanishgan, ya’ni fayl
ochilib kerakli ma’lumotlar u yerga saqlanib,
kerakli paytda chaqirib ishlatilgan. Keyinchalik
fayllardan voz kechilib(noqulayliklar yuzaga
kelgan, ya’ni faylni ochish, o‘qish, yopish,.. ko‘p
vaqtni olib qo‘ygan, u yerdan qidirish, xullas juda
ko‘p), ma’lumotlar bazasiga o‘tilgan. Bazada
saytdagi maqolalar, sayt foydalanuvchilari
haqidagi ma’lumotlar, sayt kontentlari, qoldirilgan
kommentariyalar, savol-javoblar, hisoblagich
natijalari va shunga o‘xshash juda ko‘p
ma’lumotlar saqlanadi. MySQL shunday
ma’lumotlarni o‘zida saqlaydi.
MySQL — juda katta tezlikda ishlovchi va qulay
hisoblanadi. Bu tizimda ishlash juda sodda va uni
o‘rganish qiyinchilik tug‘dirmaydi.
MySQL tizimi tcx kompaniyasi tomonidan,
ma’lumotlarni tez qayta ishlash uchun korxona
miqyosida ishlatishga yaratilgan. Keyinchalik
ommalashib, saytlarning asosiy bazasi sifatida
yoyildi.
So‘rovlar SQL tili orqali amalga oshiriladi. Bu
MBBT relyatsion ma’lumotlar baza hisoblanadi.
Bu degani baza jadvallar, jadvallar esa
ustunlardan tashkil topgandir.
MySQL MBBTi 2 xil turdagi litsenziyaga ega.
Birinchisi tekin, ya’ni MYSQLni ko‘chirib olish va
ishlatish hech qanday harajat talab qilmaydi va
GPL(GNU Public Licenseb, GNU) litsenziyasiga
asoslanadi. Ikkinchi turi, GPL shartiga ko‘ra, agar
siz MySQL kodlarini biror dasturingizda
ishlatsangiz, bu dasturingiz ham GPL(tekin)
bo‘lishi kerak. Bu esa dasturchiga to‘g‘ri kelmaydi.
Shuning uchun, bu dasturingizni pullik qilishingiz
uchun MySQL pullik litsenziyasini sotib olishingiz
kerak. Tayotabek (10 Apr 2017 22:27) MySQL logotipi delfin hisoblanadi. Bu delfinni ismi
«Sakila»dir. Bu logotipni OpenSource
tuzuvchilaridan biri Ambrose Twebaze ga
tegishlidir.
MySQL juda ko‘p operatsion tizimlar bilan ishlay
oladi. Bularni yozadigan bo‘lsam: AIX, BSDi,
FreeBSD, HP-UX, Linux, Mac OS X, NetBSD,
OpenBSD, OS/2 Warp, SGI IRIX, Solaris,
SunOS, UnixWare, Windows 95, Windows
98, Windows NT, Windows 2000, Windows
XP, Windows Server 2000, Windows Vista,
Windows 7,…
MySQL shved korxonasi MySQl AB ga tegishli
bo‘lgan, keyinchalik SUN firmasi MySQL ni o‘ziniki
qilib olgan. Bir necha yil oldin esa, gigant
korxonalardan biri Oracle, SUN firmasini sotib
oldi va hozirda MySQL Oracle firmasi mahsuloti
sifatida chiqib kelmoqda. Bu bir hisobda Microsoft
SQL Server ga katta raqobatdosh ekanligini
anglatadi.
MySQL bir necha serverlarning bir qismi
hisoblanadi. Misol uchun, WAMP, AppServ,
LAMP, Denwer,… Kliyentlar MySQL serveriga
ma’lum bir kutubxonalar orqali ulanadi. MySQL ga
quyidagi dasturlash tillari ulanib ishlashi mumkin:
Delphi, C, C++, Java, Perl, Php, Python, Ruby
va boshqalar.
Manba. *esmda yöq * MoRGaN (12 May 2017 21:21) butun boshli bazadagi textlardan malum bir "so'z" ni olib o'chirib tashlash so'rov kodini bormi yozib yuboringlar. BahhTeeUz (12 May 2017 22:24) --Javob-- MoRGaN (12 May 2017 21:21): butun boshli bazadagi textlardan malum bir "so'z" ni olib o'chirib tashlash so'rov kodini bormi yozib yuboringlar. ---------- MoRGaN, phpmyadmin orqalimi yoki saytmi? MoRGaN (12 May 2017 23:37) --Javob-- BahhTeeUz (12 May 2017 22:24): MoRGaN, phpmyadmin orqalimi yoki saytmi? ---------- Bahh Tee, phpmyadmin orqali umuman olgan mysql kod bo'lsa bo'ldi!!! BahhTeeUz (12 May 2017 23:56) --Javob-- MoRGaN (12 May 2017 23:37): Bahh Tee, phpmyadmin orqali umuman olgan mysql kod bo'lsa bo'ldi!!! ---------- MoRGaN, butun bazadagi bir so'z bo'lsa bazadan bekap olib, text redaktorda o'zgartirib olishingiz mumkin. Agar bitta jadvalda bo'lsa
UPDATE jadval SET article = REPLACE(article, 'soz', 'yangisoz');
adashmasam MoRGaN (13 May 2017 00:00) --Javob-- BahhTeeUz (12 May 2017 23:56): MoRGaN, butun bazadagi bir so'z bo'lsa bazadan bekap olib, text redaktorda o'zgartirib olishingiz mumkin. Agar bitta jadvalda bo'lsa
UPDATE jadval SET article = REPLACE(article, 'soz', 'yangisoz');
adashmasam ---------- Bahh Tee, bitta tablitsa!! pasdegini sinab kuray rahmat! BahhTeeUz (13 May 2017 00:04) --Javob-- MoRGaN (13 May 2017 00:00): Bahh Tee, bitta tablitsa!! pasdegini sinab kuray rahmat! ---------- MoRGaN, siz bir jadvaldagi dengda, buning turlari ko'p, o'xshamasa aytavering :koz: MoRGaN (13 May 2017 00:08) --Javob-- BahhTeeUz (13 May 2017 00:04): MoRGaN, siz bir jadvaldagi dengda, buning turlari ko'p, o'xshamasa aytavering :koz: ---------- Bahh Tee, o'xshamadi haa bitta jadvaldagi? MoRGaN (13 May 2017 00:11) bo'ldi !!! rahmat BahhTeeUz (13 May 2017 00:15) --Javob-- MoRGaN (13 May 2017 00:11): bo'ldi !!! rahmat ---------- MoRGaN, bo'ldimi? MoRGaN (13 May 2017 00:21) --Javob-- BahhTeeUz (13 May 2017 00:15): MoRGaN, bo'ldimi? ---------- Bahh Tee, haa lekin simvolni yuqotib bulmayapti  = Â
BahhTeeUz (13 May 2017 01:01) --Javob-- MoRGaN (13 May 2017 00:21): Bahh Tee, haa lekin simvolni yuqotib bulmayapti  = Â
---------- MoRGaN, bunisini bilmadim, ochig'i Viruzbek (4 Aug 2017 00:30) Mysql sorov orqali udalit bolib ketgan id raqam tiklash kodini yozib yuboringlar dcms mavzusida bor edi topa olmadim BahhTeeUz (4 Aug 2017 00:33) --Javob-- Viruzbek (4 Aug 2017 00:30): Mysql sorov orqali udalit bolib ketgan id raqam tiklash kodini yozib yuboringlar dcms mavzusida bor edi topa olmadim ---------- Viruzbek, balkim o'rin almashtirishdur? Viruzbek (4 Aug 2017 00:37) --Javob-- BahhTeeUz (4 Aug 2017 00:33): Viruzbek, balkim o'rin almashtirishdur? ---------- Bahh Tee, xa shunday desa xam boladi BahhTeeUz (4 Aug 2017 01:34) --Javob-- Viruzbek (4 Aug 2017 00:37): Bahh Tee, xa shunday desa xam boladi ---------- Viruzbek, update `user` set `id`='yangi' where `id`='hozirgi' limit 1; u2b3ki (4 Aug 2017 13:55) manda savol borde shu desela yangu userlarni qandaya qoshsak boladi sorovlar orqali togrirogi mysql sorov orqali shif kodini qanday togirlimiz BahhTeeUz (4 Aug 2017 14:03) --Javob-- u2b3ki (4 Aug 2017 13:55): manda savol borde shu desela yangu userlarni qandaya qoshsak boladi sorovlar orqali togrirogi mysql sorov orqali shif kodini qanday togirlimiz ---------- u2b3ki, shifrini men bilmimanu, borini ko'chirib qo'yaman :-) doniyor (4 Aug 2017 14:20) --Javob-- BahhTeeUz (4 Aug 2017 14:03): u2b3ki, shifrini men bilmimanu, borini ko'chirib qo'yaman :-) ---------- Bahh Tee, savol. yangu user lrsa id 2 bolib royhatdan otish kere
.
ushani mysql sorovmi yozb berin blsez.
.
hozr saytmda id 90 id 345 hammaga jarhl id neryapdi u2b3ki (4 Aug 2017 14:36) --Javob-- BahhTeeUz (4 Aug 2017 14:03): u2b3ki, shifrini men bilmimanu, borini ko'chirib qo'yaman :-) ---------- Bahh Tee, masalan saytda xozi faqat id1 bor va bizaga id11gacha royhatdan mysql sorov orqali qilishimiz kerak shuni qanday qilamiz manosida etgandim mayli xamma parol bir xil bolsin bunda tape, disc, notif sorovlarigayam update boradimi? BahhTeeUz (4 Aug 2017 15:59) --Javob-- u2b3ki (4 Aug 2017 14:36): Bahh Tee, masalan saytda xozi faqat id1 bor va bizaga id11gacha royhatdan mysql sorov orqali qilishimiz kerak shuni qanday qilamiz manosida etgandim mayli xamma parol bir xil bolsin bunda tape, disc, notif sorovlarigayam update boradimi? ---------- u2b3ki, ular umumiy foydalanuvchi kirganda belgilanadi doniyor (4 Aug 2017 19:38) --Javob-- BahhTeeUz (4 Aug 2017 15:59): u2b3ki, ular umumiy foydalanuvchi kirganda belgilanadi ----------
ALTER TABLE `user` ADD `balans`
DECIMAL(11,2) NOT NULL DEFAULT
'0.00' COMMENT 'Баланс
CREATE TABLE IF NOT EXISTS
`worldkassa` ( `id` int(11) unsigned
NOT NULL AUTO_INCREMENT
COMMENT 'ID платежа (Внутренний
ID)', `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL
COMMENT 'ID платежа в
Worldkassa', `time` int(11) unsigned
NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11) unsigned
DEFAULT '0' COMMENT 'Время
оплаты', `summa` decimal(11,2) NOT
NULL DEFAULT '0.00' COMMENT
'Сумма', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT
CHARSET=utf8
COMMENT='Статистика платежей
через

.
.
qayerda hatolik bor dos doniyor (4 Aug 2017 20:21) user ID sni chaqedgon kod qandey yozlardi {user_id}
shundemi BahhTeeUz (4 Aug 2017 20:28) --Javob-- doniyor (4 Aug 2017 19:38):
ALTER TABLE `user` ADD `balans`
DECIMAL(11,2) NOT NULL DEFAULT
'0.00' COMMENT 'Баланс
CREATE TABLE IF NOT EXISTS
`worldkassa` ( `id` int(11) unsigned
NOT NULL AUTO_INCREMENT
COMMENT 'ID платежа (Внутренний
ID)', `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL
COMMENT 'ID платежа в
Worldkassa', `time` int(11) unsigned
NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11) unsigned
DEFAULT '0' COMMENT 'Время
оплаты', `summa` decimal(11,2) NOT
NULL DEFAULT '0.00' COMMENT
'Сумма', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT
CHARSET=utf8
COMMENT='Статистика платежей
через

.
.
qayerda hatolik bor dos ---------- doniyor, баланс'; bo'lishi lozim doniyor (4 Aug 2017 22:27) --Javob-- BahhTeeUz (4 Aug 2017 20:28): doniyor, баланс'; bo'lishi lozim ---------- Bahh Tee, snab krayci doniyor (4 Aug 2017 22:32) --Javob-- BahhTeeUz (4 Aug 2017 20:28): doniyor, баланс'; bo'lishi lozim ---------- Bahh Tee, . ALTER TABLE `user` ADD `balans`
DECIMAL(11,2)
So`rov amalga oshmadi !
2. CREATE TABLE IF NOT EXISTS
`worldkassa` ( `id` int(11) unsigned
NOT NULL AUTO_INCREMENT
COMMENT 'ID платежа (Внутренний
ID)', `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL
COMMENT 'ID платежа в
Worldkassa', `time` int(11) unsigned
NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11) unsigned
DEFAULT '0' COMMENT 'Время
оплаты', `summa` decimal(11,2) NOT
NULL DEFAULT '0.00' COMMENT
'Сумма', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT
CHARSET=utf8
COMMENT='Статистика платежей
через
So`rov amalga oshmadi !
.
.
bolmadi BahhTeeUz (4 Aug 2017 22:34) --Javob-- doniyor (4 Aug 2017 22:32): Bahh Tee, . ALTER TABLE `user` ADD `balans`
DECIMAL(11,2)
So`rov amalga oshmadi !
2. CREATE TABLE IF NOT EXISTS
`worldkassa` ( `id` int(11) unsigned
NOT NULL AUTO_INCREMENT
COMMENT 'ID платежа (Внутренний
ID)', `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL
COMMENT 'ID платежа в
Worldkassa', `time` int(11) unsigned
NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11) unsigned
DEFAULT '0' COMMENT 'Время
оплаты', `summa` decimal(11,2) NOT
NULL DEFAULT '0.00' COMMENT
'Сумма', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT
CHARSET=utf8
COMMENT='Статистика платежей
через
So`rov amalga oshmadi !
.
.
bolmadi ---------- doniyor,
ALTER TABLE `user` ADD `balans`
DECIMAL(11,2) NOT NULL DEFAULT
'0.00' COMMENT 'Баланс' ;
CREATE TABLE IF NOT EXISTS
`worldkassa` ( `id` int(11) unsigned
NOT NULL AUTO_INCREMENT
COMMENT 'ID платежа (Внутренний
ID)', `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL
COMMENT 'ID платежа в
Worldkassa', `time` int(11) unsigned
NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11) unsigned
DEFAULT '0' COMMENT 'Время
оплаты', `summa` decimal(11,2) NOT
NULL DEFAULT '0.00' COMMENT
'Сумма', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT
CHARSET=utf8
COMMENT='Статистика платежей
через' ; doniyor (4 Aug 2017 22:45) --Javob-- BahhTeeUz (4 Aug 2017 22:34): doniyor,
ALTER TABLE `user` ADD `balans`
DECIMAL(11,2) NOT NULL DEFAULT
'0.00' COMMENT 'Баланс' ;
CREATE TABLE IF NOT EXISTS
`worldkassa` ( `id` int(11) unsigned
NOT NULL AUTO_INCREMENT
COMMENT 'ID платежа (Внутренний
ID)', `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL
COMMENT 'ID платежа в
Worldkassa', `time` int(11) unsigned
NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11) unsigned
DEFAULT '0' COMMENT 'Время
оплаты', `summa` decimal(11,2) NOT
NULL DEFAULT '0.00' COMMENT
'Сумма', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT
CHARSET=utf8
COMMENT='Статистика платежей
через' ; ---------- Bahh Tee, xato bari shu kodni boshqach yozsa bolmaydimi ? MrFox (6 Aug 2017 19:29) Nima sababdan bunday xato chiqadi? Profil mehmonlari modini õrnatayotgandim BahhTeeUz (8 Aug 2017 09:33) --Javob-- MrFox (6 Aug 2017 19:29): Nima sababdan bunday xato chiqadi? Profil mehmonlari modini õrnatayotgandim ---------- MrFox, bazada bo'limi mavjud emas ya'ni php_bb_view_profile adashmasam MrFox (22 Aug 2017 16:47) Bazani boshqa hostingga kõchirgandim kirillcha sõzlar buzulib ketdi.
Привет! Нормально. А как сама
Tõğrilasa bõladimi? DreaMs_WorLD (22 Aug 2017 19:15) --Javob-- MrFox (22 Aug 2017 16:47): Bazani boshqa hostingga kõchirgandim kirillcha sõzlar buzulib ketdi.
Привет! Нормально. А как сама
Tõğrilasa bõladimi? ---------- MrFox, agar bazadagi sozlar o`zi o`zgarib ketmagan bo`sa ha agar o`zgargan bo`sa yo`q...
PS: to`girlash uchun charset utf-8 ko`rinishida bo`lishi kere MasterPRO (1 Sep 2017 15:06) Userni blokdan chiqarish kodi qanday edi Adwcmsda Akbarali (6 Sep 2017 13:30) user foydalanuvchni qanday qo'shadi mysqlga john emas dcms ham emas NafisGroup (6 Sep 2017 13:32) --Javob-- Akbarali (6 Sep 2017 13:30): user foydalanuvchni qanday qo'shadi mysqlga john emas dcms ham emas ---------- Akbarali, MYSQL ICHIDAGI USER QATORINI SCRENINI JONAT KORAMIZ CyberBoy (6 Sep 2017 13:36) --Javob-- Akbarali (6 Sep 2017 13:30): user foydalanuvchni qanday qo'shadi mysqlga john emas dcms ham emas ---------- Akbarali, mysql fayliga link bering uzmastersuzmasters (6 Sep 2017 13:42) --Javob-- Akbarali (6 Sep 2017 13:30): user foydalanuvchni qanday qo'shadi mysqlga john emas dcms ham emas ---------- Akbarali, registratsiya orqali Akbarali (6 Sep 2017 13:43) --Javob-- uzmastersuzmasters (6 Sep 2017 13:42): Akbarali, registratsiya orqali ---------- RARE, registr.php ishlamayaptida uzmastersuzmasters (6 Sep 2017 13:45) --Javob-- Akbarali (6 Sep 2017 13:43): RARE, registr.php ishlamayaptida ---------- Akbarali, shuni tugrilang Akbarali (6 Sep 2017 13:46) --Javob-- uzmastersuzmasters (6 Sep 2017 13:45): Akbarali, shuni tugrilang ---------- RARE, johncms yoki dcms bo'lganda to'g'irlardim afsus unday emasda Akbarali (6 Sep 2017 13:47) --Javob-- NafisGroup (6 Sep 2017 13:32): Akbarali, MYSQL ICHIDAGI USER QATORINI SCRENINI JONAT KORAMIZ ---------- SerMenfi, shular bor ekan
id int(11) not null auto_increment PRI
username varchar(50) not null
password varchar(32) not null
referer varchar(20) not null
country varchar(2) not null
visits int(11) not null default '0'
referalvisits int(10) not null default '0'
paid float(12, 2) not null default '0.00'
ball float(12, 1) not null default '0.0'
email varchar(50) null
referer2 varchar(11) null
name varchar(40) not null
ip varchar(15) not null
wmid varchar(12) not null
pemail varchar(20) not null
qiwi varchar(15) not null
yandex varchar(15) not null
payeer varchar(15) not null
views_mails int(11) not null default '0' MUL
task int(11) not null default '0' MUL
tests int(11) not null default '0'
rep_task int(11) not null
referals int(11) not null default '0' MUL
referals2 int(11) not null default '0'
referalvisits2 int(11) not null default '0'
views_mails_ref int(11) not null default '0'
views_mails_ref2 int(11) not null default '0'
task_referals int(11) not null default '0'
task_referals2 int(11) not null default '0'
m_cl_ref float(9, 4) unsigned not null default '0.0000'
m_cl_ref2 float(9, 4) unsigned not null default '0.0000'
m_mail_ref float(9, 4) unsigned not null default '0.0000'
m_mail_ref2 float(9, 4) unsigned not null default '0.0000'
m_ts_ref float(9, 4) unsigned not null default '0.0000'
m_ts_ref2 float(9, 4) unsigned not null default '0.0000'
kon_kol int(11) not null default '0'
kon_sum float(9, 2) unsigned not null default '0.00'
kon_kol_you int(11) not null default '0'
kon_sum_you float(9, 2) unsigned not null default '0.00'
ref_percent int(3) not null default '0'
ref_per_all int(3) not null default '0'
money double(9, 4) not null default '0.0000'
money_cr double(9, 4) not null default '0.0000'
joindate varchar(10) not null
user_status varchar(5) not null MUL
stat varchar(255) not null default '0~0~0:0:0:0:0:0:0~0~0:0:0:0:0:0:0~0~0:0:0:0:0:0:0~0~0:0:0:0:0:0:0~'
blockip varchar(15) not null
avatar varchar(16) not null default 'no.gif'
blockpay varchar(15) null default '0'
lastlogdate varchar(15) not null MUL
lastvxod int(11) not null
lastuser varchar(50) not null
lastiplog varchar(15) not null
timereg int(11) not null
wmlogin int(1) not null default '0'
lastpay varchar(15) null default '0'
ban_forum int(1) not null default '0'
post_forum int(11) not null
ball_status tinyint(1) unsigned not null default '1'
ball_date int(10) unsigned not null default '0'
doxod float(9, 4) not null default '0.0000' MUL
newrefbuck int(3) not null default '0'
lastmail int(11) not null
k_ref tinyint(1) unsigned not null default '1'
cames varchar(25) not null
news int(1) not null default '0'
rod int(1) not null
family int(1) not null
pol int(1) not null
bday int(4) not null
captcha int(11) not null Z_e_V_e_R (6 Sep 2017 14:10) Menda duel ishlamayapdi sqlisini zalit qildim ham lekim mening duellarimga bossam turibdi lekin sayt.ru/duel/index.phpda hozircha ovoz berilmagani uchun faol duellar yo'q diyapdi bu nimadan YNWA (11 Sep 2017 02:15) Mehmonlar Iwlamayaoti (Gosti) korinmayapti qande tugrilasa boladi Mc_jas (12 Sep 2017 00:48) Manga reyting kodi kerak saytda utgan kunni xoxlagancha qiliw Tayotabek (10 Dec 2017 21:10) Savol.
Bita özgaruvchiga 2ta ustuni chiqarish kerak.
$uz = mysql_query("SELECT * FROM `users` where `user_id` = '$user_id' order by `id` ASC limit $start, $kmess);
.
$uzbek = mysql_query("SELECT * FROM `news` where `user_id` = '$user_id' order by `id` ASC limit $start, $kmess);
.
Manashu 2ta mysqlni bita özgaruvchiga yozish kerak yordam .
Bunaqa qildim bömadi
$uza = mysql_query("SELECT * FROM `users`,`news` where `user_id` = '$user_id' order by `id` ASC limit $start, $kmess); MeGaBoY (28 Dec 2017 18:52) Smile ochirish kodini yozib beringlar Tayotabek (2 Jan 2018 00:34) unsigned qöshilsa nima bölardi malumot auto idga öxshab kirarmidi yo boshqamidi? ChaqMoq (9 Feb 2018 21:37) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `obmennik_files`;
CREATE TABLE IF NOT EXISTS `obmennik_files` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`id_dir` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`ras` varchar(36) NOT NULL,
`type` varchar(64) NOT NULL,
`time` int(11) NOT NULL,
`time_last` int(11) NOT NULL,
`size` int(11) NOT NULL,
`k_loads` int(11) default '0',
`opis` text NOT NULL,
PRIMARY KEY (`id`)
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `obmennik_dir`;
CREATE TABLE IF NOT EXISTS `obmennik_dir` (
`id` int(11) NOT NULL auto_increment,
`num` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`ras` varchar(128) NOT NULL,
`maxfilesize` int(11) NOT NULL,
`dir` varchar(512) NOT NULL default '/',
`dir_osn` varchar(512) default '/',
`upload` set('1','0') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `num` (`num`),
KEY `dir` (`dir`(333))
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статьи' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `loads`;
CREATE TABLE IF NOT EXISTS `loads` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`loads` int(11) NOT NULL,
`path` varchar(128) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `loads_komm`;
CREATE TABLE IF NOT EXISTS `loads_komm` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(512) NOT NULL,
`id_user` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `file` (`file`),
KEY `size` (`size`)
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (4, 'Загрузки', '/loads/', 'loads/count.php', 6);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);


DROP TABLE IF EXISTS `obmennik_dir
`;

CREATE TABLE IF NOT EXISTS `obmennik_dir` (
DROP TABLE IF EXISTS `obmennik_files`;

DROP TABLE IF EXISTS `obmennik_files`;


CREATE TABLE IF NOT EXISTS `obmennik_files` (


DROP TABLE IF EXISTS `loads
`;

CREATE TABLE IF NOT EXISTS `loads` (


`loads` int(11) NOT NUL
L,

DROP TABLE IF EXISTS `loads_komm`;


CREATE TABLE IF NOT EXISTS `loads_komm`
(

CREATE TABLE IF NOT EXISTS `loads_komm` (

DROP TABLE IF EXISTS `loads_komm`;

`loads` int(11) NOT NULL,
CREATE TABLE IF NOT EXISTS `loads` (

DROP TABLE IF EXISTS `loads`;

CREATE TABLE IF NOT EXISTS `obmennik_files` (

DROP TABLE IF EXISTS `obmennik_files`;
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (4, 'Загрузки', '/loads/', 'loads/count.php', 6);


Do'stlar mana shu sql ni qanday bitta sql zabros qilib bazaga jo'natsam bo'ladi ortiqcha joylarini olib kamchiliklarini to'g'irlab bitta yaxlit sql zabros qilib beringlar biladiganlar bo'lsa iltimos STRaKER (10 Feb 2018 00:15) --Javob-- ChaqMoq (9 Feb 2018 21:37): ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `obmennik_files`;
CREATE TABLE IF NOT EXISTS `obmennik_files` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`id_dir` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`ras` varchar(36) NOT NULL,
`type` varchar(64) NOT NULL,
`time` int(11) NOT NULL,
`time_last` int(11) NOT NULL,
`size` int(11) NOT NULL,
`k_loads` int(11) default '0',
`opis` text NOT NULL,
PRIMARY KEY (`id`)
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `obmennik_dir`;
CREATE TABLE IF NOT EXISTS `obmennik_dir` (
`id` int(11) NOT NULL auto_increment,
`num` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`ras` varchar(128) NOT NULL,
`maxfilesize` int(11) NOT NULL,
`dir` varchar(512) NOT NULL default '/',
`dir_osn` varchar(512) default '/',
`upload` set('1','0') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `num` (`num`),
KEY `dir` (`dir`(333))
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статьи' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `loads`;
CREATE TABLE IF NOT EXISTS `loads` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`loads` int(11) NOT NULL,
`path` varchar(128) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `loads_komm`;
CREATE TABLE IF NOT EXISTS `loads_komm` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(512) NOT NULL,
`id_user` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `file` (`file`),
KEY `size` (`size`)
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (4, 'Загрузки', '/loads/', 'loads/count.php', 6);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);


DROP TABLE IF EXISTS `obmennik_dir
`;

CREATE TABLE IF NOT EXISTS `obmennik_dir` (
DROP TABLE IF EXISTS `obmennik_files`;

DROP TABLE IF EXISTS `obmennik_files`;


CREATE TABLE IF NOT EXISTS `obmennik_files` (


DROP TABLE IF EXISTS `loads
`;

CREATE TABLE IF NOT EXISTS `loads` (


`loads` int(11) NOT NUL
L,

DROP TABLE IF EXISTS `loads_komm`;


CREATE TABLE IF NOT EXISTS `loads_komm`
(

CREATE TABLE IF NOT EXISTS `loads_komm` (

DROP TABLE IF EXISTS `loads_komm`;

`loads` int(11) NOT NULL,
CREATE TABLE IF NOT EXISTS `loads` (

DROP TABLE IF EXISTS `loads`;

CREATE TABLE IF NOT EXISTS `obmennik_files` (

DROP TABLE IF EXISTS `obmennik_files`;
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (4, 'Загрузки', '/loads/', 'loads/count.php', 6);


Do'stlar mana shu sql ni qanday bitta sql zabros qilib bazaga jo'natsam bo'ladi ortiqcha joylarini olib kamchiliklarini to'g'irlab bitta yaxlit sql zabros qilib beringlar biladiganlar bo'lsa iltimos ---------- ChaqMoq, birinchi ikki qatorini olib tashlasez bo'ldikan, yoki boshlanish qisminiyam qo'shsez butun bo'lardi keyin phpmyadmin dan sql degan joyiga vstavit qib jo'natasiz tamom DjHuSo (10 Feb 2018 09:03) CREATE TABLE IF NOT EXISTS `bet_us` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL,
`match_id` INT(11) NOT NULL,
`bet` VARCHAR(15) NOT NULL,
`summ` INT(11) NOT NULL,
`win` INT(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Дамп данных таблицы `bet_us`
--

INSERT INTO `bet_us` (`id`, `user_id`, `match_id`, `bet`, `summ`, `win`) VALUES
(1, 1, 1, 'П1', 0, 1),
(2, 1, 2, 'П2', 0, 1),
(3, 1, 3, 'П1', 0, 1),
(4, 3, 3, 'П2', 0, 0),
(5, 3, 3, 'П1', 0, 1);

P1 bilan p2 ni aloxida sanatish kerak shuni qanday sanatsam bo'ladi yordam bervoringlar Tayotabek (10 Feb 2018 16:15) --Javob-- DjHuSo (10 Feb 2018 09:03): CREATE TABLE IF NOT EXISTS `bet_us` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL,
`match_id` INT(11) NOT NULL,
`bet` VARCHAR(15) NOT NULL,
`summ` INT(11) NOT NULL,
`win` INT(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Дамп данных таблицы `bet_us`
--

INSERT INTO `bet_us` (`id`, `user_id`, `match_id`, `bet`, `summ`, `win`) VALUES
(1, 1, 1, 'П1', 0, 1),
(2, 1, 2, 'П2', 0, 1),
(3, 1, 3, 'П1', 0, 1),
(4, 3, 3, 'П2', 0, 0),
(5, 3, 3, 'П1', 0, 1);

P1 bilan p2 ni aloxida sanatish kerak shuni qanday sanatsam bo'ladi yordam bervoringlar ---------- DjHuSo, öyin natijasi aloxida aloxida ustunga tushadigan qib körmadizmi misol
real vs barsa
natija 2:3
`jamoa1` 2
`jamoa2` 3 DjHuSo (10 Feb 2018 17:36) --Javob-- Tayotabek (10 Feb 2018 16:15): DjHuSo, öyin natijasi aloxida aloxida ustunga tushadigan qib körmadizmi misol
real vs barsa
natija 2:3
`jamoa1` 2
`jamoa2` 3 ---------- Tayotabek, yo'q Viruzbek (28 May 2018 10:30) Mysql sorovi orqali user udalit qilish kodini yozib beringlar bilganlar Tayotabek (28 May 2018 22:57) --Javob-- Viruzbek (28 May 2018 10:30): Mysql sorovi orqali user udalit qilish kodini yozib beringlar bilganlar ---------- Viruzbek, mysql_query("DELETE FROM `user` where `id` = 'udalit qilinadigan id';");
[b]8.4 daqiqa sekund dan so'ng qo'shdi...[/b]
Savol bor edi. Doim sql ködlarni köramanu ammo ularni aniq nima vazifa bajarishini bilmayman.
DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
.
Bu yerda `news` degan ustun ochilsin deyilyapti. Lekin ndga 2 marta? Drop va create da nima uchun 2marta qilinyapti? BahhTeeUz (28 May 2018 23:00) --Javob-- Tayotabek (28 May 2018 22:57): Viruzbek, mysql_query("DELETE FROM `user` where `id` = 'udalit qilinadigan id';");
[b]8.4 daqiqa sekund dan so'ng qo'shdi...[/b]
Savol bor edi. Doim sql ködlarni köramanu ammo ularni aniq nima vazifa bajarishini bilmayman.
DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
.
Bu yerda `news` degan ustun ochilsin deyilyapti. Lekin ndga 2 marta? Drop va create da nima uchun 2marta qilinyapti? ---------- Tayotabek, drop bu õsha jadvalni ôchirsi, keyingisida esa yaratsin deyilagan! Tayotabek (28 May 2018 23:05) --Javob-- BahhTeeUz (28 May 2018 23:00): Tayotabek, drop bu õsha jadvalni ôchirsi, keyingisida esa yaratsin deyilagan! ---------- Bahh Tee, yana bir nima 1tasida IF EXISTS 2-da IF not EXISTS yana 1ta sql ködda umuman bular yöq. Bular nima vazifa bajaradi
.
Öchirisi -- yani ustun nomi shundaymi? BahhTeeUz (28 May 2018 23:17) --Javob-- Tayotabek (28 May 2018 23:05): Bahh Tee, yana bir nima 1tasida IF EXISTS 2-da IF not EXISTS yana 1ta sql ködda umuman bular yöq. Bular nima vazifa bajaradi
.
Öchirisi -- yani ustun nomi shundaymi? ---------- Tayotabek, õchirsin deganim n qolib ketibdi.
If not exists bu agar ushbu jadval bõlmasa deb boshlangan! Tayotabek (6 Jul 2018 15:18) Ustundan malumot qidirishda negadur muamo bölyapti.
`mod`='1' bölishi kerak demak
$a='%test%';
Select * from `ustun` where `mod`='1' and `s1` like '".$a."' or `s2` like '".$a."'
.
Mana köd ammo menda s1 va s2dagi men qidiryapgan sözdan boshqa sözlar ham chiqib ketyapti. Qayerda xato qilganman? BahhTeeUz (6 Jul 2018 16:05) --Javob-- Tayotabek (6 Jul 2018 15:18): Ustundan malumot qidirishda negadur muamo bölyapti.
`mod`='1' bölishi kerak demak
$a='%test%';
Select * from `ustun` where `mod`='1' and `s1` like '".$a."' or `s2` like '".$a."'
.
Mana köd ammo menda s1 va s2dagi men qidiryapgan sözdan boshqa sözlar ham chiqib ketyapti. Qayerda xato qilganman? ---------- Tayotabek, Select * from `ustun` where `mod`='1' AND (`s1` LIKE '".$a."' OR `s2` LIKE '".$a."') UzB__MaSTeR (6 Jul 2018 16:18) Http://Omadli.uz da shu sql bo'yicha link ishlamayapti
CREATE TABLE IF NOT EXISTS `vnim` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`nik_user` varchar(512) default NULL,
`time` int(11) NOT NULL,
`color` varchar(512) default NULL,
PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8; BahhTeeUz (6 Jul 2018 17:28) --Javob-- UzB__MaSTeR (6 Jul 2018 16:18): Http://Omadli.uz da shu sql bo'yicha link ishlamayapti
CREATE TABLE IF NOT EXISTS `vnim` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`nik_user` varchar(512) default NULL,
`time` int(11) NOT NULL,
`color` varchar(512) default NULL,
PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8; ---------- AkCenT_MaSTeR,
CREATE TABLE IF NOT EXISTS `vnim` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`nik_user` varchar(512) default NULL,
`time` int(11) NOT NULL,
`color` varchar(512) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; UzB__MaSTeR (6 Jul 2018 20:34) --Javob-- BahhTeeUz (6 Jul 2018 17:28): AkCenT_MaSTeR,
CREATE TABLE IF NOT EXISTS `vnim` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`nik_user` varchar(512) default NULL,
`time` int(11) NOT NULL,
`color` varchar(512) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; ---------- Bahh Tee, ishlamadi baribir aka Tayotabek (6 Jul 2018 20:36) Buni köringchi:)
CREATE TABLE `vnim` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`nik_user` varchar(512) NOT NULL,
`time` int(11) NOT NULL,
`color` varchar(512) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; MR_BaxtiyoR (16 Jul 2018 12:10) Mysql_num_rows bilan mysql_result ni farqi nimada? Tayotabek (16 Jul 2018 12:35) --Javob-- MR_BaxtiyoR (16 Jul 2018 12:10): Mysql_num_rows bilan mysql_result ni farqi nimada? ---------- MR_BaxtiyoR, result sanash uchun rows shunday malumot bormi yöq aniqlash uchun+sanash uchun ham MR_BaxtiyoR (16 Jul 2018 12:37) Mysql_num rows ni mysql_reslutni o'rnidan sanash uchun hamma vaqt qo'llasa bo'ladimi? BahhTeeUz (21 Jul 2018 12:52) --Javob-- MR_BaxtiyoR (16 Jul 2018 12:37): Mysql_num rows ni mysql_reslutni o'rnidan sanash uchun hamma vaqt qo'llasa bo'ladimi? ---------- MR_BaxtiyoR, qo'llasa bo'ladi! MR_BaxtiyoR (21 Jul 2018 13:05) Mysql_fetch_array va mysql_fetch_assoc orasidagi farq qanday?
Aniq tushunmadim
Mysql_fetch_array
Massiv holida chiqarishini tushundim MR_BaxtiyoR (21 Jul 2018 13:10) [php]
$query = mysql_query("CREATE TABLE `ibratli` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`text` text NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;");

if($query) {

echo '<div class="gmenu">o`rnatildi</div>';

} else {

echo '<div class="rmenu">O`rnatilmadi</div>';

}[/php]
Bu yerda agara baza ornatilgan bolsa
Bu baza ornatilgan
Deb yozuv chiqarish uchun nima qilish kerak BahhTeeUz (21 Jul 2018 13:25) --Javob-- MR_BaxtiyoR (21 Jul 2018 13:10): [php]
$query = mysql_query("CREATE TABLE `ibratli` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`text` text NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;");

if($query) {

echo '<div class="gmenu">o`rnatildi</div>';

} else {

echo '<div class="rmenu">O`rnatilmadi</div>';

}[/php]
Bu yerda agara baza ornatilgan bolsa
Bu baza ornatilgan
Deb yozuv chiqarish uchun nima qilish kerak ---------- MR_BaxtiyoR, if (!mysql_query("SELECT * FROM `table_name`")){ echo "Mavjud emas";} Janob Master (21 Dec 2018 21:18) bazadangi malumotlarni qanday chiqarib olamiz shuni urgatvorelar iloji bolsa Tayotabek (21 Dec 2018 23:00) [b]Janob Master,[/b] $a = mysql_fetch_assoc(mysql_query("SELECT * FROM `ustuniz` WHERE `kerakliqator` = 'iddi'"));
echo $a['birnima']; Smart (21 Dec 2018 23:10) [b]Tayotabek,[/b] Tentakmisiz?
Bu unaqa emasku.
Yozishdan avval oqib keyin yozingda :( Tayotabek (21 Dec 2018 23:18) --Javob-- Smart (21 Dec 2018 23:10): [b]Tayotabek,[/b] Tentakmisiz?
Bu unaqa emasku.
Yozishdan avval oqib keyin yozingda :( ---------- [b]Smart,[/b] Janob oshib ketgan. Xurmatingizni biling! Men savolga javob berdim. . . Savol bazadan ma'lumotni chiqarish edi. Men namuna körsatim. Agar xato qilgan bölsam marhamat. Xatoyimni körsating. Smart (21 Dec 2018 23:28) [b]Tayotabek,[/b] Xato bor.Lekin xatoyizni oxiz topng.Men userman va meni gapimni siz avval tushunib keyin yozing.Minus pils qmasdan :( Tayotabek (21 Dec 2018 23:34) --Javob-- Smart (21 Dec 2018 23:28): [b]Tayotabek,[/b] Xato bor.Lekin xatoyizni oxiz topng.Men userman va meni gapimni siz avval tushunib keyin yozing.Minus pils qmasdan :( ---------- [b]Smart,[/b] Men siz aytayotgan -+larni xali bosmadim. Men tepada bitta narsani qilmadim. U bölsa ham qatorni iddini. Agar shuni aytayapgan bölsangiz. (id qöyadigan qilib tög'irlab qöydim) Smart (21 Dec 2018 23:35) [b]Tayotabek,[/b] Ha aynan shuni aytgandim Davi_Uz (24 Mar 2019 17:58) bazaga sql fayli yuklasam sql fayldagi ruscha so'zlar "" "Рикардо Евсеев""""" saytda bunaqa bo'lib chiqayabdi bu nimadan?? Creators (26 Mar 2019 13:15) [b]Davi_Uz,[/b] menimcha kodirovkadan
saytingiz tepa qismiga
<meta charset="utf-8">
ni qo`shib ko`ring Davi_Uz (26 Mar 2019 13:45) [b]Creators,[/b] head.php gami? Creators (29 Mar 2019 12:29) [b]Davi_Uz,[/b] ha KAROL (12 Jun 2019 22:01) Savol: Dcms da install siz qanday scriptni o'rnatish mumkin to'liqroq tushuncha kerak bascub.sql ni bazaga zalit qildim dat ga mysql danilarni yozdim foydasi bo'lmadi va keyin 1- datga yozib danini keyn zalit qildim baribir server ulanmadi qayerda xatolik yoki qo'shimcha qilishim kerak help! Madridman (12 Jun 2019 23:33) News nachi marta o'qilganini sanamayabti, iltimos yordam beringlar :)
[b]291764dan so'ng qo'shdi...[/b]
Id1 ga qanday qilib lavozim bersa bo'ladi? zamonaviylar (13 Jun 2019 06:46) [b]Madridman,[/b] Id1 ga phpmyadmindan lavozim beras SEVIMLI (13 Jun 2019 09:03) --Javob-- zamonaviylar (13 Jun 2019 06:46): [b]Madridman,[/b] Id1 ga phpmyadmindan lavozim beras ---------- [b]zamonaviylar,[/b] Id1 dan lavozim beriladiku ushandaqa lavozim beruvdim masalan adminstrator ni panelga kirolmayapdi. nima qilsam ekan?
zamonaviylar (13 Jun 2019 09:08) [b]SEVIMLI,[/b] Siz mem aytganday qiling avval phpmyadmin/users/ dan qilas SEVIMLI (13 Jun 2019 09:19) --Javob-- zamonaviylar (13 Jun 2019 09:08): [b]SEVIMLI,[/b] Siz mem aytganday qiling avval phpmyadmin/users/ dan qilas ---------- [b]zamonaviylar,[/b] id1 dan lavozim bersamchi? Raxmonberdi (13 Jun 2019 09:48) [b]SEVIMLI,[/b] Dastublarini yoqing SEVIMLI (13 Jun 2019 10:29) [b]Raxmonberdi,[/b] qayeridan? dostup nima? zamonaviylar (13 Jun 2019 10:37) [b]SEVIMLI,[/b] Id1 ni lavozimlaymam dimadizmi SEVIMLI (13 Jun 2019 11:12) --Javob-- zamonaviylar (13 Jun 2019 10:37): [b]SEVIMLI,[/b] Id1 ni lavozimlaymam dimadizmi ---------- [b]zamonaviylar,[/b] yuq id1 dan boshqa userlarga lavozim beraman dedim zamonaviylar (13 Jun 2019 15:59) [b]SEVIMLI,[/b] Admin paneldan hohlaganizni beraveras SEVIMLI (13 Jun 2019 17:40) --Javob-- zamonaviylar (13 Jun 2019 15:59): [b]SEVIMLI,[/b] Admin paneldan hohlaganizni beraveras ---------- [b]zamonaviylar,[/b] beryapman lekin ular admin panelga kiromiyapdi. zamonaviylar (13 Jun 2019 17:45) [b]SEVIMLI,[/b] Unda supervoysor qiling Manba: https://www.uzmasters.ru/forum/6/57/790/