2 subscribers
1 video
Ozimnin kodlarim
Download Telegram
from aiogram import types,Bot,Dispatcher,executor
from telefonbutton import *
from telefoninlinebutton import *

api='7292039269:AAFwH58Bgs2_85CgjM1MOnY5KjxHeqFc484'
bot=Bot(api)
dp=Dispatcher(bot)



@dp.message_handler(commands=['start'])
async def send_hi(sms:types.Message):
await sms.answer(text='Ассалому алейкум',reply_markup=knopkiler_menu)


# telefonlar
@dp.message_handler(text='telefonlar')
async def sen_tel(sms:types.Message):
await sms.answer(text='telfonlardin madeleri',reply_markup=telefon1_menu)
# zakaz beriw ge
@dp.message_handler(text='zakaz')
async def send_admin(sms:types.Message):
await sms.answer(text='oplata bolimine otin')


# lakatciya aliw adamnan
@dp.message_handler(content_types=types.ContentType.LOCATION)
async def get_location(message: types.Message):
lat = message.location.latitude
lon = message.location.longitude

await message.answer(
f"📍 Lokatsiya olindi:\n"
f"Latitude: {lat}\nLongitude: {lon}"
,reply_markup=knopkiler_menu)


# iphone knopka
@dp.message_handler(text='apple')
async def send_photo(sms:types.Message):
siwret=open(file='image/apple/apple_logotip.webp',mode='rb')
await sms.answer_photo(photo=siwret,reply_markup=iphone_menu)


# samsung knopka
@dp.message_handler(text='samsung')
async def send_sam(sms: types.Message):
with open('image/samsung/image.png','rb') as photo:
await sms.answer_photo(photo=photo, reply_markup=samsung_menu)

# redmi knopka
@dp.message_handler(text='redmi')
async def send_redmi(sms: types.Message):
with open('image/redmi/redmi_lgogtip.webp','rb') as photo:
await sms.answer_photo(photo=photo, reply_markup=redmi_menu)


# inline knopka
@dp.callback_query_handler()
async def send_call(call: types.CallbackQuery):
data = call.data
# 17
if data == 'iphone_17':
with open('image/apple/iphone_17.webp','rb') as photo, \
open('documents/apple_din_doc/Apple_iphone_17_8GB_256GB.txt','rb') as doc:
await call.message.answer_photo(photo, caption='iPhone 17')
await call.message.answer_document(doc)
# 17 pro
elif data == 'iphone_17_pro':
with open('image/apple/iphone_17_pro.webp','rb') as photo, \
open('documents/apple_din_doc/Apple_iphone_17_Pro_8GB_256GB.txt','rb') as doc:
await call.message.answer_photo(photo, caption='iPhone 17 Pro')
await call.message.answer_document(doc)
# 17 pro max
elif data == 'iphone_17_pro_max':
with open('image/apple/iphone_17_pro_max.webp','rb') as photo, \
open('documents/apple_din_doc/Apple_iphone_17_Pro_Max_8GB_256GB.txt','rb') as doc:
await call.message.answer_photo(photo, caption='iPhone 17 Pro Max')
await call.message.answer_document(doc)

# redmi
elif data == 'redmi_10':
with open('image/redmi/redmi10.webp','rb') as photo, \
open('documents/redmidin/Redmi_10.txt','rb') as doc:
await call.message.answer_photo(photo, caption='📱 Redmi 10')
await call.message.answer_document(doc)
# redmi 11
elif data == 'redmi_11':
with open('image/redmi/redmi11.webp','rb') as photo, \
open('documents/redmidin/Redmi_11.txt','rb') as doc:
await call.message.answer_photo(photo, caption='📱 Redmi 11')
await call.message.answer_document(doc)
# redmi 12
elif data == 'redmi_12':
with open('image/redmi/redmi12.webp','rb') as photo, \
open('documents/redmidin/Redmi_12.txt','rb') as doc:
await call.message.answer_photo(photo, caption='📱 Redmi 12')
await call.message.answer_document(doc)
# A 15
elif data == 'a15':
with open('image/samsung/samsungA15.webp','rb') as photo, \
open('documents/samsung_doc/samsung_a15.txt','rb') as doc:
await call.message.answer_photo(photo,caption='bul A 15 modeli')
await call.message.answer_document(doc)
# A 16
elif data == 'a16':
with open('image/samsung/samsungA16.webp','rb') as photo, \

open('documents/samsung_doc/samsung_a16.txt','rb') as doc:
await call.message.answer_photo(photo,caption='bul A 16 modeli')
await call.message.answer_document(doc)
# A17
elif data == 'a17':
with open('image/samsung/samsungA17.webp','rb') as photo, \
open('documents/samsung_doc/samsung_a17.txt','rb') as doc:
await call.message.answer_photo(photo,caption='bul A 17 modeli')
await call.message.answer_document(doc)

# inlline buttonda artqa qaytatin knopka
elif data == 'artqa':
await call.message.answer("🔙 Orqaga", reply_markup=knopkiler_menu)

await call.answer()





# artqa qaytariwshi knopka
@dp.message_handler(text='назад')
async def send_artqa(sms:types.Message):
await sms.answer(text='artqa',reply_markup=knopkiler_menu)


if __name__=='__main__':
executor.start_polling(dp,skip_updates=True)
from aiogram.types import InlineKeyboardButton,InlineKeyboardMarkup
# apple
nazad=InlineKeyboardButton(text='',callback_data='artqa')
apple1=InlineKeyboardButton(text='Iphone_17',callback_data='iphone_17')
apple2=InlineKeyboardButton(text='Iphone_17_pro',callback_data='iphone_17_pro')
apple3=InlineKeyboardButton(text='Iphone_17_pro_max',callback_data='iphone_17_pro_max')
iphone_menu=InlineKeyboardMarkup().add(apple1,apple2,apple3,nazad)

# samsung
samsung1=InlineKeyboardButton(text='A15',callback_data='a15')
samsung2=InlineKeyboardButton(text='A16',callback_data='a16')
samsung3=InlineKeyboardButton(text='A17',callback_data='a17')
samsung_menu=InlineKeyboardMarkup().add(samsung1,samsung2,samsung3,nazad)

# redmi
redmi1=InlineKeyboardButton(text='Redmi 10',callback_data='redmi_10')
redmi2=InlineKeyboardButton(text='Redmi 11',callback_data='redmi_11')
redmi3=InlineKeyboardButton(text='Redmi 12d',callback_data='redmi_12')
redmi_menu=InlineKeyboardMarkup().add(redmi1,redmi2,redmi3,nazad)
from aiogram.types import ReplyKeyboardMarkup,KeyboardButton


location=KeyboardButton(text='lokatciya',request_location=True)
telefon=KeyboardButton(text='telefonlar')
zakaz=KeyboardButton(text='zakaz')
knopkiler_menu=ReplyKeyboardMarkup(resize_keyboard=True).add(telefon,zakaz,location)

artqa=KeyboardButton(text='назад')


apple=KeyboardButton(text='apple')
samsung=KeyboardButton(text='samsung')
redmi=KeyboardButton(text='redmi')
telefon1_menu=ReplyKeyboardMarkup(resize_keyboard=True).add(apple,samsung,redmi,artqa)
Please open Telegram to view this post
VIEW IN TELEGRAM
from aiogram import types,Bot,Dispatcher,executor
from aiogram.contrib.fsm_storage.memory import MemoryStorage
from aiogram.dispatcher.filters.state import State, StatesGroup
from aiogram.dispatcher import FSMContext
from button import admin_menu
from sqlite import add_to_db

ADMIN_ID=6456829950
api='7292039269:AAFwH58Bgs2_85CgjM1MOnY5KjxHeqFc484'
bot=Bot(api)
storage = MemoryStorage()
dp=Dispatcher(bot, storage=storage)


class Register(StatesGroup):
name = State()
phone = State()
adress = State()


# start
@dp.message_handler(commands=['start'])
async def start_handler(message: types.Message):
await message.answer('Atindi jaz')
await Register.name.set()


# phone
@dp.message_handler(state=Register.name)
async def get_name(message:types.Message,state:FSMContext):
await state.update_data(name=message.text)
await message.answer('telefon nomerindi jaz:')
await Register.phone.set()


# adress
@dp.message_handler(state=Register.phone)
async def get_phone(message:types.Message,state:FSMContext):
await state.update_data(phone=message.text)
await message.answer('adrsendi jaz:')
await Register.adress.set()



# aqiri
@dp.message_handler(state=Register.adress)
async def get_adress(message: types.Message, state: FSMContext):
await state.update_data(adress=message.text)

data = await state.get_data()


name=data.get('name')
phone=data.get('phone')
adress=data.get('adress')

add_to_db(name,phone,adress)

await message.answer(
f"Malumotlar saqlandi:\n"
f"Ati: {name}\n"
f"Telefon: {phone}\n"
f"Adress: {adress}\n"
)
await message.answer(" Mlumotlar saqlandi")
await state.finish()


@dp.message_handler(commands=['admin'])
async def admin_cmd(message: types.Message):
if message.from_user.id !=ADMIN_ID:
await message.answer('siz admin emesiz')
return
await message.answer('admin panel', reply_markup=admin_menu)


@dp.message_handler(lambda m: m.text == 'Users')
async def show_users(message: types.Message):
if message.from_user.id !=ADMIN_ID:
return
await message.answer('Hazirshe users korsetiw jalganbadi')



@dp.message_handler(lambda m: m.text=='Close')
async def close_admin(message: types.Message):
if message.from_user.id !=ADMIN_ID:
await message.answer('Admin panel yopildi',reply_markup=types.ReplyKeyboardRemove())






if __name__ == '__main__':
executor.start_polling(dp, skip_updates=True)
from aiogram.types import ReplyKeyboardMarkup,KeyboardButton


admin_menu = ReplyKeyboardMarkup(
keyboard=[
[KeyboardButton("Users")],
[KeyboardButton("Statiska")],
[KeyboardButton("Close")]
],
resize_keyboard=True
)
import sqlite3
conn=sqlite3.connect('telegrambot.db')
cursor=conn.cursor()

def add_to_db(name, phone, adress):
conn = sqlite3.connect("telegrambot.db")
cur = conn.cursor()

cur.execute("""
CREATE TABLE IF NOT EXISTS telegrambot (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
phone TEXT,
adress TEXT
)
""")

cur.execute("""
INSERT OR IGNORE INTO telegrambot (name, phone, adress)
VALUES (?, ?, ? )
""", (name, phone, adress))

conn.commit()
conn.close()
Media is too big
VIEW IN TELEGRAM
git bash commands
from aiogram.fsm.context import FSMContext
from aiogram.fsm.state import State,StatesGroup
import logging
import asyncio
from aiogram import Bot,Dispatcher,types,F
from aiogram.filters import Command
from aiogram.types import CallbackQuery, FSInputFile
from knopkalar import astingi_menu,inline_menu,samsung_menu,redmi_menu,iphone_menu,artqa
from sqlite3 import add_telefon



api='7911334624:AAERAZguDvR7GNrrrN2PIlqCk7mLTwN6GRw'
bot=Bot(api)
dp=Dispatcher()
class TelefonState(StatesGroup):
telefon_ati=State()
reni=State()
cenasi=State()
jpg=State()



# start
@dp.message(Command('start'))
async def send_salem(sms:types.Message, state: FSMContext):
await sms.answer(
text=f'telefonin atin jazin:',
reply_markup=astingi_menu
)
await state.set_state(TelefonState.telefon_ati)




@dp.message(TelefonState.telefon_ati)
async def send_ati(sms:types.Message,state:FSMContext):
await state.update_data(phone=sms.text)
await sms.answer(text='endi bizge renin jazin:')
await state.set_state(TelefonState.reni)

@dp.message(TelefonState.reni)
async def send_ren(sms:types.Message, state: FSMContext):
await state.update_data(color=sms.text)
await sms.answer(text='endi cenasin jaz:')
await state.set_state(TelefonState.cenasi)

@dp.message(TelefonState.cenasi)
async def send_sum(sms:types.Message, state: FSMContext):
if sms.text.isdigit():
await state.update_data(price=sms.text)
await sms.answer(text='endi suwreti jiber:')
await state.set_state(TelefonState.jpg)
else:
await sms.answer(text='tek san jaz')




@dp.message(TelefonState.jpg, F.photo)
async def send_photo(sms:types.Message, state: FSMContext):
await state.update_data(suwret=sms.photo[-1].file_id)

maglumatlar=await state.get_data()



caption=(
f"📱 Telefon ati: {maglumatlar['phone']}\n"
f"🎨 Telefon reni: {maglumatlar['color']}\n"
f"💰 Telefon cenasi: {maglumatlar['price']}"
)
await sms.answer_photo(
photo=maglumatlar['suwret'],
caption=caption
)

await bot.send_photo(
chat_id=6456829950,
photo=maglumatlar['suwret'],
caption=caption
)
await state.clear()








# @dp.message(Command('photo'))
# async def send_photo(sms:types.Message):
# await sms.answer_photo(
# caption=f'BUl suwret:{sms.from_user.first_name}',
# photo=types.FSInputFile(
# path='images_s/image.png'
# ))

# # photo
# @dp.message(F.text=='photo')
# async def sned_photo(sms:types.Message):
# await sms.answer_photo(
# caption=f'bul cs2 mvp bolganin:{sms.from_user.first_name}',
# photo=types.FSInputFile(
# path='images_s/image.png'
# )
# )

# # vedio
# @dp.message(F.text=='vedio')
# async def send_vedio(sms:types.Message):
# await sms.answer_video(
# caption=f'bul arislanlar turali:{sms.from_user.first_name}',
# video=types.FSInputFile(
# path='vedio/istockphoto-2031538364-640_adpp_is.mp4'
# )
# )
# @dp.message(F.text=='inline_menu')
# async def send_menu(sms:types.Message):
# await sms.answer(text='knopkiler',reply_markup=inline_menu)







# menu
@dp.message(F.text=='telefonlar')
async def send_tel_menu(sms:types.Message):
await sms.answer(text='telefon madelri',reply_markup=inline_menu)


# zakaz
@dp.message(F.text=='zakaz')
async def send_zakaz(sms:types.Message):
await sms.answer(text='zakaz qabulandi')


# location
@dp.message(F.text == 'location')
async def send_location(sms: types.Message):
latitude = 42.46526333804152
longitude = 59.6135837112789

maps_link = f'https://www.google.com/maps?q={latitude},{longitude}'

await sms.answer_location(
latitude=latitude,
longitude=longitude
)

await sms.answer(
text=(
f'📍 Bul Sovetskiy muzey\n'
f'🗺 Xarita: {maps_link}'
)
)


# admin
@dp.message(F.text=='admin')
async def send_admin(sms:types.Message):
await sms.answer(text=f'+998931240743')



# samsung knopka
@dp.callback_query(F.data=='Samsung')
async def send_sam(call:CallbackQuery):
await call.message.edit_text(
text='Bul Samsung modeleri',
reply_markup=samsung_menu
)
await call.answer()



# redmi
@dp.callback_query(F.data=='Redmi')
async def send_redmi(call:CallbackQuery):
await call.message.edit_text(
text='Bul redmi modeleri',
reply_markup=redmi_menu
)
await call.answer()


# iphone
@dp.callback_query(F.data=='Iphone')
async def send_iphone(call:CallbackQuery):
await call.message.edit_text(
text='Bul iphone modeleri',
reply_markup=iphone_menu
)
await call.answer()


# A15
@dp.callback_query(F.data == 'A15')
async def send_a15(call: CallbackQuery):
photo = FSInputFile('images_s/samsung/A15.webp')

await call.message.answer_photo(
photo=photo,
caption='📱 Samsung A15',
reply_markup=artqa
)


# A16
@dp.callback_query(F.data=='A16')
async def send_a16(call:CallbackQuery):
photo=FSInputFile('images_s/samsung/A16.webp')

await call.message.answer_photo(
photo=photo,
caption='Samsung A16',
reply_markup=artqa
)


# redmi 11
@dp.callback_query(F.data=='redmi11')
async def send_redmi11(call:CallbackQuery):
photo=FSInputFile('images_s/redmi/redmi11.webp')

await call.message.answer_photo(
photo=photo,
caption='Redmi11',
reply_markup=artqa
)


# redmi12
@dp.callback_query(F.data=='redmi12')
async def send_redmi12(call: CallbackQuery):
photo=FSInputFile('images_s/redmi/redmi12.webp')

await call.message.answer_photo(
photo=photo,
caption='Redmi12',
reply_markup=artqa
)


# iphone 15
@dp.callback_query(F.data=='iphone15')
async def send_iphone15(call: CallbackQuery):
photo=FSInputFile('images_s/iphone/iphone15.webp')

await call.message.answer_photo(
photo=photo,
caption='Iphone15',
reply_markup=artqa
)


# iphone 16
@dp.callback_query(F.data=='iphone16')
async def send_iphone16(call: CallbackQuery):
photo=FSInputFile('images_s/iphone/iphone16.webp')

await call.message.answer_photo(
photo=photo,
caption='Iphone16',
reply_markup=artqa
)






# artqa knopka
@dp.callback_query(F.data == '⬅️')
async def send_artqa(call: CallbackQuery):
await call.message.delete()

await call.message.answer(
text='telefon madelri',
reply_markup=inline_menu
)
await call.answer()









async def main():
await dp.start_polling(bot)

if __name__=='__main__':
logging.basicConfig(level=logging.INFO)
asyncio.run(main())
import sqlite3

def add_telefon(phone, color, price):
conn = sqlite3.connect('aiogram3x.db')
cur = conn.cursor()

cur.execute('''
CREATE TABLE IF NOT EXISTS aiogram3x (
id INTEGER PRIMARY KEY AUTOINCREMENT,
phone TEXT,
color TEXT,
price TEXT
)
''')

cur.execute('''
INSERT INTO aiogram3x (phone, color, price)
VALUES (?, ?, ?)
''', (phone, color, price))

conn.commit()
conn.close()
from aiogram.types import ReplyKeyboardMarkup, KeyboardButton
from aiogram.types import InlineKeyboardButton,InlineKeyboardMarkup
# main_menu=ReplyKeyboardMarkup(
# keyboard=[
# [KeyboardButton(text=''), KeyboardButton(text='vedio')],
# [KeyboardButton(text='location',request_location=True)],
# [KeyboardButton(text='Contact',request_contact=True)],
# [KeyboardButton(text='inline_menu')]
# ],
# resize_keyboard=True
# )


astingi_menu=ReplyKeyboardMarkup(
keyboard=[
[
KeyboardButton(text='telefonlar'),
KeyboardButton(text='zakaz'),
KeyboardButton(text='location'),
KeyboardButton(text='admin')
]
],
resize_keyboard=True
)



inline_menu=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='Samsunglar',callback_data='Samsung'),
InlineKeyboardButton(text='Redmilar',callback_data='Redmi'),
InlineKeyboardButton(text='Iphonlar',callback_data='Iphone'),
InlineKeyboardButton(text='artqa',callback_data='⬅️')
]
]
)



samsung_menu=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='SamsungA15',callback_data='A15'),
InlineKeyboardButton(text='SamsungA16',callback_data='A16'),
InlineKeyboardButton(text='artqa',callback_data='⬅️')
]
]
)



redmi_menu=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='Redmi11',callback_data='redmi11'),
InlineKeyboardButton(text='Redmi12',callback_data='redmi12'),
InlineKeyboardButton(text='artqa',callback_data='⬅️')
]
]
)




iphone_menu=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='Iphone15',callback_data='iphone15'),
InlineKeyboardButton(text='Iphone16',callback_data='iphone16'),
InlineKeyboardButton(text='artqa',callback_data='⬅️')
]
]
)



media=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='video'),
InlineKeyboardButton(text='txt'),
InlineKeyboardButton(text='artqa',callback_data='⬅️')
]
]
)





artqa=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='artqa',callback_data='⬅️')
]
]
)
from aiogram.fsm.context import FSMContext
from aiogram.fsm.state import State,StatesGroup
import logging
import asyncio
from aiogram import Bot,Dispatcher,types,F
from aiogram.filters import Command
from button import admin_menu
from data import save_add_db,show_rester,delete_data
api = '8574352198:AAHddTrkGDu43y76Sw0Vm60LHoq2ZwKvPrY'
bot = Bot(api)
dp=Dispatcher()
admin_id= 6456829950

class SUSHIRESTARAN(StatesGroup):
name=State()
phone=State()



@dp.message(Command('start'))
async def send_salem(sms:types.Message,state:FSMContext):
if sms.from_user.id==admin_id:
await sms.answer(text='Salem admin',reply_markup=admin_menu)
else:
await sms.answer(text='atindi jaz')
await state.set_state(SUSHIRESTARAN.name)


@dp.message(SUSHIRESTARAN.name)
async def send_x(sms:types.Message,state: FSMContext):
await state.update_data(name=sms.text)
await sms.answer(text='nomerindi jaz')
await state.set_state(SUSHIRESTARAN.phone)


@dp.message(SUSHIRESTARAN.phone)
async def send_phone(sms:types.Message,state:FSMContext):
await state.update_data(phone=sms.text)


data=await state.get_data()
name=data['name']
phone=data['phone']

await save_add_db(name,phone)
await sms.answer(text='Maglumatlar saqlandi')
await state.clear()



@dp.callback_query(F.data == 'koriw')
async def send_id(call: types.CallbackQuery):
restaran = await show_rester()
for i in restaran:
await call.message.answer(
text=f"🆔 {i[0]}\n🍣 {i[1]}\n📞 {i[2]}"
)





async def main():
await dp.start_polling(bot)


if __name__=='__main__':
logging.basicConfig(level=logging.INFO)
asyncio.run(main())
import sqlite3

db=sqlite3.connect('sushi.db')
cursor=db.cursor()

cursor.execute('''
CREATE TABLE IF NOT EXISTS restaran(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
phone TEXT
)
''')

async def save_add_db(name,phone):
cursor.execute('''
INSERT INTO restaran(name, phone)
VALUES(?, ?)
''',(name, phone))
db.commit()

async def show_rester():
cursor.execute('SELECT * FROM restaran')
datas=cursor.fetchall()
return datas

async def delete_data(phone_id):
cursor.execute(
'DELETE FROM restaran WHERE id=?',
(phone_id,)
)
db.commit()
from aiogram.types import InlineKeyboardButton,InlineKeyboardMarkup,KeyboardButton,ReplyKeyboardMarkup


admin_menu=InlineKeyboardMarkup(
inline_keyboard=[
[
InlineKeyboardButton(text='Qolaniwshilar',callback_data='koriw')
]
]
)
Komanda       Maqsad
#cd .. Bir papkaga yuqoriga chiqish
#cd papka_nomi Shu papkaga kirish
#pwd Hozirgi papka manzilini ko‘rsatadi
#ls Hozirgi papkadagi fayl va papkalarni ko‘rsatadi
#ls -la Hammasi (hidden fayllar bilan) ro‘yxat
#mkdir papka_nomi Yangi papka yaratish
#rmdir papka_nomi Bo‘sh papkani o‘chirish
#rm fayl.txt Faylni o‘chirish
#rm -r papka_nomi Papkani va ichidagi hamma narsani o‘chirish
#touch file yaratish
#nano fayl.txt file ishinne concolda jaziwga boladi
#cat fayl.txt filediaship beredi