Unable to delete mysql data from php

Question

I have successfully connected to database and published mysql data on web and manually added joke on it.Screenshot of what output looks like is provided here.

When i manually enter the corresponding id of joke inside the textbox and press delete button, it deletes the joke corresponding to that it. But when i click on the delete button directly, that joke isn't deleted. How to update value of that textbox ? For the time being, i have made input type of textbox as text so to see whats going inside it. I am using PHP version: 7.1.1 and Apache/2.4.25 (Win32.

<p><a href="?addjoke">Add your own joke</a></p>
<p>Here are all the jokes in the database:</p>
<?php foreach ($jokes as $joke) : ?>
  <form action ="?deletejoke" method='post'>
  <blockquote>
    <p><?php echo htmlspecialchars($joke['text'], ENT_QUOTES, 'UTF-8');?>
    <input type = "text" name = "id" value = "<? php echo $joke['id']; ?>">
    <input type = 'submit' value = 'Delete'>
    </p>
  </blockquote>
</form>

Screenshot of Mysql database is provided here.

where is the php code?

Mazz
– Mazz

2017-03-17 09:39:48 +00:00
Commented Mar 17, 2017 at 9:39 — Mazz
– Mazz, Commented Mar 17, 2017 at 9:39
delete the space between ? and php

LordNeo
– LordNeo

2017-03-17 11:56:24 +00:00
Commented Mar 17, 2017 at 11:56 — LordNeo
– LordNeo, Commented Mar 17, 2017 at 11:56

Victor Radu · Accepted Answer · 2017-03-17 09:40:07Z

2

there is a space between <? and php on the input value it should be <?php; then it should work.

<input type = "text" name = "id" value = "<? php echo $joke['id']; ?>">

answered Mar 17, 2017 at 9:40

Victor Radu

2,3121 gold badge13 silver badges18 bronze badges

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

2 Comments

Masivuye Cokile Over a year ago

@AbhayaSinghPandey accept the answer, that informs the community that solution was found

Abhaya Singh Pandey Over a year ago

five minutes is still remaining before i can accept it as final solution. As soon as time period to perform this action begins, i wll mark it as accepted.

Simon Müller · Accepted Answer · 2017-03-17 09:42:35Z

1

<input type="text" name="id" value="<?php echo $joke['id'];?> ">

you should remove the spaces (not just in this line)

answered Mar 17, 2017 at 9:42

Simon Müller

4511 gold badge4 silver badges17 bronze badges

Comments

modsfabio · Accepted Answer · 2017-03-17 09:43:46Z

1

Change

<input type = "text" name = "id" value = "<? php echo $joke['id']; ?>">

to

<input type = "text" name = "id" value = "<?php echo $joke['id']; ?>">

answered Mar 17, 2017 at 9:43

modsfabio

1,1371 gold badge13 silver badges31 bronze badges

Collectives™ on Stack Overflow

Unable to delete mysql data from php

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related