Arama butonu
Bu konudaki kullanıcılar: 1 misafir
0
Cevap
247
Tıklama
0
Öne Çıkarma
Php veri giriş kodu
M
4 yıl
Er
Konu Sahibi

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");
?>

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>

main.php
<div class="body_wrapper frm-vh-md-100">
        <div class="header_top d-flex align-items-center justify-content-between">
            <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=151263705&url=#" class="logo" data-href="#" class="logo"><img src="assets/img/logo.png" alt=""></a>
            <p class="form_footer_text text-right">Veri Girişi [link=index--4.html]
                [/link]
            </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>
<div class="form-group">
                            <button type="submit" class="btn thm_btn thm_btn_green">VERİ TABANI SİL</button>
                        </div>
                </div>
            </div>
        </div>
    </div>

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>

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
);



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>


VERİ TABANI:

db: u7452_salon
user: u7452_user
password: 123654

tablo adı: salon
sutunlar :
1- id
2- url_link

DH forumlarında vakit geçirmekten keyif alıyor gibisin ancak giriş yapmadığını görüyoruz.

Üye olduğunda özel mesaj gönderebilir, beğendiğin konuları favorilerine ekleyip takibe alabilir ve daha önce gezdiğin konulara hızlıca erişebilirsin.

Üye Ol Şimdi Değil





< Bu mesaj bu kişi tarafından değiştirildi mehmetgunhan -- 27 Kasım 2021; 2:5:6 >

DH Mobil uygulaması ile devam edin. Mobil tarayıcınız ile mümkün olanların yanı sıra, birçok yeni ve faydalı özelliğe erişin. Gizle ve güncelleme çıkana kadar tekrar gösterme.