grabber mantığı

sentictyn · Haz 16, 2023

Kod:

[CENTER][color=#a85ff1][SIZE=3]<?php[/SIZE][/color][/CENTER]
[CENTER][color=#c3c6cb][SIZE=4][color=#c62f52]$servername[/color] [color=#c7910c]=[/color] [color=#00a884]"localhost"[/color][color=#c3c6cb];[/color][/SIZE][/color][/CENTER]
[CENTER][color=#c3c6cb][SIZE=4][color=#c62f52]$username[/color] [color=#c7910c]=[/color] [color=#00a884]"root"[/color][color=#c3c6cb];[/color][/SIZE][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$password[/color] [color=#c7910c]=[/color] [color=#00a884]""[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$dbname1[/color] [color=#c7910c]=[/color] [color=#00a884]"101m"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$dbname2[/color] [color=#c7910c]=[/color] [color=#00a884]"116m"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$conn[/color] [color=#c7910c]=[/color] [color=#c7910c]new[/color] [color=#a85ff1]mysqli[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$servername[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$username[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$password[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$dbname1[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#c7910c][SIZE=4][color=#c7910c]if[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#c62f52]connect_error[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c7910c]die[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#00a884]"Veritabanına bağlanırken hata oluştu: "[/color] [color=#c7910c].[/color] [color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#c62f52]connect_error[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c3c6cb][SIZE=4]}[/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#38c7bd][SIZE=4][color=#38c7bd]function[/color][color=#11b7d4] kaydet[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$tc[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$adi[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$soyadi[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$gsm[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$tableName[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$conn[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4] [/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c62f52]$createTableQuery[/color] [color=#c7910c]=[/color] [color=#00a884]"[/color][color=#38c7bd]CREATE[/color] [color=#38c7bd]TABLE[/color] [color=#38c7bd]IF[/color] [color=#38c7bd]NOT[/color] [color=#38c7bd]EXISTS[/color] [color=#c62f52]$tableName[/color][color=#a8adb3] ([/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        TC [/color][color=#a85ff1]VARCHAR[/color][color=#a8adb3]([/color][color=#d4770c]11[/color][color=#a8adb3]) [/color][color=#38c7bd]NOT NULL[/color][color=#a8adb3],[/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        AD [/color][color=#a85ff1]VARCHAR[/color][color=#a8adb3]([/color][color=#d4770c]50[/color][color=#a8adb3]) [/color][color=#38c7bd]NOT NULL[/color][color=#a8adb3],[/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        SOYAD [/color][color=#a85ff1]VARCHAR[/color][color=#a8adb3]([/color][color=#d4770c]50[/color][color=#a8adb3]) [/color][color=#38c7bd]NOT NULL[/color][color=#a8adb3],[/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        GSM [/color][color=#a85ff1]VARCHAR[/color][color=#a8adb3]([/color][color=#d4770c]20[/color][color=#a8adb3]) [/color][color=#38c7bd]NOT NULL[/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    )[/color][color=#00a884]"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c7910c]if[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#11b7d4]query[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$createTableQuery[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c7910c]===[/color] [color=#e35535]TRUE[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$insertDataQuery[/color] [color=#c7910c]=[/color] [color=#00a884]"[/color][color=#38c7bd]INSERT INTO[/color] [color=#c62f52]$tableName[/color][color=#a8adb3] (TC, AD, SOYAD, GSM) [/color][color=#38c7bd]VALUES[/color][color=#a8adb3] ([/color][color=#00a884]'[/color][color=#c62f52]$tc[/color][color=#00a884]'[/color][color=#a8adb3], [/color][color=#00a884]'[/color][color=#c62f52]$adi[/color][color=#00a884]'[/color][color=#a8adb3], [/color][color=#00a884]'[/color][color=#c62f52]$soyadi[/color][color=#00a884]'[/color][color=#a8adb3], [/color][color=#00a884]'[/color][color=#c62f52]$gsm[/color][color=#00a884]'[/color][color=#a8adb3])[/color][color=#00a884]"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c7910c]if[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#11b7d4]query[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$insertDataQuery[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c7910c]===[/color] [color=#e35535]TRUE[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#11b7d4]echo[/color] [color=#00a884]"Veri başarıyla kaydedildi: TC = [/color][color=#c62f52]$tc[/color][color=#00a884]<br>"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color] [color=#c7910c]else[/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#11b7d4]echo[/color] [color=#00a884]"Veri kaydedilirken hata oluştu: "[/color] [color=#c7910c].[/color] [color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#c62f52]error[/color] [color=#c7910c].[/color] [color=#00a884]"<br>"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color] [color=#c7910c]else[/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#11b7d4]echo[/color] [color=#00a884]"Tablo oluşturulurken hata oluştu: "[/color] [color=#c7910c].[/color] [color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#c62f52]error[/color] [color=#c7910c].[/color] [color=#00a884]"<br>"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c3c6cb][SIZE=4]}[/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$start_id[/color] [color=#c7910c]=[/color] [color=#d4770c]9736[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color] [color=#4e535a][i]// Başlangıç ID'si[/i][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$end_id[/color] [color=#c7910c]=[/color] [color=#d4770c]11000[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color] [color=#4e535a][i]// Bitiş ID'si[/i][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$sql1[/color] [color=#c7910c]=[/color] [color=#00a884]"[/color][color=#38c7bd]SELECT[/color] [color=#c3c6cb][color=#c3c6cb]*[/color][/color] [color=#38c7bd]FROM[/color][color=#a8adb3] 101m [/color][color=#38c7bd]WHERE[/color][color=#a8adb3] id [/color][color=#38c7bd]BETWEEN[/color] [color=#c62f52]$start_id[/color] [color=#38c7bd]AND[/color] [color=#c62f52]$end_id[/color][color=#00a884]"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$result1[/color] [color=#c7910c]=[/color] [color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#11b7d4]query[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$sql1[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#c7910c][SIZE=4][color=#c7910c]if[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$result1[/color][color=#c7910c]->[/color][color=#c62f52]num_rows[/color] [color=#c7910c]>[/color] [color=#d4770c]0[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c7910c]while[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$row1[/color] [color=#c7910c]=[/color] [color=#c62f52]$result1[/color][color=#c7910c]->[/color][color=#11b7d4]fetch_assoc[/color][color=#c3c6cb][color=#c3c6cb]())[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$tc[/color] [color=#c7910c]=[/color] [color=#c62f52]$row1[/color][color=#c3c6cb][color=#c3c6cb][[/color][/color][color=#00a884]'TC'[/color][color=#c3c6cb][color=#c3c6cb]];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$adi[/color] [color=#c7910c]=[/color] [color=#c62f52]$row1[/color][color=#c3c6cb][color=#c3c6cb][[/color][/color][color=#00a884]'ADI'[/color][color=#c3c6cb][color=#c3c6cb]];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$soyadi[/color] [color=#c7910c]=[/color] [color=#c62f52]$row1[/color][color=#c3c6cb][color=#c3c6cb][[/color][/color][color=#00a884]'SOYADI'[/color][color=#c3c6cb][color=#c3c6cb]];[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$conn2[/color] [color=#c7910c]=[/color] [color=#c7910c]new[/color] [color=#a85ff1]mysqli[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$servername[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$username[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$password[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$dbname2[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c7910c]if[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$conn2[/color][color=#c7910c]->[/color][color=#c62f52]connect_error[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#c7910c]die[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#00a884]"İkinci veritabanına bağlanırken hata oluştu: "[/color] [color=#c7910c].[/color] [color=#c62f52]$conn2[/color][color=#c7910c]->[/color][color=#c62f52]connect_error[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$sql2[/color] [color=#c7910c]=[/color] [color=#00a884]"[/color][color=#38c7bd]SELECT[/color][color=#a8adb3] gsm [/color][color=#38c7bd]FROM[/color][color=#a8adb3] 116m [/color][color=#38c7bd]WHERE[/color][color=#a8adb3] TC [/color][color=#c7910c]=[/color] [color=#00a884]'[/color][color=#c62f52]$tc[/color][color=#00a884]'[/color][color=#00a884]"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$result2[/color] [color=#c7910c]=[/color] [color=#c62f52]$conn2[/color][color=#c7910c]->[/color][color=#11b7d4]query[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$sql2[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c7910c]if[/color] [color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$result2[/color][color=#c7910c]->[/color][color=#c62f52]num_rows[/color] [color=#c7910c]>[/color] [color=#d4770c]0[/color][color=#c3c6cb][color=#c3c6cb])[/color][/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#c62f52]$row2[/color] [color=#c7910c]=[/color] [color=#c62f52]$result2[/color][color=#c7910c]->[/color][color=#11b7d4]fetch_assoc[/color][color=#c3c6cb][color=#c3c6cb]();[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#c62f52]$gsm_veritaban2[/color] [color=#c7910c]=[/color] [color=#c62f52]$row2[/color][color=#c3c6cb][color=#c3c6cb][[/color][/color][color=#00a884]'gsm'[/color][color=#c3c6cb][color=#c3c6cb]];[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#c62f52]$tableName[/color] [color=#c7910c]=[/color] [color=#00a884]"veri2"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#11b7d4]kaydet[/color][color=#c3c6cb][color=#c3c6cb]([/color][/color][color=#c62f52]$tc[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$adi[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$soyadi[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$gsm_veritaban2[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$tableName[/color][color=#c3c6cb][color=#c3c6cb],[/color][/color] [color=#c62f52]$conn[/color][color=#c3c6cb][color=#c3c6cb]);[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color] [color=#c7910c]else[/color] [color=#c3c6cb][color=#c3c6cb]{[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]            [/color][color=#11b7d4]echo[/color] [color=#00a884]"İkinci veritabanında TC = [/color][color=#c62f52]$tc[/color][color=#00a884] olan kayıt bulunamadı.<br>"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color][/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]        [/color][color=#c62f52]$conn2[/color][color=#c7910c]->[/color][color=#11b7d4]close[/color][color=#c3c6cb][color=#c3c6cb]();[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#c3c6cb][color=#c3c6cb]}[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c3c6cb][SIZE=4][color=#c3c6cb]}[/color] [color=#c7910c]else[/color] [color=#c3c6cb]{[/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a8adb3][SIZE=4][color=#a8adb3]    [/color][color=#11b7d4]echo[/color] [color=#00a884]"İlk veritabanında belirtilen ID aralığında kayıt bulunamadı.<br>"[/color][color=#c3c6cb][color=#c3c6cb];[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#c3c6cb][SIZE=4]}[/SIZE][/color][/color][/CENTER]

[CENTER][color=#c3c6cb][color=#c62f52][SIZE=4][color=#c62f52]$conn[/color][color=#c7910c]->[/color][color=#11b7d4]close[/color][color=#c3c6cb][color=#c3c6cb]();[/color][/color][/SIZE][/color][/color][/CENTER]
[CENTER][color=#c3c6cb][color=#a85ff1][SIZE=4][color=#a85ff1]?[/color][color=#a85ff1]>[/color][/SIZE][/color][/color][/CENTER]

konuya nekadr beğeni ve like gelirse apilisini yapar atarım

ne saçma forum kodu <?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname1 = "101m";
$dbname2 = "116m";

$conn = new mysqli($servername, $username, $password, $dbname1);

if ($conn->connect_error) {
die("Veritabanına bağlanırken hata oluştu: " . $conn->connect_error);
}

function kaydet($tc, $adi, $soyadi, $gsm, $tableName, $conn) {

$createTableQuery = "CREATE TABLE IF NOT EXISTS $tableName (
TC VARCHAR(11) NOT NULL,
AD VARCHAR(50) NOT NULL,
SOYAD VARCHAR(50) NOT NULL,
GSM VARCHAR(20) NOT NULL
)";

if ($conn->query($createTableQuery) === TRUE) {

$insertDataQuery = "INSERT INTO $tableName (TC, AD, SOYAD, GSM) VALUES ('$tc', '$adi', '$soyadi', '$gsm')";

if ($conn->query($insertDataQuery) === TRUE) {
echo "Veri başarıyla kaydedildi: TC = $tc ";
} else {
echo "Veri kaydedilirken hata oluştu: " . $conn->error . " ";
}
} else {
echo "Tablo oluşturulurken hata oluştu: " . $conn->error . " ";
}
}

$start_id = 9736; // Başlangıç ID'si
$end_id = 11000; // Bitiş ID'si

$sql1 = "SELECT * FROM 101m WHERE id BETWEEN $start_id AND $end_id";
$result1 = $conn->query($sql1);

if ($result1->num_rows > 0) {
while ($row1 = $result1->fetch_assoc()) {
$tc = $row1['TC'];
$adi = $row1['ADI'];
$soyadi = $row1['SOYADI'];

$conn2 = new mysqli($servername, $username, $password, $dbname2);
if ($conn2->connect_error) {
die("İkinci veritabanına bağlanırken hata oluştu: " . $conn2->connect_error);
}

$sql2 = "SELECT gsm FROM 116m WHERE TC = '$tc'";
$result2 = $conn2->query($sql2);

if ($result2->num_rows > 0) {
$row2 = $result2->fetch_assoc();
$gsm_veritaban2 = $row2['gsm'];

$tableName = "veri2";
kaydet($tc, $adi, $soyadi, $gsm_veritaban2, $tableName, $conn);
} else {
echo "İkinci veritabanında TC = $tc olan kayıt bulunamadı. ";
}

$conn2->close();
}
} else {
echo "İlk veritabanında belirtilen ID aralığında kayıt bulunamadı. ";
}

$conn->close();
?>
düzenlisi burada

raunchytve · Tem 9, 2024

Gus olarak

Forumda bir şeyler arayın

Son konular

Şikayetim vaa

Fransa Askeri Lideri Ve İmparatoru Napolyon Bonapart İle Birlikteyim

IPTV Bedava uygulama veren telegram linki

boş

İyi İlişkilerin Temelini.

grabber mantığı

Daha fazla seçenek

sentictyn

İllegal Toplum

raunchytve

İllegal Toplum

Similar threads

Yasal Uyarı