• 04-02-2021, 23:01:45
    #1
    Merhabalar. Yaklaşık 6 saattir çözmeye çalıştığım başlıktaki hatayı sizlere de danışmak istedim. Şimdiden çok teşekkürler.
    Datanın alındığı yer
    $('#registerForm').on('submit', function (e){
        e.preventDefault();
        var registerData = $(this).serialize();
        $.ajax({
            method: 'POST',
            url: '/register',
            data: registerData
        }).done(function (response){
            console.log(response);
        });
    });
    Datanın alıp iletildiği yer
    public function Register(){
            unset($_POST['WHERE']);
            $data = $_POST;
            $this->save('users', $data);
        }
    İşlemin yapıldığı yer
    namespace app\root;
    
    class Database
    {
        protected \PDO $db;
        public function __construct()
        {
            $this->db = new \PDO('mysql:host=localhost;dbname=farmroad;charset=utf8', 'root', 'xxx');
            $this->db->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
        }
        public function save($table, $data)
        {
            $columns = $this->findColumns($data);
            $params = $this->findParams($data);
            $statement = $this->db->prepare("INSERT INTO $table($columns)VALUES($params)");
    
    //        echo '<pre>';
    //            var_dump($statement, $columns, $params);
    //        echo '</pre>';
    //        exit;
    //        $bindPrepared = explode(',', $columns);
            foreach ($data as $final => $value) {
                $statement->bindValue(":$final", $value);
                var_dump($statement, $final, $value);
            }
            $statement->execute();
        }
        public function findColumns($data)
        {
            $enc = '';
            foreach ($data as $final => $values) {
                $final = $final.',';
                $enc .= $final;
            }
            return rtrim($enc, ',');
        }
        public function findParams($data)
        {
            $keys = array_keys($data);
            $sync = '';
            foreach ($keys as $key => $value){
                $sync .= ':'.$value.',';
            }
            return rtrim($sync, ',');
        }
    }
    var_dump çıktısı
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(4) "name"
    string(6) "İslam"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(7) "surname"
    string(4) "Saka"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(4) "mail"
    string(20) "islamsaka@icloud.com"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(5) "phone"
    string(12) "533 127 0000"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(8) "password"
    string(8) "jsX.2345"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(16) "confirm-password"
    string(8) "jsX.2345"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(8) "province"
    string(1) "1"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(8) "district"
    string(1) "1"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(12) "neighborhood"
    string(1) "1"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(8) "born_day"
    string(1) "1"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(10) "born_month"
    string(1) "1"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(9) "born_year"
    string(4) "2000"
    object(PDOStatement)#8 (1) {
      ["queryString"]=>
      string(274) "INSERT INTO users(name,surname,mail,phone,password,confirm-password,province,district,neighborhood,born_day,born_month,born_year,gender)VALUES(:name,:surname,:mail,:phone,:password,:confirm-password,:province,:district,:neighborhood,:born_day,:born_month,:born_year,:gender)"
    }
    string(6) "gender"
    string(1) "2"
  • 04-02-2021, 23:02:35
    #2
    Regnos.com
    resimler açılmıyor
  • 04-02-2021, 23:03:03
    #3
    mehmetakcay adlı üyeden alıntı: mesajı görüntüle
    resimler açılmıyor
    Düzeltiyorum hocam hemen codepen olarak eklemiştim. Şuan düzelmiş olmalı.
  • 04-02-2021, 23:08:23
    #4
    Regnos.com
    Hocam burdan çok birşey anlaşılmıyor. Fakat https://stackoverflow.com/questions/...rameter-number burası faydalı olabilir sql yapınızı burdaki gibi düzeltin
  • 04-02-2021, 23:20:47
    #5
    Anladığım kadarıyla linkteki arkadaş iki kez aynı ismi iki kez kullandığı için böyle olmuş. Lakin bende tekrarlanan bir şey yok hocam. Bakıyorum bakıyorum anlayamıyorum. Başka bir türlü yapılabilir belki ama şuan o da aklıma gelmiyor. Büyük bir çıkmazın içindeyim