Php veri giriş kodu
Merhaba,
Aşağıda yer alan yapıda elinizde bir sayfa kodu var mı? Varsa paylaşabilir misiniz.
1- aşağıda yer alan kod içerisinde bulunan alanda URL girişi yapıp KAYIT yapılınca veri tabanına yazılacak.
2- VERİTABANI SİL butonuna basınca mysql de bulunan tüm kayıtlar silinecek.
index.php
<?php include ("header.php"); include ("main.php"); include ("fother.php"); ?>Kod
Yığını:
header.php
<!doctype html> <html lang="tr"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link href="assets/vendors/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link href="assets/css/style.css" rel="stylesheet"> <link href="assets/css/responsive.css" rel="stylesheet"> <title>Dido 20 Link Giriş</title> </head> <body>Kod
Yığını:
main.php
<div class="body_wrapper frm-vh-md-100"> <div class="header_top d-flex align-items-center justify-content-between"> <a href="#" class="logo"><img src="assets/img/logo.png" alt=""></a> <p class="form_footer_text text-right">Veri Girişi <a href="index--4.html"> </a> </p> </div> <div class="formify_body formify_signup_fullwidth parallax-effect d-flex"> <div class="formify_left_fullwidth frm-vh-md-100" data-bg-img="assets/img/background-bg-left.jpg"> </div> <div class="formify_right_fullwidth d-flex align-items-center justify-content-center"> <div class="parallax_img"> <div class="p_img one"> <img class="layer layer2" data-depth="0.5" src="assets/img/parallax-img/polygon1.png" alt=""> </div> <div class="p_img two"><img class="layer layer2" data-depth="0.4" src="assets/img/parallax-img/polygon2.png" alt=""></div> <div class="p_img three"><img class="layer layer2" data-depth="0.5" src="assets/img/parallax-img/polygon3.png" alt=""></div> <div class="p_img four"><img class="layer layer2" data-depth="0.5" src="assets/img/parallax-img/polygon4.png" alt=""></div> <div class="p_img five"><img class="layer layer2" data-depth="0.5" src="assets/img/parallax-img/polygon5.png" alt=""></div> <div class="p_img six"><img class="layer layer2" data-depth="0.5" src="assets/img/parallax-img/polygon6.png" alt=""></div> </div> <div class="formify_content_body"> <h2 class="form_title">Salon URL Girişi Yapınız</h2> <form action="#" class="signup_form signup_form_style_two"> <div class="form-group"> <input class="form-control" type="text" id="name" name="name" aria-required="true"> <label class="top_text">Dido URL</label> </div> <div class="form-group"> <button type="submit" class="btn thm_btn thm_btn_green">Kayıt</button> </div> </form><br></br><br></br> <div class="form-group"> <button type="submit" class="btn thm_btn thm_btn_green">VERİ TABANI SİL</button> </div> </div> </div> </div> </div>Kod
Yığını:
fother.php
<script src="assets/js/jquery-3.4.1.min.js"></script> <script src="assets/vendors/bootstrap/js/popper.min.js"></script> <script src="assets/vendors/bootstrap/js/bootstrap.min.js"></script> <script src="assets/js/parallax.js"></script> <script src="assets/js/jquery.parallax-scroll.js"></script> <script src="assets/js/main.js"></script> </body> </html>Kod
Yığını:
config.php
<?php defined('BASEPATH') OR exit('No direct script access allowed'); /* | ------------------------------------------------------------------- | DATABASE CONNECTIVITY SETTINGS | ------------------------------------------------------------------- | This file will contain the settings needed to access your database. | | For complete instructions please consult the 'Database Connection' | page of the User Guide. | | ------------------------------------------------------------------- | EXPLANATION OF VARIABLES | ------------------------------------------------------------------- | | ['dsn'] The full DSN string describe a connection to the database. | ['hostname'] The hostname of your database server. | ['username'] The username used to connect to the database | ['password'] The password used to connect to the database | ['database'] The name of the database you want to connect to | ['dbdriver'] The database driver. e.g.: mysqli. | Currently supported: | cubrid, ibase, mssql, mysql, mysqli, oci8, | odbc, pdo, postgre, sqlite, sqlite3, sqlsrv | ['dbprefix'] You can add an optional prefix, which will be added | to the table name when using the Query Builder class | ['pconnect'] TRUE/FALSE - Whether to use a persistent connection | ['db_debug'] TRUE/FALSE - Whether database errors should be displayed. | ['cache_on'] TRUE/FALSE - Enables/disables query caching | ['cachedir'] The path to the folder where cache files should be stored | ['char_set'] The character set used in communicating with the database | ['dbcollat'] The character collation used in communicating with the database | NOTE: For MySQL and MySQLi databases, this setting is only used | as a backup if your server is running PHP < 5.2.3 or MySQL < 5.0.7 | (and in table creation queries made with DB Forge). | There is an incompatibility in PHP with mysql_real_escape_string() which | can make your site vulnerable to SQL injection if you are using a | multi-byte character set and are running versions lower than these. | Sites using Latin-1 or UTF-8 database character set and collation are unaffected. | ['swap_pre'] A default table prefix that should be swapped with the dbprefix | ['encrypt'] Whether or not to use an encrypted connection. | | 'mysql' (deprecated), 'sqlsrv' and 'pdo/sqlsrv' drivers accept TRUE/FALSE | 'mysqli' and 'pdo/mysql' drivers accept an array with the following options: | | 'ssl_key' - Path to the private key file | 'ssl_cert' - Path to the public key certificate file | 'ssl_ca' - Path to the certificate authority file | 'ssl_capath' - Path to a directory containing trusted CA certificates in PEM format | 'ssl_cipher' - List of *allowed* ciphers to be used for the encryption, separated by colons (':') | 'ssl_verify' - TRUE/FALSE; Whether verify the server certificate or not | | ['compress'] Whether or not to use client compression (MySQL only) | ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections | - good for ensuring strict SQL while developing | ['ssl_options'] Used to set various SSL options that can be used when making SSL connections. | ['failover'] array - A array with 0 or more data for connections if the main should fail. | ['save_queries'] TRUE/FALSE - Whether to "save" all executed queries. | NOTE: Disabling this will also effectively disable both | $this->db->last_query() and profiling of DB queries. | When you run a query, with this setting set to TRUE (default), | CodeIgniter will store the SQL statement for debugging purposes. | However, this may cause high memory usage, especially if you run | a lot of SQL queries ... disable this to avoid that problem. | | The $active_group variable lets you choose which connection group to | make active. By default there is only one group (the 'default' group). | | The $query_builder variables lets you determine whether or not to load | the query builder class. */ $active_group = 'default'; $query_builder = TRUE; $db['default'] = array( 'dsn' => 'mysql:host=localhost;port=3306;dbname=u9109138_dibi_db', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'u9109138_dibi_db', /* 'dsn' => 'mysql:host=localhost;port=3306;dbname=localhost', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'localhost',*/ 'dbdriver' => 'pdo', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE );Kod
Yığını:
girilen verinin gösterileceği sayfa.
salon.html
<!doctype html> <html lang="tr"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Dido 20 Salon</title> <meta http-equiv="" content="100000;URL=<?php VERİTABANINA GİRİEN URL BURAYA GELECEK ?>"> </head> <body> </body> </html>Kod
Yığını:
VERİ TABANI:
db: u7452_salon
user: u7452_user
password: 123654
tablo adı: salon
sutunlar :
1- id
2- url_link
Intel Xeon phi 7110P İnternet Erişim Problemi
Aşağıdaki konu ile alakalı bize yardımcı olmanızı istirham ediyoruz. Xeon phi yardımcı işlemciyi internete çıkartamıyoruz.
işletim sistemi : Windows 10
Anakart : Asus Z10PE D16 WS
Yardımcı işlemci işlemci pci card : Xeon phi 7110P
----mic0--ağ------------
ip adres: 192.168.1.100
subnet : 255.255.255.0
gw: 192.168.1.253
nameserver : 8.8.8.8
---anakart - ağ -------
ip adres : 192.168.1.150
subnet : 255.255.255.0
gw: 192.168.1.253
-------xeon OS------------
busybox 2.17
===================
1- Putty üzerinden SSH ile bağlantı sağlayabiliyoruz.
2- Windows üzerinden mic0 gw 192.168.1.99 ping atıyoruz.
3- Windows üzerinde mic0 ip adresi 192.168.1.100 ping atıyoruz.
4- mic0 içerisinden ping 192.168.1.253 - 192.168.1.150 bağlamaya çalıştığımızda.
[root@mic0 ~]# ping 192.168.1.150
PING 192.168.1.150 (192.168.1.150) 56(84) bytes of data.
From 192.168.1.100 icmp_seq=1 Destination Host Unreachable
From 192.168.1.100 icmp_seq=2 Destination Host Unreachable
From 192.168.1.100 icmp_seq=3 Destination Host Unreachable
From 192.168.1.100 icmp_seq=4 Destination Host Unreachable
From 192.168.1.100 icmp_seq=5 Destination Host Unreachable
From 192.168.1.100 icmp_seq=6 Destination Host Unreachable
From 192.168.1.100 icmp_seq=7 Destination Host Unreachable
From 192.168.1.100 icmp_seq=8 Destination Host Unreachable
From 192.168.1.100 icmp_seq=9 Destination Host Unreachable
From 192.168.1.100 icmp_seq=10 Destination Host Unreachable
From 192.168.1.100 icmp_seq=11 Destination Host Unreachable
From 192.168.1.100 icmp_seq=12 Destination Host Unreachable
------------------------
Ayrıca; route flags değiştirmeyi başaramadık.
[root@mic0 ~]# route -n
Kernel IP routing table
Destination / Gateway / Genmask / Flags / Metric / Ref / Use / Iface
0.0.0.0 / 192.168.1.253 / 255.255.255.0 / UG /0 / 0 / 0 / mic0
192.168.1.0 / 0.0.0.0 / 255.255.255.0 / U / 0 / 0 / 0 / mic0
0.0.0.0 / 192.168.1.253 / 0.0.0.0 / UG / 0 / 0 / 0 / mic0
------------------------------
[root@mic0 ~]# ifconfig
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:174 errors:0 dropped:0 overruns:0 frame:0
TX packets:174 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:19608 (19.1 KiB) TX bytes:19608 (19.1 KiB)
mic0 Link encap:Ethernet HWaddr 4C5A
inet addr:192.168.1.100 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MTU:64512 Metric:1
RX packets:12044 errors:0 dropped:3 overruns:0 frame:0
TX packets:5000 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1921304 (1.8 MiB) TX bytes:666988 (651.3 KiB)
sorunu çözemedik. Bu konuda yardımcı olabilir misiniz.
Son Giriş: 3 yıl önce
Son Mesaj Zamanı: 3 yıl
Mesaj Sayısı: 3
Gerçek Toplam Mesaj Sayısı: 3
İkinci El Bölümü Mesajları: 0
Konularının görüntülenme sayısı: 292 (Bu ay: 1)
Toplam aldığı artı oy sayısı: 0 (Bu hafta: 0)
En çok mesaj yazdığı forum bölümü: Web Tasarım - Programlama