[PHP-DB] sessions and page refresh?
Hi All I have a call to session_destroy(); This works But I also want to refresh the page as well. So onclick of button 1. session_destroy(); 2 refresh page. Any help or ideas are welcome as always Thank you in advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Sessions ???
Thanks Steve; I now have this in a session file in my tmp dir topicID|s:1:"8"; Now how do i get the link to read http://localhost/forums/view.php?topicID=8 i think its along the lines of http://localhost/forums/view.php3?PHPSESSIONID?topicID I am banging away, the 4 books i have on Php are useless when it comes to session and there usage. Thanks for the help Dave C "Steve Brett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > try > session_register("topidID"); > > without the $ > > Steve > > > > -Original Message- > > From: DC [mailto:[EMAIL PROTECTED]] > > Sent: 02 May 2001 13:54 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Sessions ??? > > > > > > Hi All > > I have a ? about setting a session. > > > > I have a functions.inc file and at the top have put my > > session statment that > > looks like this. > > > > > session_start(); > > session_register("$topidID"); > > ?> > > > > $topicID comes from my mysql db. > > > > What i am trying to do is set the $topicID of my message > > board so that when > > a sucessful post has been made the visitor can click on a > > link that show the > > right board by topicID. > > > > so the link will look like this... > > > > http://localhost/forums/view.php?topicID=3 > > > > I am banging away trying to make this work > > > > Any help in the meantime is as always appreciated > > > > Thank You In Advance > > > > dave C > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: > > [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Sessions ???
Hi All I have a ? about setting a session. I have a functions.inc file and at the top have put my session statment that looks like this. $topicID comes from my mysql db. What i am trying to do is set the $topicID of my message board so that when a sucessful post has been made the visitor can click on a link that show the right board by topicID. so the link will look like this... http://localhost/forums/view.php?topicID=3 I am banging away trying to make this work Any help in the meantime is as always appreciated Thank You In Advance dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Sending the user their forgotten password via emal??
Hi all I would like to offer my users the chance to have their username and password sent to them via the email address stored. As i see it i have two issues (1) how do i do the verify email thing where the script send a click here to confirm email address on registration application (2) how do i then send their details (username / password) to the confirmed stored email address. I have looked around but cqnt find the answer. 5 books on the shelf give no clue either Any help is most apreciated Thanks in Advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Checking database if already exsists
Hi again How do i check my database when someone trys to become a member to check a see if username password email address is already in use and show the the bit they need to change for my script to allow them to register. Thanks again in advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] How to stop blank entries
Hi All Firstly thanks to the people who have helped in the past with my questions... My issue: I have a registration script which allows new users of a site to become a member. All works very well BUT if a new user just hit enter on the blank form then a new account is created with all fields except the id field blank allowing anyone just to hit enter a gain access. I have search the MySql docs, Php.net docs, this and other NG's but i can't find the solution to this. And how can i carry forward the username to be shown on all pages after sucessful login. I thank you in advance Dave C To email me remove the NOSPAM bit of my return email address -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Cheers Brian Thats sounds more like i am looking for Although i have put the other code examples offered for this prob in my code folder for later cause you never now when you'll need them. Cheers Dave C ""Brian S. Dunworth"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > At 10:06 AM 3/30/01 -0800, Larry Rivera wrote: > >I think you have to run multiple queries, ie run some loop after finding out > >what topics you wil count from e==> > > > >run a select distinct to get the topics > >run a while or for loop then run queries again like count(*) where > >topic='$topic' > >Better yet (and less db-intensive), run a > > SELECT TOPIC,COUNT(*) FROM table_name >WHERE condition >GROUP BY TOPIC >ORDER BY COUNT(*); > > That'll return: > > TOPICCOUNT(*) > > Topic A 8 > Topic B 3 > Topic C 1 > Topic D 0 > Topic E 0 > > > - > Brian S. Dunworth > Sr. Software Development Engineer > Oracle Database Administrator > The Printing House, Ltd. > > (850) 875-1500 x225 > <[EMAIL PROTECTED]> > - > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Thanks i will give that ago. "Andrei Skorokhod" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > if you just need the number > > SELECT COUNT(*) FROM table where > > At 06:34 PM 3/30/2001 +0100, DC wrote: > >Hi All > >I cant quite work out how to count the number of rows in my mysql db that > >match a certain critieria and the show that number numericaly in my pages. > > > >Checked books, php.net etc. > > > >Any help is appreciated > > > >Yours Dave C > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Ok i will get the books out and see if i can construct something. Thanks for the tip... Dave C ""Larry Rivera"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I think you have to run multiple queries, ie run some loop after finding out > what topics you wil count from e==> > > run a select distinct to get the topics > run a while or for loop then run queries again like count(*) where > topic='$topic' > > etc > > > then echo the result to each line > > > -Original Message- > From: DC [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 30, 2001 9:53 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] count function? > > > Ok i think i need to expand my help request... my fault > > I have a db that uses ids for topics in a message board ie each topic has > messages of various numbers in them. > > >From my select a topic page i hope to put the number of messages in the > topic, so it visually looks like this sort of... > > topic 1 bb (5 posts) > topic 2 ff (2 posts > > and so on. > > The only constant i can see in the tables is my posts table which specifies > the topic id number. > > So i think i am asking how can i count the number of the same topic id > numbers and show that next to the relevant topic. > > Thanks Again > > Dave C > "Andrei Skorokhod" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > if you just need the number > > > > SELECT COUNT(*) FROM table where > > > > At 06:34 PM 3/30/2001 +0100, DC wrote: > > >Hi All > > >I cant quite work out how to count the number of rows in my mysql db that > > >match a certain critieria and the show that number numericaly in my > pages. > > > > > >Checked books, php.net etc. > > > > > >Any help is appreciated > > > > > >Yours Dave C > > > > > > > > > > > >-- > > >PHP Database Mailing List (http://www.php.net/) > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > >For additional commands, e-mail: [EMAIL PROTECTED] > > >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] count function?
Ok i think i need to expand my help request... my fault I have a db that uses ids for topics in a message board ie each topic has messages of various numbers in them. >From my select a topic page i hope to put the number of messages in the topic, so it visually looks like this sort of... topic 1 bb (5 posts) topic 2 ff (2 posts and so on. The only constant i can see in the tables is my posts table which specifies the topic id number. So i think i am asking how can i count the number of the same topic id numbers and show that next to the relevant topic. Thanks Again Dave C "Andrei Skorokhod" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > if you just need the number > > SELECT COUNT(*) FROM table where .... > > At 06:34 PM 3/30/2001 +0100, DC wrote: > >Hi All > >I cant quite work out how to count the number of rows in my mysql db that > >match a certain critieria and the show that number numericaly in my pages. > > > >Checked books, php.net etc. > > > >Any help is appreciated > > > >Yours Dave C > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] count function?
Hi All I cant quite work out how to count the number of rows in my mysql db that match a certain critieria and the show that number numericaly in my pages. Checked books, php.net etc. Any help is appreciated Yours Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP / MYSQL message board ?
Hi all I would like to find some documentation about how to create my own Php / Mysql driven message board. This is purly for my own educational interests. Any pointers and help appreciated Email: [EMAIL PROTECTED] kill the NOSPAM to send emial Thank you in advance Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]