₦airaland Forum

<div class="modal fade" id="modal-form" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
<h4 class="modal-title" id="myModalLabel">Edit Post</h4>
</div>
<div class="modal-body">
<?php
$amala = "SELECT * FROM page_timeline WHERE timelineID='$postID' ORDER BY timelineID DESC";
$fufu = $db->query($amala);
while($rop = $akpu->fetch_array())
{
$post_modify = $rop['post'];
?>
<form role="form">

<div class="form-group">
<textarea cols="60" name="pq2" class="wysihtml form-control" style="height: 75px" size="10" ><?php echo $post_modify; ?></textarea>
</div>

</form>

</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary">Save changes</button>
</div>
</div>
</div>

</div>
<?php } ?>

maekhel:
First of all where is $postID coming from?

adewasco2k:
All you need is the HTML5 data attribute

add this data-id="$id" to the post you are editing then you can use element.getAttribute('data-id') to get the id of the post.


i dont really understand your question but this will help

maekhel:
First of all where is $postID coming from?

cbrass:
From a previous code above

maekhel:
Why not attach the post id to the edit link then use the id in your where clause in your update query

cbrass:
That will only work if I want to redirect to another page but it's a pop up containing a textarea below that I want to use I don't want ppl to go to another page. You know like Facebook edit where you stay on your timeline when you be ant to modify a post

<a href="javascript:void(0)" ahr="23">Edit</a>

maekhel:
Why not attach the post id to the edit link then use the id in your where clause in your update query

onyengbu:
I am on mobile and can offer very limited help here.
However, your issue have a very very simple solution. Since you are using query, there a lot of possibilities.
You can just use add an attribute to the a href link that launches the modal box. By attribute I mean id, rel, class or even non HTML imagined ones that is only if you have ran out of standard HTML attributes for that element.
JQuery will recognize it. Let's say you added an attributed named ahr to the link, and the link looks like this:

<a href="javascript:void(0)" ahr="23">Edit</a>

, you can create a variable from it in jquery like this: var thisID = $(this).attr("ahr";
With this, you can then use query load() to load the db returned values specific to the query variable - thisID into the text area or content editable div where you can modify the db content and then send back via query/ajax request.

I will create a complete sample code when I get to a PC.

cbrass:
Am very greatfull sir, thanks alot

onyengbu:
Good. Have you done it?