0
Kayıt Ol

input ile veriyi nasıl güncellerim

2

●

74

  • 16-06-2022, 12:25:12
    #1
    SaLeh
    SaLeh
    Arkadaşlar bir php sayfasında wp_usermeta tablosunda "user_id" sutununa kullanıcı ID`ya ait "meta_key" sutununa ders adı "meta_value" sutununa ise "75" değeri girip kaydet demem gerekiyor. Bunu sonra input ile 75 değerini değiştirebileceğim kod lazım

    bilmem anlatabildim mi
  • 16-06-2022, 12:37:35
    #2
    mkozdogan
    mkozdogan
    database.php
    <?php
$servername='localhost';
$username='root';
$password='';
$dbname = "crud";
$conn=mysqli_connect($servername,$username,$password,"$dbname");
if(!$conn){
   die('Could not Connect My Sql:' .mysql_error());
}
?>
    insert.php

    <!DOCTYPE html>
<html>
  <body>
    <form method="post" action="process.php">
        First name:<br>
        <input type="text" name="first_name">
        <br>
        Last name:<br>
        <input type="text" name="last_name">
        <br>
        City name:<br>
        <input type="text" name="city_name">
        <br>
        Email Id:<br>
        <input type="email" name="email">
        <br><br>
        <input type="submit" name="save" value="submit">
    </form>
  </body>
</html>
    process.php

    <?php
include_once 'database.php';
if(isset($_POST['save']))
{     
     $first_name = $_POST['first_name'];
     $last_name = $_POST['last_name'];
     $city_name = $_POST['city_name'];
     $email = $_POST['email'];
     $sql = "INSERT INTO employee (first_name,last_name,city_name,email)
     VALUES ('$first_name','$last_name','$city_name','$email')";
     if (mysqli_query($conn, $sql)) {
        echo "New record created successfully !";
     } else {
        echo "Error: " . $sql . "
" . mysqli_error($conn);
     }
     mysqli_close($conn);
}
?>
    PDO Örneği
    <?php
$servername='localhost';
$username='root';
$password='';
$dbname = "crud";
try {
    $first_name = $_POST['first_name'];
    $last_name = $_POST['last_name'];
    $city_name = $_POST['city_name'];
    $email = $_POST['email'];
    date_default_timezone_set("Asia/Calcutta");
    $insertdate = date("Y-m-d H:i:s");
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    /* set the PDO error mode to exception */
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
   $sql = "INSERT INTO employee (first_name,last_name,city_name,email,datetime)
    VALUES ('$first_name', '$last_name','$city_name','$email','$insertdate')";
    $conn->exec($sql);
    echo "New record created successfully";
    }
catch(PDOException $e)
    {

        echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?>
  • 16-06-2022, 13:18:52
    #3
    SaLeh
    SaLeh
    mkozdogan adlı üyeden alıntı: mesajı görüntüle
    database.php
    <?php
$servername='localhost';
$username='root';
$password='';
$dbname = "crud";
$conn=mysqli_connect($servername,$username,$password,"$dbname");
if(!$conn){
   die('Could not Connect My Sql:' .mysql_error());
}
?>
    insert.php

    <!DOCTYPE html>
<html>
  <body>
    <form method="post" action="process.php">
        First name:<br>
        <input type="text" name="first_name">
        <br>
        Last name:<br>
        <input type="text" name="last_name">
        <br>
        City name:<br>
        <input type="text" name="city_name">
        <br>
        Email Id:<br>
        <input type="email" name="email">
        <br><br>
        <input type="submit" name="save" value="submit">
    </form>
  </body>
</html>
    process.php

    <?php
include_once 'database.php';
if(isset($_POST['save']))
{    
     $first_name = $_POST['first_name'];
     $last_name = $_POST['last_name'];
     $city_name = $_POST['city_name'];
     $email = $_POST['email'];
     $sql = "INSERT INTO employee (first_name,last_name,city_name,email)
     VALUES ('$first_name','$last_name','$city_name','$email')";
     if (mysqli_query($conn, $sql)) {
        echo "New record created successfully !";
     } else {
        echo "Error: " . $sql . "
" . mysqli_error($conn);
     }
     mysqli_close($conn);
}
?>
    PDO Örneği
    <?php
$servername='localhost';
$username='root';
$password='';
$dbname = "crud";
try {
    $first_name = $_POST['first_name'];
    $last_name = $_POST['last_name'];
    $city_name = $_POST['city_name'];
    $email = $_POST['email'];
    date_default_timezone_set("Asia/Calcutta");
    $insertdate = date("Y-m-d H:i:s");
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    /* set the PDO error mode to exception */
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
   $sql = "INSERT INTO employee (first_name,last_name,city_name,email,datetime)
    VALUES ('$first_name', '$last_name','$city_name','$email','$insertdate')";
    $conn->exec($sql);
    echo "New record created successfully";
    }
catch(PDOException $e)
    {

        echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?>
    Hocam teşekkür ederim ben amator olduğum için tam olarak belirlediğim sutunlardaki yerleri değiştirmem gerekiyor