pwnuspoints

Hello phpfreaks! As always any help is appreciated! I am currently using an installation of Easy PHP Calendar <http://www.easyphpcalendar.com/> on my website to keep track of important dates and events. As one might imagine Easy PHP Calendar makes use of PHP/SQL functionality to store important dates in a database on my server. When I use the Easy PHP Calendar web interface to add an event it stores the information I input into a table called 'epc_calendar'. This table is actually pretty straight forward; it's column headers are as follows: id, startDate, endDate, startTime, endTime, eventType, repeatx, title, descr, days, stop, month, weekDay, weekNumber, category, eventKey. The only columns from 'epc_calendar' I need to be concerned with are startDate and category. The startDate column stores the start date of each event as a Julian Day Number [e.g. "12/10/2009" = " 2455176"]. The category column stores a VARCHAR numbered string which associates a highlight color to each event when displayed [e.g. "0[2X" = "Blue"]. Okay, so here's the challenge. I want to display a list of four or five of the most recent upcoming events using this database. To accomplish this I need to write an SQL query which is aware of the current date in Julian Day format and searches for any events from the current day on. I also need to further define the query by only showing items of a certain category. Did you get all that? Because my head is spinning. Summed up.. I need to select a range of dates stored in my database in Julian Day format. Thanks in advance for any help you offer!

Hello phpfreaks, I'm wondering if anyone knows a simple way to display next months full written name [e.g. January] using a simple date() function? Basically- when it's "December" I want the date to read "January"; when it's "January" I want "February" and so on. Anybody know where I should start looking?

I figured it out on my own. Using Heidi SQL I exported the data as a CVS document. Then I used Microsoft Excel 2007 to import the CVS document.. in excel it is rather a simple task to duplicate a column. Then, using find and replace I replaced "@domain.com" with an empty string. However to maintain the integrity of the e-mail column I could not use the "replace all" button. I had to click replace 800 times.. but hey, better than spending 8 hours re-typing that mess. Anyway~ thought I'd put that out there in case it helps anyone else. OH YEAH - I guess I exported the data back out as a cvs.. then imported it back into Heidi SQL on my server. Lickety-split. How do you like that?

Alllllright. Looks like have some code to give you. first, put on "Little Acorns" by the White Strips- even if you don't like them, it will help. Next, look at my code. This is how I process my login. The login form passes the variables to this code in a php document I've called login-exec.php There is a lot going on in that code. Essentially I've processed the log-in and set a Session variable. This means as long as the person is logged in you will be able to interact with that variable on the subsequent pages. I'm not gonna go into too much detail here. You'll have to do some googling to figure out any terms you don't understand. Now that we have set a session variable we need to include it and authorization on any page you wish to make reference to it. Make a file called auth.php and in it put the following code (modified to suit your needs). Then you need to use require_once on any pages you wish to be secure and make reference to the e-mail. Put the following code at the top of the page you want the error message to appear on. If you are not logged in this requre_once code will redirect you to access-denied.php or show you a blank page... so until you have the login working properly.. this may cause issues. Finally the code to generate the error message will look something like this: The string "No Email On File" is kinda clunky and might cause issues here. I'm not prepared to test it for you. the bolded area is where you will echo your error message. You should know, this code won't work unless you modify it to suit your needs. Stare at it long enough.. and you're bound to figure it out. That's the best I can do. Hope it Helps.

does this mean I have to modify those cells line by line? because if it does.. I'm friggin' quitting my job... No, probably not-- but I'll complain a lot.

This is simple to do- but difficult to explain.. and your implementation of the code depends entirely on your comfort level with php. Obviously the error message can only be displayed after logging in to determine if the user has or does not have an e-mail. So, you'll have to grab the users e-mail address when they log in and pass it as a $variable to the first page they see after logging in. Then you'll need to write an if/else statement on that page to determine one way or the other if they have an e-mail address. the concept is: If this users e-mail has an "@" symbol- or "@domain.com" then display nothing. Else, display the following alert message. Which you will have to code and customize using echo strings, html, and css. I have to run for an hour. I'll leave you with that for now-- and if the topic still isn't solved when I get back I'll write you some code to work from.

Hey phpfreaks, I have a special offer for you- just send 50 payments of $5.99 to --- lol.. just kidding. I appreciate any help you can give me on this topic. Let me explain the scenario. I maintain a table used as a staff directory for my website. It lists things like first name, last name, e-mail, phone numbers and so on. I am attempting to transition this table from being a static archive to the table I use to store username and password information for each employee. In this way I will end up with two separate tables without having to re-enter duplicate data manually or distort the original table. With me so far? My concern centers around the e-mail address column. For sake of simplicity I would like to use the first part of every e-mail address as usernames. I will also create a column containing a universal password (which can be changed after logging in). So I've got a column with e-mail addresses listed as strings "[email protected]". Using HeidiSQL I know I can duplicate the entire e-mail column. From there my next instinct would be to find and replace all "@domain.com" with an empty string "". That way I would have one column still listing their e-mail addresses and another listing their log-in username. I realize there are several ways to approach this.. I could probably make a php processing script to do the work.. or I could just leave the e-mail column as is and use a trim function on log-in to verify the username. However.. for the sake of my own sanity and work-flow. I'd like to end up with the two columns as detailed above. I'm using my best infomercial voice when I say: There's got to be a better way. *camera zoom* Any ideas? Thanks Ladies and Gents!

I just tried htmlentities and it worked! Well that was easier than I was expecting. Thanks mikesta707! Just in case, here's the code:

Hey phpfreaks, I have been in the process of making an RSS feed for a day now and I'm finally making some progress. As it turns out my troubles have something to do with removing the html tags from my description. I've been working with tutorial after tutorial which all claim to work. However, when I modify any tutorial code for myself the feed goes blank. I started from scratch too many times to mention. So finally I decided to give up on tutorials and try coding for myself. The code below is what I've come up with. If you ignore the fact that It has no description, everything works fine. Whever I add a description to the above code -- the feed goes blank. My "description" comes from the "body" column of my table. The body column stores rich text as html. I need to strip the html from '$body' before using it in the xml item description. However, every attempt I've made at stripping the html makes the whole thing stop working. Here's what my recent attempt looks like: I have two seperate questions: 1) What can am I doing wrong? 2) Is there anything wrong with the way I've decided to code this RSS feed? Would you safely use this code? If not, why? Any help is sincerely appriciated, thank you! -B.

Thanks. I'll study that code.

Thanks, Actually I think you've told me this before- when I was here with a different problem. Ugh, I give up. I just want a step by step by step shamelessly-hand-holding tutorial on how to create an dynamic RSS feed from an existing database table. Please, won't someone point me to an informative guide? Google has been unhelpful.

The code below is saved on my server in a directory named 'feed' with the filename 'index.php' Naturally, I've removed my actual database name and password from the code below... But even with the code below. The only thing that ever seems to show is the channel info- It's almost as if it's not connecting to my database. I've tried modifying this code and other code to match other database connections I've coded and tested... but still no luck.

No, it doesn't -- So, I'll change it to Varchar. Then I guess my question becomes. How do I pull a varchar date from the database and re-format it using date() ?

Hey there phpfreaks, As always yor help is appriciated, Thanks in advance! I'm working on creating a dynamic RSS feed using php/sql. The rss tutorial I've been referencing requires that I store dates in my database in RFC 2822 format or date("r"). However, when I try to upload a date in RFC 2822 format I get an error. My date column is set as 'date' type, so why isn't this working? More importantly, does anyone have a better tutorial for me on how to get a dynamic php RSS feed going? I've been working at this for eight hours. I'm familliar with xml and php - enough to know that this should be way easier. Every tutorial I've tried just doesn't work. Thanks again!

I'm already getting a better idea of how to handle dates, thanks everyone. As far as I gather, MYSQL understands dates written in 'YYYY-MM-DD' format. So, if i used the php date() function to write the date in that format it would look like this: date("Y-m-d"); Then I would be free to write that to my database normally and both PHP and MYSQL would 'understand' it?! right? right. I have a follow-up question-- When I create the 'date' column in my database table can it be set as VARCHAR? Or should it be set as something else?

Hey phpfreaks! I'm working on a simple php/sql blog. Up until now I have been using the php date() function to datestamp each entry in the database. I have been formatting the date as follows: date("F j, Y"); which is written to the 'VARCHAR' date column of my database as follows: "April 13, 2008" However, writing the date in this manner is clumbsy and forces me to display the date in the same format on every page. I guess my question is: Is there a smarter way to format the date and write it to my database? Your help and explaination is appriciated!

Fancy that, Thank you!

Hey PhpFreaks, I'm stumped. Why does the following code not work? <?php include 'library/config.php'; include 'library/opendb.php'; $result = mysql_query("SELECT * FROM table ORDER BY id DESC LIMIT 0, 1"); while($r=mysql_fetch_array($result)) { $filename=$r["filename"]; $reloc = "http://www.exampleurl.com/files/$filename"; header('Location: $reloc'); } include 'library/closedb.php'; ?> Simmilarly, the following code also does not work: <?php include 'library/config.php'; include 'library/opendb.php'; $result = mysql_query("SELECT * FROM table ORDER BY id DESC LIMIT 0, 1"); while($r=mysql_fetch_array($result)) { $filename=$r["filename"]; header('Location: http://www.exampleurl.com/files/$filename'); } include 'library/closedb.php'; ?> This code is meant to redirect users to the most recent file uploaded to my database. It seems straight forward. Am I missing something obvious?

My query now reads as follows: $result = mysql_query("SELECT * FROM table WHERE display LIKE '1' ORDER BY STR_TO_DATE(createdate, '%F %j, %Y') ASC "); >.> it appears to be ordering them by my primary key instead of by date. This is so frustrating. Is what I'm trying to accomplish even possible?

Hey phpfreaks! As always; your help is appriciated- Thanks in advance! I have several dates housed as text strings in a table. Each date is written in date("F j, Y") format [e.g. "January 28, 2009"]. When I display those dates on a php page, it has a tendancy to order them alphabetically-- which I find confusing. So, I'm trying to use the STR_TO_DATE sql function to display these strings in by date; it's not working. My query looks like this: $result = mysql_query("SELECT * FROM table WHERE display LIKE '1' ORDER BY STR_TO_DATE('createdate', 'F j, Y') DESC "); What am I doing wrong? Thanks Again.

This works fantastically; Thank-you so much phparray!

This is interesting, when I do as you said and place the code right after my else statement- the search becomes non-descriminatory. Meaning, I can type anything in the input box and it returns every row in my database. Nothing seems to get filtered. Any suggestions?

Hello again fellow Phpfreaks! First off, Any help you can provided is sincerely appriciated; thank you in advance for your time! My issue is as follows: I have built a simple 'search' form using Php to locate relevant items in a database on my remote server. Using an HTML form I collect a keyword input by the user, store it as a $variable and then use the $variable in my sql query to filer out rows with matching strings in my database. Naturally, I then echo those rows on the page. All of this is accomplished on a single page named 'search.php' The HTML form code looks like this: <?php $keyword = $_GET["keyword"]; ?> <form action="search.php" method="get" name="search"> <input name="keyword" type="text" value="<?php echo $keyword; ?>" size="15"> <input name="search" type="submit" value="Search"> <p id="small">Examples: "Agendas", "2009", "A", "pdf"</p> </form> /////////////////////////////////// As you can see I'm using the "get" method to pass the variable to the following php code: ////////////////////////////////// <?php if (empty($keyword)) { echo "<p>Please Enter Your Search</p>"; } else { include '../../library/config.php'; include '../../library/opendb.php'; $result = mysql_query("SELECT * FROM tbfind WHERE coli LIKE '%$keyword%' OR colii LIKE '%$keyword%' OR coliii LIKE '%$keyword%' OR coliv LIKE '%$keyword%' ORDER BY coli"); $num_rows = mysql_num_rows($result); echo "<br /><p id='red' align='center'>Your search returned $num_rows result(s).</p> "; echo "<table width='460' border='0' cellspacing='0' cellpadding='0' align='center'>"; echo "<tr>"; echo "<td width='20'> </td>"; echo "<td width='340'>Name</td>"; echo "<td width='100'>Date Created</td>"; while($r=mysql_fetch_array($result)) { $id=$r["id"]; $coli=$r["coli"]; $colii=$r["colii"]; $coliii=$r["coliii"]; $coliv=$r["filetitle"]; //display the row echo "<tr>"; echo "<td><span id='alert'><img src='icon.jpg' width='12' height='14' border='0'></span></td>"; echo "<td id='cell'><a href='$coli$colii'>$coliii</a></td>"; echo "<td id='cell'>$coliv</td>"; echo "</tr>"; } } include '../library/closedb.php'; ?> ///////////////////////////////////// The concept is fairly simple- However, I find the user is limited by it's simplicity. For example, if a user enters a query with spaces (i.e. "Apple Sauce" or "I want apple sauce") the search returns no results. Another issue is the pesky single quotation mark ' . If a user decided to input a string with a single quote, the search would again return zero results. Before we get too carried away with the many suggestions I'm sure you all have; I have kept this search simple for a reason. My grasp of php can be a little rough here and there If you have any ideas It would be especially helpful if you could explain where your ideas fit in with my code! Just to clarify: I'm looking for simple suggestions to optimize this simple database search! Any help is greatly appriciated! Thank-you in advance! NOTE: My database stores the filenames, file descriptions, date file created, direct paths, and relative paths of pdf and doc files I have uploaded to the server using a series of other forms which work perfectly. I do my best to follow a strict file naming convention for these files. Hopefully that gives you some insight into the metadata housed in my databases.

Thanks for your help! Sadly I am already using unlink() to delete files from the server, yet they remain in the folder. It's rather frustrating. I'd imagine the best work around would be to re-tool my 'delete code', to relocate trashed files to a nearby 'junk folder'. capturing the 'date created' from the metadata of files is still an unresolved issue. I'm not even sure if it's possible, does anyone have ideas, or should I give up on that? Thanks again!

Hello there phpfreaks! Any help with my topic would be greatly appriciated! Thanks in advance! My issue(s): I am using php/mysql to upload files to my server. As it is, my php relocates the selected file to the server and stores information regarding the files in a database for web display. However, I'm finding the stored information limited and would like to store more than just the file names, and file sizes in the database. Is there any way to capture the "Date Created" information from files as I upload them. Simply logging the date and time the file was uploaded is irrelevant to my project. I need to know when the file was created for increased control in the web interface. The second concern regards the deletion of files from my server. I have noticed that when I use my web interface to delete a file, it only deletes the file from my database records. Is there any way to move the file to the recyclebin on my server or to a junk folder instead of letting useless files build up on my server? I apologize if my request for help is written in a sloppy manner, I'm writing this during a lunchbreak. Mmmtacos! Thanks again!