cjbeck71081

Sounds great, any quick examples, or tutorials that might get me started? I appreciate the response.

Hey, i'm fairly expereinced with PHP and Javascript, i was wondering if anyone had a good example of taking results from a MySQL table and making them availible in tabular form. Then having checkboxes at the top of the page that would allow users to limit thier results by clicking one or more checkboxes. I am sure i can create onChange page reloads modifying the query for each result, but i wanted this to be a bit faster, any thoughts?

Thanks again for your advice, i'm already reading up on Zend. Thanks

Thanks i appreciate the info. Of those selections which do you prefer? How do you typically handle the credit card payments, is there any liability in processing payments? I have typically stuck with PayPal in the past because they handle the entire transaction, therefore reducing the liability to my client.

I am sure i am the thousandth person on here to post asking questions about subscription based websites... but I'm not looking for too much info just a direction to get started in. I have been programing PHP for years and I have been using(for light security programs) a mysql table to store usernames and passwords and then using a <form> to submit the textfields, pulldown rows that match username & password, and if($row >=1) then let the person into the site. It has worked well in the past but now i want to go to paid subscriptions... and i don't know if that is the best method for storing, accessing and displaying pages that should be password protected for paid registered users. I.E. i want to bump up the security of it, if that is necessary. So i guess what i am looking for is a place i might be able to read up on best practices for "subscription based sites" and is PHP even the right language for that? Is there a better programing language for subscription sites. Anyway, any info would be great, this is a fairly generic question so all input is appreciated.

Ok, so i am having a bear of a time trying calculate dates. Any help would be apprecaited. So I am timestamping dates in SQL entries using the "INSERT INTO table (`mydate`) VALUES (CURDATE())" This is populating the database with a date similar to this: 2008-09-17 This allows me to do a query of the database by saying "SELECT * FROM table WHERE mydate < CURDATE() - INTERVAL 30 DAY"; This part works great.. then I can send notifications to people who are past 30 days, and all are happy. But now I am trying to display date information in a table for the customer to see. For example... if Bob signed up for an account he'll have a field for su_date(signup date) and it would get '2008-09-17'. If I then wanted to make a table for a client that said... Bob signed up on 09-17-2008 and then calculate his renewel date of 30 days later... by saying Bob needs to renew by 10-17-2008. How would i do that? I have tried taking the value of mydate from the table and adding 30 to it... that just adds 30 years to the date. I'm sure i can reorder the numbers and add form there, but what a mess. Any ideas or methods would be awesome. Thanks Guys CJ

I have a property listing service and I want people to put in the number of square feet for a proerpty, and i want to take thier value and take all the letters out of it, incase they put in 6050 SQFT, or 5405 sf or 34534 s.f., etc. Any ideas?

I am all for that, what is the proper syntaxt for that?

I have a membership sign up where a user signs up for an account online and a timestamp for thier sign up is puting the SQL table along with thier info. I would like to email the person when thier membership is older than 30 days and tell them that they have to check into thier account and update thier information. I know i can do this by brigning down the entries and calculating difference between dates... but i would like to run a query that does it for me. I have been looking into DATEDIFF and i think what i need is the syntax to properly pull down the email addresses of everyone whose membership is older than 30 days It might look like $result = "SELECT * FROM mytable WHERE DATEDIFF(`signup_date`, '$todays_date') > 30"; From there i could foreach($row = mysql_fetch_array($result)){ mail($row['email'],"Update your account", "Please update your account", $headers); } Any ideas... i'm sure my syntaxt is not even close on the SQL, but the idea is there.

No i dont, but I also wanted to give the client the ability to create new pages.... these would obviously need to be PHP files which pull data from the DB, but how to create them??

I am implementing a content management system that is customized. I would like the ability to add new pages to the CMS and I was wondering what the best practice was for creating new PHP documents and editing them. Secondly i was wondering how search engine friendly a completely CMS based site is with all of the <?include ?> codes in the actual code... do the search engines read that well?

i used: "INSERT into date (date) VALUES (CURDATE());" to insert the current date into my DB Then i used "SELECT * FROM date"; I made a variable $date from $row['date']; When I populated echo(date("F j, Y", $date)); It gave me December 31, 1969. Any ideas?

Thanks for your reply, im looking now, i found a nice way to insert into SQL the current date. But now, coming out of SQL the format is 2008-08-09. Again, I know i can hack it, but im looking for the most straight forward way to either rearrange the numbers to read 08-09-2008 or convert them altogether and say August 09, 2008. I'll look at strtoday and mktime.

So in other words. If you have a form: <form id="form1" name="form1" method="post" action="post.php"> <label> <input type="text" name="textfield1" id="textfield1" /> </label> <p> <label> <input type="text" name="textfield2" id="textfield2" /> </label> </p> <p> </p> </form> When you get over to post.php you are just inputting the data using the $_POST['textfield1'] rather than assigning it a variable? i.e. <? echo("This is my first text field" . $_POST['textfield1']); echo("<br>"); echo("this is my second text field" . $_POST['textfield2']); ?> Thanks

I was wondering what you guys do to prepare dates for SQL, and then when they come out of SQL how to prepare them for analysis. I have always been pulling dates together using a string, and then poping them into SQL, and when they come out of SQL i have been decoding them... i'm sure there is a better way. In other words... someone signs up for something, i want to time stamp thier sign up. I would populate the now(); date into the sql, but i want to make sure its in "DATE" format to fit my SQL syntaxt. And if i wanted to send them an email with the date they signed up, I would format it to read "January 15th 1980". Without hacking it up. Thanks in advance Chris