472,352 Members | 1,533 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,352 software developers and data experts.

Updating a MySQL table value through HREF link

AutumnsDecay
170 100+
Hey everyone.

I have been writing a testimonials backend for a client who wishes to use the feature. How it is supposed to work is like this:

The user writes a testimonial of their experience at the salon into a basic HTML form. When the user clicks send it runs a PHP script inserting it into a MySQL table.

The table has 4 fields: id, msg, name, active

When the testimonial is submitted it obtains a default value of 0 for the 'active' field. This makes the testimonial 'inactive'.

The salon owner wants to login and see all the pending testimonials (where active = 0). She can then review each one individually. If she wants to accept that testimonial she then clicks on the 'Activate' link, which will update the active value for that testimonial ID to 1 instead of 0.

When users come to the website one random testimonial will be pulled where the active value is 1 (meaning its active). Each time the page is loaded it will be a different one, again where the active value is 1.

My question is how to set the active value to 1. I've been trying an array of different codes, both written by me for this piece or by other developers who've freely posted simple solutions. I'm at a loss and it's needed by tomorrow morning.

Here's the code for what I have tried, most recently.

Expand|Select|Wrap|Line Numbers
  1. <?
  2.              if($_SESSION['access'] == 1)
  3.             {
  4.             $db = new DB();
  5.             $rows = $db->getRows();
  6.             $id = $_REQUEST[$row["id"]];
  7.             $str = "SELECT * FROM testimonials WHERE active = 0";
  8.             $db->query($str);
  9.             $rows = $db->getRows();
  10.             foreach($rows as $row)
  11.             print '<div style="border: 1px dotted #fff; padding: 5px; width: 400px; margin-bottom:10px;"><b><u>' . 
  12.             $row["name"] . '</b></u><br />' . $row["msg"] . '<br/><p align="left">Testimonail ID ' . $row["id"] . ' - 
  13.             <a href="testimonialsindex.php?mode=activate"><img src="images/activate.jpg"></a><br/></div>';
  14.             }    
  15.             else
  16.             {
  17.             print 'You are not logged in! Please login to view this page.';
  18.             }
  19.  
  20.         //if logged in, add a javascript file
  21. if($_SESSION['access'] == 1)
  22. {
  23.     if($_REQUEST['mode'] == 'activate')
  24.         {
  25.         $db = new DB();
  26.         $db->query("UPDATE testimonials SET active 1 WHERE id = " . $row["id"]);
  27.  
  28.         }
  29.     }
  30.  
  31.  
  32. ?>
  33.  
I really need help and hope that somebody will able to help me.

Thanks very much!
Feb 15 '09 #1
11 7399
Markus
6,050 Expert 4TB
Are you just trying to update the value in the MySQL table?

If so, check out MySQL UPDATE. Otherwise, could you explain a little more concisely?
Feb 15 '09 #2
AutumnsDecay
170 100+
Well that helped a little bit, Markus. It now updates the table value, however it's only letting it activate from bottom to top.

What I mean is this:

I have the testimonials displayed vertically like so:

-------------------------------------
| Name: Mat |
| this place is great! |
| |
|Testimonial ID 1 |
------------------------------------

-------------------------------------
| Name: Sandy |
| this place is rocks! |
| |
|Testimonial ID 2 |
------------------------------------

-------------------------------------
| Name: Liz |
| this place is cool. |
| |
|Testimonial ID 3 |
------------------------------------


I have to activate ID 3 first, then ID 2, then ID 1. I can't just choose one from the list to activate. Let's say I want to leave ID 3 and ID 2 in pending (active = 0) and activate ID 1, I'd have to activate all three and then unactivate ID 3 and ID 2 from a seperate page.

Why's that happening?
Feb 15 '09 #3
hoopy
88
You have to pass the ID in the URL string..

So something like:

<a href="testimonialsindex.php?mode=activate&id=ID_OF _THE_RECORD">

Then when you do the update only update that ID.
Feb 15 '09 #4
AutumnsDecay
170 100+
Excellent. I had tried that once before but wasn't sure if it would work. Used the '&id=' thing, and had the 'activate' mode use the $_GET to obtain the id from the url.

It works perfectly.

Thanks.
Feb 15 '09 #5
AutumnsDecay
170 100+
Hmm. I have to refresh in order for the testimonial to not be displayed. I've included a 'header' function into my script but when the page is loaded I get the

Warning: Cannot modify header information - headers already sent by (output started at...

error. Is there anyway I can add a refresh or header into my script? Here's what it looks like now, by the way:

Expand|Select|Wrap|Line Numbers
  1.  <?
  2.              if($_SESSION['access'] == 1)
  3.             {
  4.             $db = new DB();
  5.             $rows = $db->getRows();
  6.             $str = "SELECT * FROM testimonials WHERE active = 0";
  7.             $db->query($str);
  8.             $rows = $db->getRows();
  9.             foreach($rows as $row)
  10.             print '<div style="border: 1px dotted #fff; padding: 5px; width: 400px; margin-bottom:10px;"><b><u>' . 
  11.             $row["name"] . '</b></u><br />' . $row["msg"] . '<br/><p align="left">Testimonail ID ' . $row["id"] . ' - 
  12.             <a href="testimonialsindex.php?mode=activate&id='. $row["id"] .'"><img src="images/activate.jpg"></a><br/></div>';
  13.             }    
  14.             else
  15.             {
  16.             print 'You are not logged in! Please login to view this page.';
  17.             }
  18.  
  19. ?>
  20.  
  21. <?        
  22. if($_SESSION['access'] == 1)
  23.     {
  24.     if($_REQUEST['mode'] == 'activate')
  25.         {
  26.         $db = new DB();
  27.         $id = $_GET['id'];
  28.         $db->query("UPDATE testimonials SET active='1' WHERE id =" .$id);
  29.         header ('Location:testimonialsindex.php');
  30.         }
  31.     }
  32. ?>
  33.  
That's how the the testimonials are printed, and then the lower half is how they're activated. I would think that if an 'IF' statement were present it would be okay to have the header in there to automatically 'refresh' the page. However, it won't.

Suggestions?
Feb 15 '09 #6
Markus
6,050 Expert 4TB
You're updating the records after you have displayed them. Do it the other way around. No need for a header refresh.
Feb 15 '09 #7
hoopy
88
You cant send a header request having already sent data, You would do better to have your update before the display so using your code something like:

Expand|Select|Wrap|Line Numbers
  1. <?
  2. if($_SESSION['access'] == 1)
  3. {
  4. if($_REQUEST['mode'] == 'activate')
  5.   {
  6.   $db = new DB();
  7.   $id = $_GET['id'];
  8.   $db->query("UPDATE testimonials SET active='1' WHERE id =" .$id);
  9.   header ('Location:testimonialsindex.php');
  10.   }
  11. }
  12.  
  13. if($_SESSION['access'] == 1)
  14. {
  15.   $db = new DB();
  16.   $rows = $db->getRows();
  17.   $str = "SELECT * FROM testimonials WHERE active = 0";
  18.   $db->query($str);
  19.   $rows = $db->getRows();
  20.   foreach($rows as $row)
  21.   print '<div style="border: 1px dotted #fff; padding: 5px; width: 400px; margin-bottom:10px;"><b><u>' . 
  22.   $row["name"] . '</b></u><br />' . $row["msg"] . '<br/><p align="left">Testimonail ID ' . $row["id"] . ' - 
  23.   <a href="testimonialsindex.php?mode=activate&id='. $row["id"] .'"><img src="images/activate.jpg"></a><br/></div>';
  24.   }    
  25.   else
  26.   {
  27.   print 'You are not logged in! Please login to view this page.';
  28. }
  29. ?>
Feb 15 '09 #8
Markus
6,050 Expert 4TB
... deja vķ
Feb 15 '09 #9
AutumnsDecay
170 100+
I'm now getting this error:

Warning: Cannot modify header information - headers already sent by (output started at /home/hairstre/public_html/testimonialsindex.php:20) in /home/hairstre/public_html/testimonialsindex.php on line 42

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/hairstre/public_html/lib/db.php on line 53

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/hairstre/public_html/lib/db.php on line 57

I switched up my code with the code that hoopy posted. It did refresh correctly, however with those errors above the testimonials.

Any ideas?
Feb 15 '09 #10
hoopy
88
I dont understand why you are calling $rows = $db->getRows(); before even running a query. Can you just post all your code as this refers to line 42.
Feb 15 '09 #11
AutumnsDecay
170 100+
I didn't realize I had that in there.

Removed it and the header function. Works great.

Thanks guys.
Feb 15 '09 #12

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Mark Pacey | last post by:
Hi, I have a web page that gets info from a mySQL database for various items, and slaps that info, along with pics onto the page. ( in a shopping...
0
by: Ron Hocking | last post by:
When I link a MySQL table containing a TIME column to Microsoft Access the value does not display. If I edit the value it updates correctly in mysql...
0
by: beary | last post by:
I am using php5 with mysql and also using excel 2003 running on winxp. Anyway, I am currently opening my excel.xls file, then saving as csv file,...
11
by: kennthompson | last post by:
Trouble passing mysql table name in php. If I use an existing table name already defined everything works fine as the following script illustrates....
1
by: Franky | last post by:
I want to use a query that will update a table if a specific entry exists, or inserts the data if it doesn't. The code below shows what i have so far...
4
by: mramsay | last post by:
Hi, I'm having a real problem creating a dynamic hyperlink for my website. I want to pull the field name from mysql table. Field name is...
10
by: help4me | last post by:
I am having trouble updating a table. The logic seems so simple but I just canít get it to work. The table is named test. The column names are...
1
osward
by: osward | last post by:
Hi all, I got code over the net for paging mysql table, it provides Prev pages Next link at the bottom of the table. However, I have a pretty...
2
pradeepjain
by: pradeepjain | last post by:
hii ppl, I have a small prob.i need to feed some things to DB table manually . say a date which will be common to around 10 id's . So i...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.