Re: [PHP-DB] vBulletin board
why dont u just use phpbb? it is opensource & free http://phpbb.com/ Neil - Original Message - From: "Leif K-Brooks" <[EMAIL PROTECTED]> To: "John StoneCold" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 16, 2002 8:30 AM Subject: Re: [PHP-DB] vBulletin board > That's illegal. > > John StoneCold wrote: > > >Hi, > > > >Dose any one who has a copy of vBulletin board for sale? > > > >Thanks > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: PHP IDE
i use PHP CODER PR2 the newer version of it i think suks. so if u want it ask. I like it tons. Neil - Original Message - From: ACEAlex <[EMAIL PROTECTED]> To: php-db <[EMAIL PROTECTED]> Sent: Sunday, February 24, 2002 8:38 AM Subject: Re: [PHP-DB] Re: PHP IDE > I use homesite just to tag the functions in different colors > > - Original Message - > From: "robert janeczek" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, February 23, 2002 8:59 PM > Subject: [PHP-DB] Re: PHP IDE > > > > > After spending two frustrating hours tracking down a bug yesterday - > only > > to > > > discover it was a misplaced quote mark. I've had it. > > > > > > I am looking for suggestions out there for a good IDE for PHP > development, > > > preferably one that doesn't cost an arm and a leg. I tried PHP4EE > studio, > > > but it is buggy as hell and kept crashing on me. > > > > try zend studio - www.zend.com > > > > rash > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Protecting php scripts from source being downloaded
u can download a php page from a download manager ? i just tryed with flashget... & it phrased the php page into html first.. ? ? if you want to protect your say.. variables file from some1 trying in the address of it. heres a simple way. in the variables file include @header(status: error 404); (or how ever that code goes). then in the page u want to include this. start the html tag first then include this page. the @ will make it not report errors. so u can inclue the page perfectally.. & when people try to look @ it, it will say it doesnt exist. Neil - Original Message - From: Tom <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 8:00 AM Subject: [PHP-DB] Protecting php scripts from source being downloaded > Hi, im kinda new to this so be kind :) > > Im using mysql and php to create test databases (guestbook etc, basic > stuff), but it doesnt seem so secure, people can just use a download manager > to download the php files and steal the mysql passwords. Is there anyway to > make it so they can see the php files through the brower but not download my > homecrafted php? > > Ive looked through many websites and the history of this, all I could find > was one post which was to encript the files (this isnt really suitable for > me as I edit bits and bobs as I go along). Is there anyway I can setup > access as said in the above? Or just hid the password somehow? Im using IIS > 5.1. > > thanks > tom > > > > -- > 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] mysql_num_rows
dont u need to add the $sql to the mysql_query... as in mysql_query($sql,$db); ?? i thourhgt u did ? anyways.. might be wrong. Neil - Original Message - From: Ford, Mike [LSS] <[EMAIL PROTECTED]> To: 'Gurhan Ozen' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 08, 2002 6:07 AM Subject: RE: [PHP-DB] mysql_num_rows > > -Original Message- > > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > > Sent: 06 January 2002 20:10 > > > > I am pretty sure that the query is correct. here is the actual query: > > $query="select distinct(nodeid), nodename > > from books where > > bookid=$bookid"; > > $result=mysql_query($query); > > $num_results=mysql_num_rows($result); > > > > > The funny thing is that if i write the same query without "where > > bookid=$bookid" then the mysql_num_rows works but with where > > statement it > > doesn't. > > Have you echoed $result to see what it contains? My guess is that it contains something unexpected which, when inserted into the query, causes it to fail (or at least return no rows!). Otherwise, I can see no reason for the addition of the WHERE clause to cause this error. > > Cheers! > > Mike > > - > Mike Ford, Electronic Information Services Adviser, > Learning Support Services, Learning & Information Services, > JG125, James Graham Building, Leeds Metropolitan University, > Beckett Park, LEEDS, LS6 3QS, United Kingdom > Email: [EMAIL PROTECTED] > Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 > > -- > 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] database/form help needed
try using the rand function.. eg... $rand=rand(1,10); but that migth get a same number more then once... my suggestion is this $checkboxid="1"; // Start of the loop echo ""; // end of loop $checkboxid = $checkboxid + 1; that should work i think havent tested that code. but thats my idea. Neil - Original Message - From: Chris Payne <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 10:59 PM Subject: [PHP-DB] database/form help needed Hi there everyone, I have a loop which goes through my MySQL database and some PHP code which grabs results 9 at a time, and that works great. Now, I also have a checkbox called ID for each of the 9 entries and here is my problem. How can I dynamically assign a unique ID for my checkboxes? I am getting my checkboxes through a loop, and because of that the ID is called id - for all of my entries, so I can't select multiple as only one entry comes out on the results page. How can I dynamically create checkboxes with a unique id (Such as id1, id2 etc ...) so that I can make multiple selections from my DB? Thank you all so much - Happy New Year. Regards Chris Payne www.planetoxygene.com -- 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] Building a user preference site
use either sessions or cookies. ur choice. look @ the manual on both. Neil - Original Message - From: Danny Kelly <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 6:42 PM Subject: [PHP-DB] Building a user preference site > Hello, > I am trying to figure out how to setup a user preference system. When the > user successfully > logs in they will go to a page that will display their preferences. I have a > Mysql database that contains all the user info. How do I START developing a > site like this. Thanks, Dan > > > -- > 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] hiding blank MySQL results?
ok i get your point. how about "; } if ($discription !=""){ $discription1=$discription""; } if ($link !=""){ $link1=$link""; } echo "$title1 $discription1 $link1"; ?> the != means if does not equal. so basically that should i think do. if the title does not equal nothing then add a to the end of it. (putting the return in html). So if it does equal nothing. then it will be nothing. does this make sense ? i wasnt sure on how to add to the end... i had a shot @ it. this code may not work just an idea. Neil - Original Message - From: Nathon Jones <[EMAIL PROTECTED]> To: 'Shooter' <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 4:01 AM Subject: RE: [PHP-DB] hiding blank MySQL results? > Thanks Neil. > > Does this produce a message saying "Sorry no Result" if the field is > empty? > > What I am after is for it to just remain blank without inserting a blank > line where the field should be and without inserting an error message. > > Lets say my results are as follows: > > Blues Magazine <-- Title > Best Blues Magazine in the world. <-- Description > www.bluesmagazine.com <-- Link > > If one of my database records doesn't have a Description, how do I stop > the PHP page inserting a blank line where the description SHOULD have > been? Do you get my drift? Like, for certain records it might display: > > Blues Magazine > > www.bluesmagazines.com > > ...where there is no description for this record. Can't get my head > around it! > > Thanks for your help Neil. Much appreciated. > Regards > Nathon Jones > > -Original Message- > From: Shooter [mailto:[EMAIL PROTECTED]] > Sent: 05 January 2002 05:25 > To: Nathon Jones; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] hiding blank MySQL results? > > i would suggest in your while you do someting like this > > while($myrow=MySQL_fetch_array($result)) > { > $time=$myrow["time"]; > > if ($time =="") > {$time ="Sorry No Result"; > } > echo "$time"; > > if u get my drift ? ? > > Nei;l > > > - Original Message - > From: Nathon Jones <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 04, 2002 5:12 PM > Subject: [PHP-DB] hiding blank MySQL results? > > > > Hi. > > > > I have a PHP page calling a set of results from a MySQL database. > They > > appear in the following format on the results page: > > > > Title > > Description > > Link > > > > Problem I'm having. When a db record has an empty field (for example, > no > > description), the results page leaves a gap where the description > should > be. > > > > How do I do a "hide if empty" thang to stop the gaps appearing? > > > > Really appreciate the help. > > Regards > > nathon > > [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]