divinedesigns1 Posted July 29, 2012 Share Posted July 29, 2012 hello, im trying to add a id from the db to this url <a href="admin/admin.php?action=home">Home</a> but when i try doing <a href="admin/admin.php?action=home?id=' . $display['id'] . '">home</a> it doesnt work, im not good at these kind of links at all i only know the normal way of doing this, but this time i have 2 options on 1 page n this way suits it better, can anyone please teach me how to do this? i also tried <a href="admin/admin.php?action=home&id=' . $display['id'] . '">home</a> but that doesnt work either Link to comment Share on other sites More sharing options...
birbal Posted July 29, 2012 Share Posted July 29, 2012 what does the link output? Link to comment Share on other sites More sharing options...
divinedesigns1 Posted July 29, 2012 Author Share Posted July 29, 2012 nothing it doesnt work, it suppose to pull the data from the db to be edit Link to comment Share on other sites More sharing options...
birbal Posted July 29, 2012 Share Posted July 29, 2012 (edited) have you check the source code? you have posted partial code. it is possible that it breaks the html somewhere. also instead of mixing single,double quote and concatenation oprator you can do like echo "<a href='admin/admin.php?action=home?id={$display['id'] }'>home</a>"; with better redability it reduces chances for typos and bugs. Edited July 29, 2012 by birbal Link to comment Share on other sites More sharing options...
divinedesigns1 Posted July 29, 2012 Author Share Posted July 29, 2012 have you check the source code? you have posted partial code. it is possible that it breaks the html somewhere. also instead of mixing single,double quote and concatenation oprator you can do likeecho "<a href='admin/admin.php?action=home?id={$display['id'] }'>home</a>"; with better redability it reduces chances for typos and bugs. ok ill try that now Link to comment Share on other sites More sharing options...
dsonesuk Posted July 29, 2012 Share Posted July 29, 2012 If you are echoing out the whole link echo '<a href="admin/admin.php?action=home?id=' . $display['id'] . '">home</a>'; just echoing out the id into html <a href="admin/admin.php?action=home?id=<?php echo $display['id']; ?>">home</a> Link to comment Share on other sites More sharing options...
divinedesigns1 Posted July 31, 2012 Author Share Posted July 31, 2012 If you are echoing out the whole link echo '<a href="admin/admin.php?action=home?id=' . $display['id'] . '">home</a>'; just echoing out the id into html <a href="admin/admin.php?action=home?id=<?php echo $display['id']; ?>">home</a> that doesnt work Link to comment Share on other sites More sharing options...
dsonesuk Posted July 31, 2012 Share Posted July 31, 2012 show us the code you are using to loop through db fields to apply id ref to link. Link to comment Share on other sites More sharing options...
divinedesigns1 Posted July 31, 2012 Author Share Posted July 31, 2012 (edited) if($action == "edit"){ // edit the blog created echo '<h3>Edit Blog</h3>'; if(isset($_GET['id'])){ $id = $_GET['id']; $sql = "SELECT * FROM article WHERE id='$id'"; $result = mysqli_query($con, $sql); }elseif(isset($_POST['id'])){ $id = $_POST['id']; $newquery = "SELECT * FROM article WHERE id='$id'"; $result = mysqli_query($con, $result); }else{ echo 'Please choose a blog to edit'; } if(isset($_POST['submit'])){ // making sure all fields are filled if not give out a error if(empty($_POST['tite'])){ // check to make sure the title is not empty echo 'Title is required'; }else{ $title = $_POST['title']; } if(empty($_POST['message'])){ // check to make sure the message isnt empty echo 'The Body Needs Some Test'; }else{ $message = $_POST['message']; } if(!empty($title) && !empty($message)){ // if both fields are fill $title = mysqli_real_escape_string($con, $title); $message - mysqli_real_escape_string($con, $message); $query1 = "UPDATE article SET title='$title', body='$message', user_id='" . $_SESSION['uid'] . "' WHERE id='$id'"; $result = mysqli_query($con, $query1); if($result){ echo 'Blog has been updated'; }else{ echo 'Blog was not updated' . '<br/>'; echo $title . '<br/>'; echo $message . '<br/>'; } }else{ $query2 = "SELECT * FROM article WHERE user_id='" . $_SESSION['uid'] . "' AND id='$id'"; $result = mysqli_query($con, $query2); $count = mysqli_num_rows($result); if($result){ while($grab = mysqli_fetch_array($result, MYSQLI_ASSOC)){ echo '<table><tr><td>'; echo '<form action="admin.php?action=edit=' . $grab['id'] . '" method="post">'; echo '<table><tr>'; echo '<td>Title: </td>'; echo '<td><input type="text" name="title" size="25" maxlength="255" value="'. $grab['title'] .'" /></td>'; echo '</tr>'; echo '<tr><td>Article: </td>'; echo '<td><textarea row="5" cols="40" name="message">' . $grab['body'] . '</textarea></td>'; echo '</tr><tr>' . '<td></td>'; echo '<td><input type="submit" name="submit" vaule="submit" /></td>'; echo '</tr><tr>'; echo '<td><input type="hidden" name="id" value="'. $grab['id'] .'" /></td>'; echo '</tr></table>' . '</form></td></tr></table>'; } }else{ echo 'Blog Could not be edit'; } } } // this is where editing a blog ends }elseif($action == "delete"){ // delete a blog created echo '<h3>Delete Blog</h3>'; } // this is where the deleting of any blog ends}else{ // if no action is set echo '<a href="admin.php?action=news">Create</a>' . ' '; echo '<a href="admin.php?action=edit">Edit</a>' . ' '; echo '<a href="admin.php?action=delete">Delete</a>' . ' '; echo '<hr/>'; $display = "SELECT * FROM article"; $result = mysqli_query($con, $display); if($result){ while($show = mysqli_fetch_array($result, MYSQLI_ASSOC)){ echo $show['title'] . ' - ' . $show['body'] . ' - ' . '<a href="admin.php?action=edit?id=' . $show['id'] .'">Edit</a>' . '<br/>'; } } // this is where the script to show the rows stop}}else{// check to see if the user is logged inif(!isset($_SESSION['uid'])){ echo 'Your Not Log In';}} the first part of this code, works perfectly fine no error nothing no suppression, etc. but it all wend down hill when i get to here Edited July 31, 2012 by DDs1 Link to comment Share on other sites More sharing options...
divinedesigns1 Posted July 31, 2012 Author Share Posted July 31, 2012 The script above holds the scripts that delete, create and edit, and displays the news also but getting the edit part to work, im not sure how to pull this off, i went around on other websites to see if i can fine an ideal in the url. lol you know those websites that always have some extra in its url Link to comment Share on other sites More sharing options...
birbal Posted July 31, 2012 Share Posted July 31, 2012 what problem are you facing now? is it still the same issue? Link to comment Share on other sites More sharing options...
dsonesuk Posted July 31, 2012 Share Posted July 31, 2012 check result without out if condition or on its own page to test if it retrieves and shows correctly without if else.also echo $show['title'] . ' - ' . $show['body'] . ' - ' . '<a href="admin.php?action=edit?id=' . $show['id'] .'">Edit</a>' . '<br/>'; should be echo $show['title'] . ' - ' . $show['body'] . ' - ' . '<a href="admin.php?action=edit&id=' . $show['id'] .'">Edit</a>' . '<br/>'; Link to comment Share on other sites More sharing options...
divinedesigns1 Posted July 31, 2012 Author Share Posted July 31, 2012 what problem are you facing now? is it still the same issue?yup same problemcheck result without out if condition or on its own page to test if it retrieves and shows correctly without if else. also echo $show['title'] . ' - ' . $show['body'] . ' - ' . '<a href="admin.php?action=edit?id=' . $show['id'] .'">Edit</a>' . '<br/>'; should be echo $show['title'] . ' - ' . $show['body'] . ' - ' . '<a href="admin.php?action=edit&id=' . $show['id'] .'">Edit</a>' . '<br/>'; that & is not work, but ill take it off of that page and place it onto a different page and see what happen, sorry about the late reply im also trying to do another project also Link to comment Share on other sites More sharing options...
birbal Posted July 31, 2012 Share Posted July 31, 2012 did you check the source of htm to see what does it print? Link to comment Share on other sites More sharing options...
divinedesigns1 Posted August 1, 2012 Author Share Posted August 1, 2012 did you check the source of htm to see what does it print?yeah it prints out http://localhost/blog/admin/admin.php?action=edit?id=2 and when i use the & sign inside of the url it prints http://localhost/blog/admin.php?action=edit&id=2 but nothing shows up Link to comment Share on other sites More sharing options...
birbal Posted August 1, 2012 Share Posted August 1, 2012 name value pairs should be seperated with & like dsonusk said. what do you mean it does not show anything? if your link is building up correctly next step will be to check edit.php why it is not working. Link to comment Share on other sites More sharing options...
dsonesuk Posted August 1, 2012 Share Posted August 1, 2012 The first querystring name/value always start with '?' before it, any additional querystring name/value from there on has a '&' before it. Link to comment Share on other sites More sharing options...
divinedesigns1 Posted August 1, 2012 Author Share Posted August 1, 2012 The first querystring name/value always start with '?' before it, any additional querystring name/value from there on has a '&' before it.ok thanks dsone, but imma put this on hold going to try complete the photo album project, since i figure out how to do it without the confusion hehehehehe Link to comment Share on other sites More sharing options...
divinedesigns1 Posted August 1, 2012 Author Share Posted August 1, 2012 name value pairs should be seperated with & like dsonusk said. what do you mean it does not show anything? if your link is building up correctly next step will be to check edit.php why it is not working.birbal, that script is in 1 file with the create script and delete script and the display script suppose to be on there also, but ill come back with to this topic, in a bit Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now