Form Doesn't Send Values Or PHP Code Doesn't Update

Question

FORM

<form method="post" action="menu_duzenle_islem.php">
Şuanki İsim : <input name="menu_isim" value="<?php echo $_POST['menu_isim'] ?>"readonly>
Yeni İsim : <input name="yeni_menu_isim" placeholder="isim giriniz.">
Şuanki URL : <input name="menu_url" value="<?php echo $_POST['menu_url'] ?>"readonly>
Yeni URL : <input name="yeni_menu_url" placeholder="url giriniz">
<input type="submit" value="Düzenle">
</form>

menu_duzenle_islem.php

<?php
$con=mysqli_connect("localhost","root","","mmogezgini");
mysqli_query($con,"UPDATE menuler SET isim='$_POST[yeni_menu_isim]' and url='$_POST[yeni_menu_url]'
WHERE isim='$_POST[menu_isim]' AND url='$_POST[menu_url]'");
mysqli_close($con);
Header("Location:menuler.php");
?>

when i update "menu_isim" and "menu_url" menu_isim showing "0" and menu_url doesn't change.

MySQLi supports multiple statements per query. If you dont escape/bind/prepare your parameters, this is easy way to SQL inject and drop or change all your tables — Daniel W.
– Daniel W., Commented Oct 2, 2013 at 11:09
not only is this bad practice syntax: "'$_POST[menu_isim]'", use this: "..." . $_POST['menu_isim'] . "...." — Daniel W.
– Daniel W., Commented Oct 2, 2013 at 11:10
@DanFromGermany Thank you for advice i will search for escape function right now. — Mehmet Altıntaş
– Mehmet Altıntaş, Commented Oct 2, 2013 at 11:33

Pupil · Accepted Answer · 2013-10-02 11:07:06Z

2

Your SQL query is not correct, refer the following:

mysqli_query($con,"UPDATE menuler SET isim='". $_POST['yeni_menu_isim']."' ,url='".$_POST['yeni_menu_url'] ."'
WHERE isim='".$_POST['menu_isim']."' AND url='".$_POST['menu_url']."'");

answered Oct 2, 2013 at 11:07

Pupil

24k6 gold badges50 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mehmet Altıntaş Over a year ago

Thanks it works but why people downvote me this is not for ask what you dont know and answer what you know for helping each other? a time later i will couldn't ask questions :(

Collectives™ on Stack Overflow

Form Doesn't Send Values Or PHP Code Doesn't Update

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related