دستور update در mysql

UPDATE table_name

SET column1=value,column2=value2,...

WHERE some_column=some_value

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

<?php

$servername="localhost";

$username="username";

$password="password";

$dbname="myDB";

// Create connection

$conn=newmysqli($servername,$username,$password,$dbname);

// Check connection

if($conn->connect_error){

    die("Connection failed: ".$conn->connect_error);

}

$sql="UPDATE MyGuests SET lastname='Doe' WHERE id=2";

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

    echo"Record updated successfully";

}else{

    echo"Error updating record: ".$conn->error;

}

$conn->close();

?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

<?php

$servername="localhost";

$username="username";

$password="password";

$dbname="myDB";

// Create connection

$conn=mysqli_connect($servername,$username,$password,$dbname);

// Check connection

if(!$conn){

    die("Connection failed: ".mysqli_connect_error());

}

$sql="UPDATE MyGuests SET lastname='Doe' WHERE id=2";

if(mysqli_query($conn,$sql)){

    echo"Record updated successfully";

}else{

    echo"Error updating record: ".mysqli_error($conn);

}

mysqli_close($conn);

?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

<?php

$servername="localhost";

$username="username";

$password="password";

$dbname="myDBPDO";

try{

    $conn=newPDO("mysql:host=$servername;dbname=$dbname",$username,$password);

    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

    $sql="UPDATE MyGuests SET lastname='Doe' WHERE id=2";

    // Prepare statement

    $stmt=$conn->prepare($sql);

    // execute the query

    $stmt->execute();

    // echo a message to say the UPDATE succeeded

    echo$stmt->rowCount()." records UPDATED successfully";

    }

catch(PDOException$e)

    {

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

    }

$conn=null;

?>

$sql="SELECT * FROM Orders LIMIT 30";

$sql="SELECT * FROM Orders LIMIT 10 OFFSET 15";

$sql="SELECT * FROM Orders LIMIT 15, 10";