mishasoni

Great, thanks!

Does anyone know how (or if it's possible) to generate a thumbnail from a PDF using PHP? I have a page where users can upload a pdf file, which then posts on another page. I'd like to either be able to create a thumbnail of the pdf cover upon uploading, or on the fly from within the post page. If anyone knows how to accomplish this, any insight would be greatly appreciated!

Newbie here! I am desperate for some help on a mySQL error I have encountered. I have a results page with a repeat region pulling records from a dB. When executed, only the first record displays, preceded by the following error: "Warning: mysql_fetch_assoc(): 7 is not a valid MySQL result resource in /home/agciorg/public_html/events/2009/259/roster.php on line 151" line 151 is the closing tag of the PHP do statement: <?php } while ($row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants)); ?> query is: mysql_select_db($database_AGCI, $AGCI); $query_rsWorkshopRegistrants = "SELECT * FROM users WHERE users.UserEventID = 259 ORDER BY UserLastName ASC"; // $rsWorkshopRegistrants = mysql_query($query_rsWorkshopRegistrants, $AGCI) or die(mysql_error()); $row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants); $totalRows_rsWorkshopRegistrants = mysql_num_rows($rsWorkshopRegistrants); Also of note is that for the single record that does display, the link to it's detail page does not work - the field containing the record ID that gets passed in the url is not coming through. simplified version of the repeat region code: <?php do { ?> <tr> <td> <a href="http://www.agci.org/programs/past_workshop_participants/about_the_scientist/participant_details.php?recordID=<?php echo $row_rsWorkshopRegistrants['UserContactID']; ?>"><?php echo $row_rsWorkshopRegistrants['UserFirstName'] ?> <?php echo $row_rsWorkshopRegistrants['UserLastName'] ?></a> </td></tr> <?php } while ($row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants)); ?> Anyone have insight into what could be causing this? I'm at a complete loss.

The variable $rsWorkshopRegistrants is defined in the header, which is an include file. mysql_select_db($database_AGCI, $AGCI); $query_rsWorkshopRegistrants = "SELECT * FROM users WHERE users.UserEventID = 259"; // **** NEED TO CHANGE EVENTID FOR EACH WORKSHOP **** $rsWorkshopRegistrants = mysql_query($query_rsWorkshopRegistrants, $AGCI) or die(mysql_error()); $row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants); $totalRows_rsWorkshopRegistrants = mysql_num_rows($rsWorkshopRegistrants);

No.

Produces the same error if I add "or die(mysql_error());" to the line.

Query is: mysql_select_db($database_AGCI, $AGCI); $query_rsWorkshopRegistrants = "SELECT * FROM Registration_new WHERE Registration_new.EventID = 259"; $rsWorkshopRegistrants = mysql_query($query_rsWorkshopRegistrants, $AGCI) or die(mysql_error()); $row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants); $totalRows_rsWorkshopRegistrants = mysql_num_rows($rsWorkshopRegistrants); It must be connecting to the dB ok because it displays the first record correctly, but nothing after that other than the two warning lines.

Hi there - I am using the below code to display a set of results in two columns. I have used the exact code on another page and it works fine, but on this particular page it produces 2 warnings: Warning: mysql_fetch_assoc(): 5 is not a valid MySQL result resource in /home/agciorg/public_html/events/2009/259/roster.php on line 78 Warning: mysql_fetch_assoc(): 5 is not a valid MySQL result resource in /home/agciorg/public_html/events/2009/259/roster.php on line 106 I've identified the problematic line #s below. Any help as to what could be causing the errors would be much appreciated! Thanks. <?php $number_columns = 2; // manually set the number of columns $break_point = ceil($totalRows_rsWorkshopRegistrants / $number_columns); // divide total rows by 2 to find break points $counter = 0; // start a counter ?> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td></td> <td valign="top"> <?php do { $counter++; // count the output ?> <?php echo $row_rsWorkshopRegistrants['FirstName'] ?> <?php echo $row_rsWorkshopRegistrants['LastName'] ?><br /> <?php if (($counter % $break_point) == 0) { // if current row is equal to break_point echo "</td><td valign='top'>"; // close cell and start a new column } ?> <!-------LINE 106 ----------> <?php } while (($row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants))) ?> </td> </tr> </table> <table border="0"> <?php do { ?> <tr> <td> </td> <td > <?php echo $row_rsWorkshopRegistrants['FirstName'] ?> <?php echo $row_rsWorkshopRegistrants['LastName'] ?> <br /> </td> </tr> <tr> </tr> <!-------LINE 106 ----------> <?php } while ($row_rsWorkshopRegistrants = mysql_fetch_assoc($rsWorkshopRegistrants)); ?> </table>

It works! Thanks!!

Quick question for a PHP guru: Is there a function for adding the "th", "rd", "nd", or "st" to a number? Eg. 21st, 33rd, 42nd...etc.

Great - thanks so much. One other related question: Is there a function for adding the "th", "rd", "nd", or "st" to a number? Eg. 21st, 33rd, 42nd...etc.

Hello to anyone out there - PHP newbie here. I am trying to increment a number as the current year changes. For example, say in 2009 $age=20. I want $age to automatically increase by 1 with each year...so, in 2010 $age = 21, for 2011 $age = 22, etc. This seems like it should be really simple, but I've come to an impasse on getting this to work. Could someone enlighten me as to the proper code to accomplish this? Thanks in advance!!

Hello! I am somewhat new to php and am hoping someone can help me out with a problem. I have a php page with a php include file that contains javascript. The javascript is for a stylized sort menu that sorts the current results on the parent page. Therefore, I need to get the full url (including url variables) of the parent file from within a js script in the include file. So far this is what I have, but it doesn't work ($pageURL is empty when looking at the page source): parent file: <?php // get the full page url $pageURL = 'http'; if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";} $pageURL .= "://"; if ($_SERVER["SERVER_PORT"] != "80") { $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"]; } else { $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; } ?> . . . <?php include("include.php"); ?> include file: <script type="text/javascript"> //Contents for a sort menu that sorts the current results on the parent page menu1[0]='<a href="<?php echo($pageURL);?>&sort=yearDESC">Year: descending</a>' menu1[1]='<a href="<?php echo($pageURL);?>&sort=yearASC">Year: ascending</a>' menu1[2]='<a href="<?php echo($pageURL);?>&sort=title">Title: A-Z</a>' Maybe there is a better way to do this? Any help would be mush appreciated.

Caught the error. Thanks for your help!

Hello there! Hoping for some help. I have a repeat region set up that displays 8 records per page, ordered by 'DatePublished" DESC. Until recently all was working fine. Now suddenly the first (most recent) record repeats at the top of each page in the page set. For the life of me I can't figure out why this is happening. ??? My relevant code is below. You can view the page in action at http://www.agci.org/programs/public_lecture_series/publicLecture_results.php. Any help would be greatly appreciated – please let me know if I need to provide more details. Thanks in advance. Recordset: <?php mysql_select_db($database_AGCI, $AGCI); $query_rsPubLecSearch = "SELECT Events.Name, Library.AgendaPresenterAgendaItemID_AgPrst_PresenterNameFirst, Library.AgendaPresenterAgendaItemID_AgPrst_PresenterNameLast, Library.AgendaPresenterAgendaItemID_AgPrst_ContactID_fk, Events.Description, Library.DatePublished, Events.Evt_thumbRedirect, Events.Notes, Library.Keywords, Events.EventCode, Events.EventTopic, Events.EventTopic2, Events.EventTopic3, Events.EventTopic4, Events.EventTopic5, Events.EventTopic6, Events.EventTopic7, Library.DocPDF1WEB, Library.InternetCode, Library.Video_Auth FROM Events, Library WHERE Events.EventType LIKE 'Walter Orr Roberts' AND Library.EventCode = Events.EventCode ORDER BY Library.DatePublished DESC"; setQueryBuilderSource($query_rsPubLecSearch,$PublicLecture_Search,false); $rsPubLecSearch = mysql_query($query_rsPubLecSearch, $AGCI) or die(mysql_error()); $row_rsPubLecSearch = mysql_fetch_assoc($rsPubLecSearch); $totalRows_rsPubLecSearch = mysql_num_rows($rsPubLecSearch); $maxRows_rsPubLecSearch = 8; $pageNum_rsPubLecSearch = 0; if (isset($_GET['pageNum_rsPubLecSearch'])) { $pageNum_rsPubLecSearch = $_GET['pageNum_rsPubLecSearch']; } $startRow_rsPubLecSearch = $pageNum_rsPubLecSearch * $maxRows_rsPubLecSearch; mysql_select_db($database_AGCI, $AGCI); $query_limit_rsPubLecSearch = sprintf("%s LIMIT %d, %d", $query_rsPubLecSearch, $startRow_rsPubLecSearch, $maxRows_rsPubLecSearch); $rsPubLecSearch = mysql_query($query_limit_rsPubLecSearch, $AGCI) or die(mysql_error()); $row_rsPubLecSearch_rsPubLecSearch = mysql_fetch_assoc($rsPubLecSearch); if (isset($_GET['totalRows_rsPubLecSearch'])) { $totalRows_rsPubLecSearch = $_GET['totalRows_rsPubLecSearch']; } else { $all_rsPubLecSearch = mysql_query($query_rsPubLecSearch); $totalRows_rsPubLecSearch = mysql_num_rows($all_rsPubLecSearch); } $totalPages_rsPubLecSearch = ceil($totalRows_rsPubLecSearch/$maxRows_rsPubLecSearch)-1; $queryString_rsPubLecSearch = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsPubLecSearch") == false && stristr($param, "totalRows_rsPubLecSearch") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsPubLecSearch = "&" . htmlentities(implode("&", $newParams)); } } $queryString_rsPubLecSearch = sprintf("&totalRows_rsPubLecSearch=%d%s", $totalRows_rsPubLecSearch, $queryString_rsPubLecSearch); ?> Page Body: <?php do { ?> <table class="repeatRegion" width="513" border="0"> <tr> <td colspan="4" > </td> </tr> <tr> <td colspan="2"><h3><a href="http://www.agci.org/programs/public_lecture_series/about_the_lecture/publicLecture_details.php?recordID=<?php echo $row_rsPubLecSearch['EventCode']; ?>"/><?php echo $row_rsPubLecSearch['Name']; ?></a></h3></td> <td width="22" rowspan="5"> </td> <td width="108" rowspan="5" align="right" valign="top"><a href="http://www.agci.org/programs/public_lecture_series/about_the_lecture/publicLecture_details.php?recordID=<?php echo $row_rsPubLecSearch['EventCode']; ?>"><img src="http://www.agci.org/dB/Thumbnails/<?php echo $row_rsPubLecSearch['Evt_thumbRedirect']; ?>" alt="event image" width="100" border="2" align="right" id="eventImage" /></a> </td> </tr> <tr> <td colspan="2"><span class="green_dim">Speaker: Dr. <?php echo $row_rsPubLecSearch['AgendaPresenterAgendaItemID_AgPrst_PresenterNameFirst']; ?> <?php echo $row_rsPubLecSearch['AgendaPresenterAgendaItemID_AgPrst_PresenterNameLast']; ?></span> <br /> <?php $dateChunks = explode("-", $row_rsPubLecSearch['DatePublished']); // explode date ?> <?php $Y= "$dateChunks[0]";?> <?php $M= "$dateChunks[1]";?> <?php $D= "$dateChunks[2]";?> <?php $d_var1=getdate(mktime(0,0,0,$M,$D,$Y)); // reformat date ?> <span class="fineprint">Presented on <?php echo $d_var1[mday]?> <?php echo $d_var1[month]?> <?php echo $d_var1[year] // print new date output?></span> </td> </tr> <tr> <td colspan="2"> </td> </tr> <tr> <td colspan="2"><?php echo $row_rsPubLecSearch['Description']; ?> <a href="http://www.agci.org/programs/public_lecture_series/about_the_lecture/publicLecture_details.php?recordID=<?php echo $row_rsPubLecSearch['EventCode']; ?>"/>View</a> <a href="http://www.agci.org/programs/public_lecture_series/about_the_lecture/publicLecture_details.php?recordID=<?php echo $row_rsPubLecSearch['EventCode']; ?>"/><img src="http://www.agci.org/images/bullet_doublearrow.gif" alt="double arrow" border="0" /></a></td> </tr> <tr> <td colspan="2"> </td> </tr> </table> <?php } while ($row_rsPubLecSearch = mysql_fetch_assoc($rsPubLecSearch)); ?> </div> <p> </p> <table width="513" height="20" border="0"> <tr bgcolor="#666666"><td height="5" colspan = "2" > </td> </tr> <tr> <td> <?php if ($pageNum_rsPubLecSearch > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_rsPubLecSearch=%d%s", $currentPage, 0, $queryString_rsPubLecSearch); ?>"><< First</a> <?php } // Show if not first page ?> <?php if ($pageNum_rsPubLecSearch > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_rsPubLecSearch=%d%s", $currentPage, max(0, $pageNum_rsPubLecSearch - 1), $queryString_rsPubLecSearch); ?>">< Previous</a> <?php } // Show if not first page ?></td> <td><div align="right"> <?php if ($pageNum_rsPubLecSearch < $totalPages_rsPubLecSearch) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_rsPubLecSearch=%d%s", $currentPage, min($totalPages_rsPubLecSearch, $pageNum_rsPubLecSearch + 1), $queryString_rsPubLecSearch); ?>">Next ></a> <?php } // Show if not last page ?> <?php if ($pageNum_rsPubLecSearch < $totalPages_rsPubLecSearch) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_rsPubLecSearch=%d%s", $currentPage, $totalPages_rsPubLecSearch, $queryString_rsPubLecSearch); ?>">Last >></a> <?php } // Show if not last page ?> </div> <?php } // Show if recordset not empty ?>

I am somewhat new to php and am in need of some assistance. I have a mysql table ("Library") with a field called "Tags" that contains a list of comma-separated words that function as tags/categories for a series of publications. There is a finite number of total tag words, many of which are repeated across records. I need to select only distinct tags words in order to display a list of available tags/categories. So using SELECT DISTINCT Tags FROM Library WHERE Tags IS NOT NULL does not work as this selects distinct field values, not distinct strings within a field. Can anyone help me out with what the query would look like to select distinct comma-separated words within a field? I'm desperate!

Anyone??????

Here's my code: <?php $colname_master1Agenda = "-1"; if (isset($_GET['recordID'])) { $colname_master1Agenda = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']); } mysql_select_db($database_AGCI, $AGCI); $query_master1Agenda = sprintf("SELECT * Agenda WHERE EventID_fk = %s ORDER BY Date", GetSQLValueString($colname_master1Agenda, "int")); $master1Agenda = mysql_query($query_master1Agenda, $AGCI) or die(mysql_error()); $row_master1Agenda = mysql_fetch_assoc($master1Agenda); $totalRows_master1Agenda = mysql_num_rows($master1Agenda); mysql_select_db($database_AGCI, $AGCI); $query_detail2Agenda = "SELECT * FROM Agenda WHERE Talk_ID=123456789 ORDER BY Time ASC"; $detail2Agenda = mysql_query($query_detail2Agenda, $AGCI) or die(mysql_error()); $row_detail2Agenda = mysql_fetch_assoc($detail2Agenda); $totalRows_detail2Agenda = mysql_num_rows($detail2Agenda); ?> <div id="agenda"> <table border="0"> <tr class="faint_gray"> <td height="34" scope="col"><b>DAY/TIME</b></td> <td scope="col"><b>TITLE</b></td> <td scope="col"></td> <td scope="col"><b>PRESENTER</b></td> </tr> <?php do { ?> <tr> <td colspan="4"> <?php echo $row_master1Agenda['Date']; // print date </td> </tr> <?php if ($totalRows_master1Agenda>0) { $nested_query_detail2Agenda = str_replace("123456789", $row_master1Agenda['Talk_ID'], $query_detail2Agenda); mysql_select_db($database_AGCI); $detail2Agenda = mysql_query($nested_query_detail2Agenda, $AGCI) or die(mysql_error()); $row_detail2Agenda = mysql_fetch_assoc($detail2Agenda); $totalRows_detail2Agenda = mysql_num_rows($detail2Agenda); $nested_sw = false; if (isset($row_detail2Agenda) && is_array($row_detail2Agenda)) { do { //Nested repeat ?> <tr> <td width="75" valign="top"> <?php echo $row_detail2Agenda['Time']); // print time ?> </td> <td width="350" valign="top"> <?php echo $row_detail2Agenda['TalkTitle']; // print talk title ?> </td> <td width="20" valign="top"></td> <td valign="top"> <?php echo $row_detail2Agenda['PresenterNameFirst']; ?> <?php echo $row_detail2Agenda['PresenterNameLast']; // print presenter name?> </td> </tr> <?php } while ($row_detail2Agenda = mysql_fetch_assoc($detail2Agenda)); //Nested move next } } ?> <?php } while ($row_master1Agenda = mysql_fetch_assoc($master1Agenda)); ?> </table> </div> <?php mysql_free_result($master1Agenda); mysql_free_result($detail2Agenda); ?>

I am a PHP noob and have been unable to find a solution for the following: I am working with a mySQL table called "Agenda" with the following columns: Date, Time, TalkTitle, Talk_ID. I need to display this on a page so that it reads as a normal agenda, like this: Day 1 8:00a talk 1.1 title 10:00a talk 1.2 title 12:00p talk 1.3 title Day 2 8:30a talk 2.1 title 11:00a talk 2.2 title 1:00p talk 2.3 title Day 3 8:00a talk 3.1 title 9:00a talk 3.2 title 12:30p talk 3.3 title (this is a simplified example just to illustrate what I am trying to achieve) Unfortunately my current code produces this (using a nested loop): Day 1 8:00a talk 1.1 title Day 1 10:00a talk 1.2 title Day 1 12:00p talk 1.3 title Day 2 8:30a talk 2.1 title Day 2 11:00a talk 2.2 title ...etc... Can anyone walk me through the basics of displaying data in the manner intended? Thank you!

PHP noob here... I am trying to convert mySQL data into XML format using PHP. Unfortunately I have had no luck getting this to work and would greatly appreciate some help. My code is below. The 'name' node displays fine, but the 'desc' section does not display at all (note that within {desc} neither a database record nor a PHP include file will show up). Code for XML file (workshop_details.php): <?php require_once('http://www.agci.org/Connections/AGCI.php'); ?> <?php $colname_rsSciSessPast = "-1"; if (isset($_GET['recordID'])) { $colname_rsSciSessPast = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']); } mysql_select_db($database_AGCI, $AGCI); $query_rsSciSessPast = sprintf("SELECT * FROM Events WHERE EventID_pk = %s AND EventType = 'Science Session' AND Events.EventDateEnd < CURRENT_DATE ", GetSQLValueString($colname_rsSciSessPast, "text")); $rsSciSessPast = mysql_query($query_rsSciSessPast, $AGCI) or die(mysql_error()); $row_rsSciSessPast = mysql_fetch_assoc($rsSciSessPast); $totalRows_rsSciSessPast = mysql_num_rows($rsSciSessPast); ?> <?php // Send the headers header('Content-type: text/xml'); header('Pragma: public'); header('Cache-control: private'); header('Expires: -1'); ?><?php echo('<?xml version="1.0" encoding="utf-8"?>'); ?> <WorkshopDetail> <?php if ($totalRows_SciSessPast > 0) { // Show if recordset not empty ?> <?php do { ?> <WorkshopDetails> <WorkshopDetail> <name><b>About the Workshop</b></name> <desc><![CDATA[ <?php echo $row_rsSciSessPast['SessionDescriptionWeb']; ?>]]> </desc> </WorkshopDetail> <WorkshopDetail> <name><b>Roster</b></name> <desc><![CDATA[<?php include("includes/roster.php");?>]]></desc> </WorkshopDetail> <?php } while ($row_rsSciSessPast = mysql_fetch_assoc($rsSciSessPast)); ?> <?php } // Show if recordset not empty ?> </WorkshopDetails> <?php mysql_free_result($rsSciSessPast);?> Code from parent page (sciSess_details.php): <script src="http://www.agci.org/SpryAssets/SpryEffects.js" type="text/javascript"></script> <script src="http://www.agci.org/SpryAssets/xpath.js" type="text/javascript"></script> <script src="http://www.agci.org/SpryAssets/SpryData.js" type="text/javascript"></script> var dsWorkshopDetails = new Spry.Data.XMLDataSet("workshop_details.php", "WorkshopDetails/WorkshopDetail", {entityEncodeStrings:false}); ... <ul spry:region="dsWorkshopDetails" spry:repeatchildren="dsWorkshopDetails"> <li class="product" onclick="fadeOutContentThenSetRow('{ds_RowID}');" spry:select="selected" spry:hover="hover">{name}</li> </ul> <div id="infoArea" spry:detailregion="dsWorkshopDetails" width="517px" height="100%">{desc} </div>

Also, running a recordset test in Dreamweaver works fine with no errors.

Changing the operator didn't work. Now the error just says: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY NameLast ASC' at line 1". The only line of code containing this text on the page is the one I previously provided.

PHP newbie here. I am getting a SQL syntax error on the following code: $query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 ORDER BY NameLast ASC"; The exact error message is: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY NameLast ASC LIMIT 0, 30' at line 1" For the life of me I can't figure out what is wrong as it was working previously. Any thoughts?

Worked great. Thank you so much for all your help!

OK, now I need a bit of handholding on the code for the results page. So far I have: $query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 ORDER BY NameLast ASC"; $firstletter = $_GET['firstletter'] ; if (isset($firstletter) && $firstletter = UVW) { $query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 AND NameLast LIKE 'U%' OR NameLast LIKE 'V%' OR NameLast LIKE 'W%' ORDER BY NameLast ASC"; } elseif (isset($firstletter) && $firstletter = XYZ) { $query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 AND NameLast LIKE 'X%' OR NameLast LIKE 'Y%' OR NameLast LIKE 'Z%' ORDER BY NameLast ASC"; } else { $query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 AND NameLast LIKE '$firstletter%' ORDER BY NameLast ASC"; } ...but this doesn't work – it returns results for UVW regardless of what $firstletter is set to. Any help? Is there a better way of accomplishing this? Thanks.