ThisisForReal

foreach ($_SESSION['threshold'] as $k => $v ) { if ($v > $_SESSION['compare']) { break; } $output = $k; } echo $output; That's the elegant solution I was looking for. Thanks so much! I really appreciate it.

I've never taken a logic class, or a CS class. This is likely very easy to anyone with any background in either topic. I have an array, $_SESSION['thresholds'], where I've given the array keys values such as "thresholdA", "thresholdB", "thresholdC", "thresholdD", etc. with corresponding elements that increase in value (5,15,50,75,etc.). They array is currently mapped in ascending order. I have a variable, $_SESSION['compare'], that I want to compare against all the elements in the $_SESSION['thresholds'] and, ultimately, I want to be able to echo/print the key of the largest array element that is less than the value of $_SESSION['compare']. Using the above values, if $_SESSION['compare'] == 21, then I would love to echo/print "thresholdB". What's the best method to accomplish this? Array_Walk? A switch statement? I first tried while() and was trying to use the pointer in the array, but I found that if I used next() to see if the next array element was larger, the actual use of next() within the while() statement caused the pointer to advance anyways. That seemed like the wrong path to take. The switch statement I've tried is failing, and I don't know how to use a comparison within an array_walk when I want to break out once the largest value is determined. This seems like such a basic function of array and variables but I'm struggling with this. Any advice would be much appreciated. Here's some of my tests that failed: reset($_SESSION['thresholds']); while( (current($_SESSION['compare']) < $_SESSION['thresholds']) and (key($_SESSION['thresholds']) <> 'thresholdMAX')) next($_SESSION['compare']); That final next() statement advances me one step too far. Should I use this and then backup one step? That might create problems of its own. Next I tried switch: switch ($_SESSION['compare']) { case ($_SESSION['compare'] >= $_SESSION['thresholds']['thresholdMAX']): $output = key($_SESSION['thresholds']['thresholdMAX']); break; case ($_SESSION['compare'] >= $_SESSION['thresholds']['thresholdD']): $output = key($_SESSION['thresholds']['thresholdD']); break; But that wasn't working and seems like the wrong way to go about this. Can anyone point me in the right direction? Thanks so much in advance!

I'm fairly new to using AJAX and JQUERY to call back to the server, process a form's contents, and then update a div file accordingly. This new project has almost everything in a single div (id="mainContent"). This is the <div> that I will be updating through the ajax call. My div has a lot of different hyperlinks at the moment (text, image, and form submit button). I know how to do an update for a page that has a single form with a single submit button. In order to turn my site into an ajax driven site, should I take all these image links and wrap individual forms around them? What about the text links? It all seems very cumbersome and I'm curious how you experts would tackle the issue. Any assistance on best practices would be greatly appreciated! Thanks in advance.

Excellent - I found the output buffering option on my WampServer and turned that off. Now I'm getting similar behavior in both production and development. Thank you for that tip. With regard to the error, I'm not getting any warning/failure text from php. (Caveat: I haven't yet adhered to the header() sticky at the top of this forum about logic placement) I'm just seeing my gif background, the header, and then an empty div box that holds the usual content. I'm guessing that's still a standard header error issue. I am still perplexed why my site worked great for months on end and all of a sudden it is giving me fits now. It would never be a browser issue, right - the problem rests on the server side? Thanks again for such awesome community feedback. For us self-taught folks, it's wonderful.

I have a web site with a user login requirement that has worked splendidly for months. I also have a development version of my site on my laptop, localhost. At the moment, I have identical code on both the development and production sites. I'm getting some header error in production, but not on development. Is it guaranteed that my page is generating some white space, or is it possible that there may be another issue at hand (I'm fairly non-technical, so I'm grasping here - my web host upgraded to a different PHP version that is creating whitespace in production while development on my laptop is a different version of php, my web host has done something else that is causing this, fill in the blank with your own conspiracy theory)? Any reading material out there (besides the php.net manual) that explores what may be going on? Thanks in advance - this community has been wonderfully helpful for me over the last year!

Does this method work if my form is NEVER going to get submitted (I won't even have a submit button). I'm going to use serialize to collect and arrange the form data, and send it off to my php file that will process and then update the divs on the user's page. The user would then modify their selection and press the button again. My understanding is that if I was using an input submit button, I would need a catch to prevent the submit from fetching the action="" page. Whereas, by using a button, I wouldn't have to worry about catching any action.

This is my first attempt at ajax using jquery. I've successfully done ajax without jquery borrowing someone else's tutorial where I used onkeyup="showHint(this.value)" to provide search hints for my online movie database, but I want to learn jquery yet am struggling. I'm inept with OOP, and I have zero javascript experience (aside from using scripts from others that have been made publicly available). Background: I'm attempting to use the jquery serialize() function to take the contents of a form, send it over to a php file through the use of a button, <button type="button">, "submit_test.php" (preferably via post), where I'll do all my crazy php processing. When submit_test.php is finished, I'll have strings (in html format, I guess, with "<p>" and "<br />" mixed in) which I'll use to update 2 divs on my original page. This is what has been tripping me up. I've been able to demonstrate that I'm serializing the data into a format that I want via this jquery script (which displays the string): <script> function showValues() { var str = $("form").serialize(); $("#results").text(str); } $(":checkbox, :radio").click(showValues); $("select").change(showValues); showValues(); </script> I just need help passing that along to submit_test.php My questions are basically syntax: <script type="text/javascript" language="javascript"> $( '.button' ).click(function() { function(){ var data = $(this).serialize(); $.post( "submit_test.php", { action: "ajax_verify_form", data: data }, function(response){ $('#div_1').html($('#inner_1' , resp).html()); alert(response); return false; } ); return false; } ); </script> var data = $(this).serialize(); <-- I doubt I'm doing this right. data: data <-- this is probably troublesome, too. Can someone explain what would typically go in the var data = ..., and how that relates to the data: piece of the script? I feel like I'm so close, but every tutorial I've googled thus far is doing something different than what I'm trying to accomplish and I just haven't been able to put it together yet. To see the page, I've got it stripped down to just the part at hand here: http://www.cv-industries.com/ajax_test Thanks so much in advance for any assistance you can provide!

Look at that! Didn't know there was a substr_count() function. Much thanks.

I'm not a programmer, so sometimes the php.net/manual reads like a foreign language to me. I have a quick interpretation question: I'm generating data in PHP for a MySQL stored procedure that has two comma separated value inputs. The second input is always a series of 0's and 1's. I'm trying to count the number of 1's for the second input (in the example below, it would be "3"). Example input sent to MySQL: $query_resolve = "CALL spParticipant_Test ('188,216,342,81,117,56','0,1,1,0,0,1')"; http://www.php.net/manual/en/function.count-chars.php is mostly helpful, but I am hoping for clarification on the mode I want to run. Do I want to run mode "1"? Thanks so much for any feedback!

I found the answer - use chr(13) and chr (10). See code here: $chr = chr(13) . chr(10); $members_string = implode($chr,$list_of_members); Thanks to Maven1 at php.net.

$members_string = implode('\n\n',$list_of_members); //I'm trying to put the carriage new line here Ignore that earlier alternate array name. I try to change names before posting to this forum so that things are easier for you all to follow. Missed that one.

No luck on a variety of attempts to populate the string with various forms of \n, inside double quotes, single quotes, with \r, without it. So I'll back up a moment and show the bigger picture and see if someone knows a better solution to my dilemma. Objective: Send an email using php's mail() to a group leader that will show all the members of the group. Since I'm sending a bit more information than just the name of each member, formatting the email is KEY. My Approach: The easiest way to format the letter to be legible is to insert a carriage return or new line after each member. To do that I tried the following: list_of_members = array(); foreach($member_first as $key => $value) $list_of_members[$key] = $value . ' ' . $member_last[$key] . ' | ' . $class[$key] . ' | ' . $join[$key]; $members_string = implode('\n\n',$part_line); //I'm trying to put the carriage new line here Now I have one string that contains all the members with the '\n\n' between each member. When inserting this into the body of the email, I thought the contents would create new lines in the email. // Send Email $to = "$email"; $subject = "Members of your group"; $message = "Hello $admin,\n\nThis is the list of members to your group:\n$members_string" . "\n\nRegards,\r\n Team Leader Alpha\n\n"; $headers = 'From: [email protected]' . "\r\n" . 'Reply-To: [email protected]' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($to, $subject, $message, $headers) or die("Email was not sent"); The reality is that while all other carriage returns work, the email shows the member string verbatim without following the direction of the new line command (example follows:): What other method could I use to get the formatting in the email to allow for a carriage return between each member? Thanks!

So if when concatenating the $string, if I build it with double quotes that will work? I'll give it a try.

I'm working on a project where I have concatenated a string that lists all of the members of a group and want to email them to the group administrator. An example string may look like this: $string = 'Mark Ruiz | class A | January 7, 2010\n\nJason Adams | class B | January 9, 2010.\n\nDan Hernandez | class A | March 4, 2010.'; When I put that into the message of my email: $body = "Hello $admin,\n\nThis is the list of members to your group:\n$string." The \n\n that separates each member in the string is still considered part of the string, so the email doesn't recognize that it should start a new line. Does anybody know a good work around to this problem? Thanks so much!

I think that's what I'm looking for. Appreciate it!

Disclaimer: I'm very new to MySQL. I'm looking for direction on good keywords, resources to google to learn best practices on this topic. I have a MySQL database that contains upcoming events with host and participant tables and RSVP deadlines. Hosts and participants access the dB through PHP. Rather than have hosts log in to the site after the rsvp deadline passes to get the info they need, I want to learn how to make the server check every 15 minutes to see if any RSVP deadlines have passed. When it finds events with just expired rsvp deadlines, then execute a stored procedure (yet to be written) that will allow me to email the hosts all the pertinent information. I understand that the MySQL event scheduler alone won't enable me to perform all the tasks I need to do (and from what I can gather, events are not preserved and are removed upon final execution). If anyone can provide me with a good place to learn how to go about setting up a ... and here's how new I am - don't even know how to describe what I'm looking for - a module or framework for creating this routine, I'd be very grateful. Is it some sort of php proxy that stays open somewhere, or is it initiated on the MySQL side? What's the best practice for this type of action? Thanks so much!

An elegant solution. Thank you so much. For anyone that visits this thread, here's how I handled your info: //If the submit button is pressed if ((isset($_POST['submit_x'])) || (isset($_POST['submit']))) { $retrieve = array(); $retrieve = $_POST['button_array']; foreach($retrieve as $key => $value) { $query_resolve = "CALL db.spConfirmParticipant ('$key','$value')"; }

Hello my super smart helpers! To one of you, this is super easy, but it's definitely a pain in my butt because it's very new to me. I am creating an html form in PHP that generates a series of radio buttons to report about who showed up (list of names with 'yes' and 'no') for a dynamic number of participants to a dynamic number of events. No trouble creating the form - works great. An abbreviated (but all necessary info shown) snippet of the code is below. I'm just having trouble taking the $_post data and being able to extract the keys and values into a method that I can comfortably use them. I will use them by running a loop and calling a mysql stored procedure for each participant and their attendance (yes or no). Here's how the form is generated (code has been trimmed but all necessary info is there): <?php //Get the list of all unresolved events $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $query = "CALL db.spGetUnconfirmedEvents ('$admin_code')"; $data = mysqli_query($dbc,$query); ?> <div id="mainContent"> <form method="post" action=""> <?php while ($event_list = mysqli_fetch_array($data)) { $eventID = $event_list['eventID']; echo '<tr><td>Participant</td><td colspan="2">Attended?</td></tr>'; //Fill with participants from that event $query_participants = "CALL db.spViewParticipants ('$event')"; $data_participants = mysqli_query($dbc,$query_participants); while ($participants = mysqli_fetch_array($data_participants)) { //every ID is unique for all events (no 2 events will have any common ID's between them) $participantID = $participants['eventParticipantID']; $part_first = $participants['firstName']; $part_last = $participants['lastName']; echo '<td>' . $part_first . ' ' . $part_last . '</td><td><input type="radio" name="' . $participantID . '" value="1" checked>Yes</td>'; echo '<td><input type="radio" name="' . $participantID . '" value="0">No</td></tr>'; } } </table> ?> <input type="image" border="0" value="Resolve" name="submit" src="images/button_alert_okay.png"/></form> As I mentioned before, that part works great. When the administrator hits submit, each unique participant ID has a 1 or a 0 associated with it. It's just using the post data that is giving me trouble: <?php //If the submit button is pressed if ((isset($_POST['submit_x'])) || (isset($_POST['submit']))) { $retrieve = $_POST; If I run a print_r on the $retrieve array, I get something like this: [22] => 1 [37] => 0 ...(output shows every participantID and the respective 1 or 0 for yes/no)...... [submit_x] => 62 [submit_y] => 19 [submit] => Resolve I have a sproc ready to call to mysql that handles the business logic of resolving the attendance lists of these previous events since the admin last logged into the sight. I've tried a half dozen ways to loop through the array and submit each set of keys and values to my stored procedure: /* -- Name : spConfirmParticipant -- Desc : Confirms participant to have attended the event or not -- Inputs : (participantID INT, attendFlag INT 1/0 = attend, not attend ) -- Outputs : (nothing) */ Because my participantIDs are unique and autoincrement, they will eventually become very large. So I need an efficient way to grab them. I've played around with using regular expressions with the array_keys command to try to build a new array but I know there's got to be a really easy method. I'm sorry my question is a little more open ended than usual but - any suggestions?

I'm currently storing some date and time information in a MySQL column that has a date time format: "2010-06-04 17:35:00". I am in an html table using php's foreach { to cycle through my query results and create <td> tags to separate the date and time into separate columns within the table. e.g. echo '<td>' . $date . '</td><td>' . $time '</td>'; I would love to display the data to the user in a more useful format ("June 4", "5:35 pm"). I know that to do that I'd be using PHP's 'M' and 'j', for one column and 'g' 'i' and 'a' for the other. I am having a total brainfart on transforming the data for display (that, and I'm new to php). You don't need to point it out, but as you can imagine I'm getting the server time returned to me, instead of what's in my DB table: foreach($meals as $display) { $date = $meals['mealDateTime']; $date = date('M j'); $time = $meals['mealDateTime']; $time = date('g:i a'); echo '<tr><td>'; echo $date; echo '</td><td colspan="4">'; echo $time; echo '</td></tr>'; } I'm just asking what the proper syntax is to get the datetime value returned in my query and use the php date functions to display it correctly. Thanks so much!

The free IP address geolocation SQL databases from ipinfodb have some step by step guides and a decent forum/tutorial on how to use it, if that helps. http://ipinfodb.com/ip_database.php

genius... and while working on a concurrent issue (doing an array_push) I was just about to discover the answer. Thank you so much for your help!

My friend and I are working on a website. He is doing all the database operations, and I'm coding the PHP. Neither of us are very well versed in this exciting world of coding and database design, but we're learning fast. He created a stored procedure for updating a table. When a user updates the form on our website, the stored procedure is called and the table is successfully updated in mysql. To verify (and thus redirect the user to the appropriate page), the stored procedure ends by selecting 1 if successful, else 0. We have tested this by running the stored procedure in mysql workbench (see attachment below). On my end, I'm having trouble using the 'select 1' that he is sending me. I've run gettype and echoed the variable, and it tells me that I'm working with an array, but it won't tell me whether it's a 1 (successfully updating table). It simply says you have an array, and when I do my if{ and ask whether the value of the array is a 1 (or if I merely ask to echo the value), I can't work with the result. We're trying to return a 1,0 result while keeping the load on our database to a minimum. We could modify the stored procedure to perform logic on its end and return a 1 or a 0 from a table, but that sounds like a foolish way of solving the problem. Does anyone know the sql terminology he needs to use to send me an array that I can work with. Or am I making the error? (For reference, my php code is below). $query = "CALL mealshare.spUpdateGroup('$mtgid','$description','','','','','$target')"; $data = mysqli_query($dbc,$query) or die('Could not execute the command'); $answer = mysqli_fetch_array($data); echo '<p> first is gettype answer<br />'; //my attempt at debugging (see picture attachment) echo gettype($answer); echo "$answer"; echo $answer; if ($answer == 0) {... Hope all that was clear as mud. [attachment deleted by admin]

I changed it to: if ((isset($_POST['submit_x'])) || (isset($_POST['submit']))) { and now it works in all browsers. Thanks to PFMaBiSmad for his earlier help, which I did not fully understand until now. http://www.phpfreaks.com/forums/index.php/topic,298638.msg1414138.html#msg1414138

Sorry about that. At the time I started this thread, I did not think the issue would wrap back into the first thread like it has. I had created the new page and had the form working properly, which led me to believe I had an error somewhere in my php. I'm going to go back to your response in the other thread and try to figure it out once again.

Final comment from me, I promise. Just so we're all clear now, with the if(isset($_POST piece added to the code, IE will work if I use the original boring old gray type="submit" in a form, but not when I use a type="image" (though the other major browsers will work in either situation). I guess this has become a html question again, sorta...