Re: [PHP] encrypting passwords etc..
security is measured by the weakest link in the chain so I would say that the database needs to be well protected and the password encrypted. py At 12:14 PM 1/17/2002 -0800, you wrote: We had a client who wanted us to encrypt their passwords. Our argument was that maybe their database is not well protected. Only the dba and the application should have access to the database. No-one else should be able to view their data anyways. We didn't see any need to encrypt the passwords. Any thoughts... --- Hawk [EMAIL PROTECTED] wrote: Ok I got it working now, with the update and database connect etc.. thanks guys :) this is not a problem(yet), more a thought.. is it really necesary to encrypt passwords, I mean, what does it prevent, me from seeing them using mysql.exe ? :p I tried and it worked fine to almost all points.. worked with the user info update and so on.. but I seem to do something wrong and can't log back on since I encrypted the password... :p I used UPDATE users SET password=password('$password') but by some reason I can't seem to decrypt it on the login page.. any help would again be appreciated.. :) Hawk -- PHP General 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] = Anas Mughal [EMAIL PROTECTED] [EMAIL PROTECTED] Tel: 973-249-6665 __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP General 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 General 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] PHP software tool
It works does fine with PHP, but my favorite is EditPlus, py At 07:29 PM 12/22/2001 +, you wrote: Does 1st page work well with PHP? The website says its good for Perl, HTML and ASP but it doesnt mention PHP anywhere. :-s -Bd- [EMAIL PROTECTED] wrote in message 028901c18b1c$3c0e4d80$[EMAIL PROTECTED]">news:028901c18b1c$3c0e4d80$[EMAIL PROTECTED]... I use 1stpage from evrsoft.com .. not a real php editor, but does a pretty good job... Does anybody know of or can recommend any freeware text editing tools for editing PHP code in Win32? I can manage with Windows' Notepad but something with code highlighting etc and of a similar footprint to notepad would be useful. -- PHP General 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 General 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] Re: setting up a user login with PHP
or you could use: http://phpclasses.upperdesign.com/browse.html/package/288 py At 01:08 PM 12/10/01 -0500, Jeremy Reed wrote: The easiest way is to use cookies. =CODE ?php require 'auth_functions.php'; if (authenticateUser($form_username, $form_password)){ setcookie(cookie_passwd,$form_password); setcookie(cookie_user,$form_username); header(Location:http://$SERVER/index2.php;); exit(); } else { header(Location:http://$SERVER/error.html;); } ? This code takes in input from a form as simple as this: form name=form1 method=post action=index.php Login: input type=text name=form_usernamebr Password: input type=password name=form_password br input type=submit name=Submit value=Login /form Checks it against the database values using the function 'authenticateUser', returns TRUE or FALSE. If true, sends the user onto the correct page, if false, sends them to some error page. Now, in each other file, you'll need to check the cookies. The values for the cookies are sent automatically by the user's browser. In this particular examples, the cookie variables are named '$cookie_user' and '$cookie_passwd'. You can see in the example how those are set. You will check the cookies using the exact same 'authenticateUser' function. Except in these files, you will use the cookie values as the parameters to the function instead of the form values. Hope this helps. Best regards, Jeremy Reed Mark Ward [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I've got a mySQL database with usernames and passwords. What's the best way to allow authorized users to enter my site? I'm having some problems using the forms properly, they've always been my achilles heel when it comes to web programming. Any help is appreciated. Mark Ward -- PHP General 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] Equivalent of the Basic function SELECT...CASE
switch( $x ){ case 1: case 2: case 3: case 4: case 5: {...} break; default: {...} break; } py At 05:38 PM 12/6/01 +, Robin McKenzie wrote: Could anyone tell me if there is a PHP equivalent to: SELECT x CASE 1 to 5 {...} CASE ELSE {...} END SELECT Muchos gracias. Robin -- PHP General 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 General 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] database question
In the following: select whatever from articles where textlines regexp ^\Sbingo\S$ what does \S means? py - Original Message - From: Jon Farmer [EMAIL PROTECTED] To: Warren Vail [EMAIL PROTECTED]; Michael Hall [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 9:54 AM Subject: Re: [PHP] database question Actually the sql statement you want is select whatever from articles where textlines regexp ^\Sbingo\S$ regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key - Original Message - From: Warren Vail [EMAIL PROTECTED] To: Michael Hall [EMAIL PROTECTED]; PHP List [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 2:57 PM Subject: RE: [PHP] database question Try; SELECT whatever FROM articles WHERE textlines LIKE %searchword% Two warnings; 1) This will force a table scan (the contents of each row in the entire table because there can be no index to support faster searching of contents that float in the column) which will be very slow on a large database (even a medium size one). 2) This will also find words that exist inside other words. (ie the word ward exists inside toward) If you try to solve this by imbedding blanks between the wildcard (%) and the text, you will probably not be able to find the word at the end of a line, or just prior to a comma or period. I also believe there may be a way to make the search case insensitive, look for something like a WHERE tolower(textlines) LIKE ... to force the column values to be all lower case and make sure your search values are all lower case as well. Good luck, Warren Vail -Original Message- From: Michael Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 2:21 PM To: PHP List Subject: [PHP] database question How can I search a MySQL database field that contains sentences (VARCHAR datatype) or entire texts (TEXT datatype) for single words? Let's say I want to search 100 articles stored in a database field as TEXT for the word bingo, is there any SQL or PHP way of doing that? Mick -- Michael Hall [EMAIL PROTECTED] [EMAIL PROTECTED] http://openlearningcommunity.org -- PHP General 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 General 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 General 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 General 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] ASP and PHP
Hello, Please make searchs in the archives of this newsgroup as this was discussed many many times before. The bottom line is always that both language are valuable and will do the job. But PHP will do the job on both MS and Linux, Unix, *BSD... That in itself is the biggest Yippers for PHP ;) py - Original Message - From: Luis Espinosa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 11:43 AM Subject: [PHP] ASP and PHP Hi! I have been using ASP for some time, and now I am beginning with PHP. I would like to know which are the main differences between both languages. I'd appreciate if you can give the advantages and disadvantages of both languages. Thanks Luis Espinosa -- PHP General 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 General 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] Flash and PHP loadvariablesnum
Hello, this question should be ask to a flash forum, php would never open a window!! I used this class to achieve what you asked (http://www.hotscripts.com/Detailed/8970.html) but I know nothing about flash... py - Original Message - From: dharvell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 12, 2001 11:13 PM Subject: [PHP] Flash and PHP loadvariablesnum I have a flash movie that is submitting to a PHP page using loadvariablenum but after being submitted it opens a new window that displays the print line that was supposed to go back to flash. does anyone have any ideas?? -- PHP General 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 General 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] date conversion and calculation problem...
Hello, I have 2 date string like this $t1 = 2001-11-12 17:30:10; $t2 = 2001-11-12 17:15:32; I need to substracts the number of seconds from $t2 from $t1 (because after I have another script thats converts the number of seconds to minutes, hours or days if necessary) I tried: (but it does not give me something rigth) $t1 = explode( , $t1 ); $t2 = explode( , $t2 ); // now $t1[0] contains date $t1[1] contains hours $arr_date1 = explode( -, $t1[0] ); $arr_date2 = explode( -, $t2[0] ); $arr_time1 = explode( :, $t1[1] ); $arr_time2 = explode( :, $t2[1] ); // now $arr_time1[0] contains the hour, $arr_time1[1] contains minute, $arr_time1[2] contains second $t1 = mktime( $arr_time1[0], $arr_time1[1], $arr_time1[2], $arr_date1[1], $arr_date1[1], $arr_date1[0] ); $t2 = mktime( $arr_time2[0], $arr_time2[1], $arr_time2[2], $arr_date2[1], $arr_date2[2], $arr_date2[0] ); print br$t2 - $t1 = . ( $t2 - $t1); hope you can help me, py -- PHP General 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] Re: (another, not entirely)sessions question
It would also be very good to look at what other similar web application are doing and learn from their success and mistake. I am thinking about phpnuke, phpslice, slashdot and the likes... py - Original Message - From: Conor McTernan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 20, 2001 8:02 AM Subject: Re: [PHP] Re: (another, not entirely)sessions question On Fri, Jul 20, 2001 at 11:52:36AM +, Er Galvão Abbott wrote: Just a sugestion here, that may sound strange, but I'd do it like this: Why don't you keep a simle text-counter file for each user? Why this HAVE to go trough SQL? i suppose i want it to go through SQL because I am storing all my documents and the guts of the site in a database. Just creat a text file with 0 on it. When the user posts, retrieve the number from the file, increment it and then write it back... hmmm, interesting idea, but what happens when there are multiple users, each one will then have their own file, i know it wont take up too much disk space, but i really have a thing for tidy directorys:) and this sounds like a nightmare to me ;) This way you don't overload SQL and keep the post counter running... could it in fact create more work for the CPU, if it has to keep reading and writing to files on the disk, as well, would that be any quicker? Tell me what you think, even if you think it's stupid :) haha, i wouldnt say it's stupid anyway, but i wouldnt be attracted to that approach, i'm usually drawn to databases, hehe. On Fri, 20 Jul 2001 12:31:15 +0100, [EMAIL PROTECTED] (Conor McTernan) wrote: Hey there, I'm currently writing a web app using php. I was just looking for some advice on one aspect. On this site, users will be able to log in and post messages, or articles, or replies etc, you get the idea. Anyway, I am storing some info about the users, the usual stuff, name, email, password, all in mysql. I am also storing other info, such as when they last posted, and how many times they have posted. When a user posts a new message, the message is sent to mysql and stored in a table, at the same time, i also have to increment their total number of posts. The way this is done is by selecting the posts field on their userid, which i have to find using their username, which is set as a session var, when the user logs in. This all results in a good few queries to mysql. I was wondering would it be better to load all the user info, e.g. number of posts, last post date, into session vars, or should i set a cookie on the client side, or should i just continue with the queries. Any help is appreciated. conor Er Galvão Abbott Webdeveloper [EMAIL PROTECTED] - To send me an e-mail just remove the CAPITAL TEXT. - -- PHP General 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 General 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 General 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] Re: Simple validation problem
I wonder how that can be enough, if you consider the following form, you can enter 45-98 and it will print ok !! Since all http is coming as a string, I beleive the only way is to test for invalid characters as anything except [0-9] and the dot. (wich is my problem because I do not really know how) I event try with casting amount like this: $amount = (float)($amount); It does not work, I can still input 12r5 for exemple. py if( $amount 0 ){ print ok; }else print smaller than 0: error; if( is_float( $amount )){ print ok; }else print not a float: error; ? FORM ACTION=? print $PHP_SELF ? METHOD=post INPUT TYPE=Text NAME=amount SIZE=4 INPUT TYPE=Submit NAME=Submit VALUE=Submit /FORM - Original Message - From: CC Zona [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:15 PM Subject: [PHP] Re: Simple validation problem In article 00ef01c10fa5$fd20f2e0$e064fea9@py, [EMAIL PROTECTED] (Py) wrote: I am trying to make shure the amount is positive if($amount 0) {...} and is a float if(is_float($amount)) {...} -- CC -- PHP General 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 General 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] Re: Simple validation problem
Ok forget it, someone suggest to me: if ((string)((float)$amount) == $amount (float)$amount 0) { print ok; }else print error; and it works perfectly! py - Original Message - From: py [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 11:14 AM Subject: Re: [PHP] Re: Simple validation problem I wonder how that can be enough, if you consider the following form, you can enter 45-98 and it will print ok !! Since all http is coming as a string, I beleive the only way is to test for invalid characters as anything except [0-9] and the dot. (wich is my problem because I do not really know how) I event try with casting amount like this: $amount = (float)($amount); It does not work, I can still input 12r5 for exemple. py if( $amount 0 ){ print ok; }else print smaller than 0: error; if( is_float( $amount )){ print ok; }else print not a float: error; ? FORM ACTION=? print $PHP_SELF ? METHOD=post INPUT TYPE=Text NAME=amount SIZE=4 INPUT TYPE=Submit NAME=Submit VALUE=Submit /FORM - Original Message - From: CC Zona [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:15 PM Subject: [PHP] Re: Simple validation problem In article 00ef01c10fa5$fd20f2e0$e064fea9@py, [EMAIL PROTECTED] (Py) wrote: I am trying to make shure the amount is positive if($amount 0) {...} and is a float if(is_float($amount)) {...} -- CC -- PHP General 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 General 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 General 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] Simple validation problem
Hello, I am trying to make shure the amount is positive and is a float. (format: $$$.$$) if( $amount == !is_float( $amount ) !eregi( ^[_a-z], $amount ) ){ print Error; } this code does not work when I the input is -25.00 What could be wrong? py p.s. I read what I could on regular expression, but obviously still learning...
Re: [PHP] Time Taken to Process
Mostly Taken from phpbuilder I beleive... // = // Function to start the timer. // = function start_timer(){ $timeparts = explode( ,microtime() ); $starttime = $timeparts[1].substr( $timeparts[0], 1 ); return $starttime; } // = // Function to stop the timer. // = function stop_timer(){ $timeparts = explode( ,microtime() ); $endtime = $timeparts[1].substr( $timeparts[0], 1 ); return $endtime; } // = // Print script execution time // = function script_time( $starttime, $endtime ){ $t_time = ( $endtime - $starttime ); return $t_time; } $starttime = start_timer(); // Script here .. $endtime = stop_timer(); echo brExec: b. number_format( script_time( $starttime, $endtime ), 6 ) ./b secbr; py - Original Message - From: Phil Spitler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 6:57 PM Subject: [PHP] Time Taken to Process Does anyone know an easy way to tell how long a page takes to run in ms. Maybe some variable that can be called at the bottom of the page or something. THANKS! - Phil Spitler [Applications Developer] American City Business Journals p: 704.973.1049 f: 704.973.8049 e: mailto:[EMAIL PROTECTED] -- PHP General 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 General 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] count number of form fields?
A multiple dropdown lists will produce an array is you put [] when naming the list. You than need to count how many elements you have in the array. py p.s. it could be done in javascript as well, but it's so easy in php :) - Original Message - From: Jaxon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 3:32 PM Subject: [PHP] count number of form fields? Hi, Can someone give me an example of how to count the number of form fields entered? E.g. let's say I have three dropdown lists, the first is mandatory, and the second two are optional. I want to be able to tell my target php script how many of the dropdowns are populated. thanks in advance! jaxon -- PHP General 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 General 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] Session timeout
look in php.ini py - Original Message - From: Frédéric Mériot [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 1:33 PM Subject: [PHP] Session timeout How to set the session timeout? -- PHP General 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 General 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] security
But remember that once a user has accessed the .swf once, they can then get the path and call the file directly afterwards. Even worse, the .swf is in the computer's cache. py - Original Message - From: Chris Lambert - WhiteCrown Networks [EMAIL PROTECTED] To: AVisioN:::nomoremedia::: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 5:30 PM Subject: Re: [PHP] security Check what the user agent is for the SWF, and see if it passes a specific referer. That should deter 99% of attempts. /* Chris Lambert, CTO - [EMAIL PROTECTED] WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ - Original Message - From: AVisioN:::nomoremedia::: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 12:08 PM Subject: [PHP] security | Is it possible to restrict the use of a php-file to a special file (for | example an swf). | | | -- | ---: AVisioN :--- | http://www.nomoremedia.de | -::[EMAIL PROTECTED]::- | | I have nothing to declare except my genius._oscar_wild | | | | -- | PHP General 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 General 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 General 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] SQL statement for clearing a table
if you have a numbered primary key, delete from table where primary_key 0 ? (to be handled with care) py - Original Message - From: Wilbert Enserink [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 22, 2001 1:17 PM Subject: [PHP] SQL statement for clearing a table Hi all, anybody knows the mysql statement for clearing the contents of a table and lieving the table itself intact? Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - -- PHP General 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 General 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] Templates??
FYI, at the last ThunderLizard web design conference, a presenter speaking about content management tools said that most sites only need 6 or so templates ... that there are usually only 6 categories of pages. Salut, do you know where we could get more info about that conference? What are his 6 categories of pages? I am focusing on Templating my sites now and I am interested in what was said there. py - Original Message - From: Les Neste [EMAIL PROTECTED] To: Daniel Guerrier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 6:29 AM Subject: Re: [PHP] Templates?? The template defines the look and feel for a class of pages. The advantage is in allowing you to change one file -- the template file -- and have your changes be reflected in all the individual pages that use the template WITHOUT having to individually edit all of those pages. For smaller sites, this may not be a big deal, but, for sites with thousands of pages, you clearly want to avoid hand-edits if at all possible. I'm personally reworking my online portfolio, and I'm now using templates so I can present a different look and feel to suit different potential clients. FYI, at the last ThunderLizard web design conference, a presenter speaking about content management tools said that most sites only need 6 or so templates ... that there are usually only 6 categories of pages. At 05:48 PM 6/18/2001 -0700, Daniel Guerrier wrote: What the true advantage of using templates and where can I get info on using them? __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ Les Neste 678-778-0382 http://www.lesneste.com
Re: [PHP] file download
Hello, I had the same problem as you for months! until someone post this a couple of weeks ago: header(Content-Type: application/octet-stream); header(Content-Disposition: attachment; filename=file.txt); include(file.txt); py - Original Message - From: Aleksey Yarilovets [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 9:44 AM Subject: [PHP] file download Hi everyone! I need user to dowload a file from my server ( Apache ), what i do is: ? header(Content-Type: application/download); header(Content-Disposition: attachment; filename='report.txt'); echo file contents; ? It was working till now but sudenly i start recieve the message from iexplorer: IE can not download ScriptName.php file from the server. IE was not able to open this site. The requested site either unavailable or can not be found. :( Does somebody knows what is going on? Thanks, Alexey. Email: [EMAIL PROTECTED] ICQ# 101975252 -- PHP General 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 General 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] About MySQL Recordset pagination...
I wrote a simple class to do that, it can be modified quite easily. http://www.pywebsolutions.com/source.php Hope this is what you are looking for... py - Original Message - From: Hassan Arteaga [EMAIL PROTECTED] To: Php (E-mail) [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 8:39 PM Subject: [PHP] About MySQL Recordset pagination... Hi all !! I'would like to know if exist in MySQL or PHP functions to implement pagination like ADO (This is for WINDOWS PHP programmers) thanks in advanced !! -- M. Sc. Hassan Arteaga Rodríguez Microsoft Certified System Engineer Network Admin, WEB Programmer FUNDYCS, Ltd [EMAIL PROTECTED] -- PHP General 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 General 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] sending attachements with mail
Here is a nice class that handles e-mail attachment. Works fine for me. py // == // start code // == ?php /* notes from Dan Potter: Sure. I changed a few other things in here too though. One is that I let you specify what the destination filename is (i.e., what is shows up as in the attachment). This is useful since in a web submission you often can't tell what the filename was supposed to be from the submission itself. I also added my own version of chunk_split because our production version of PHP doesn't have it. You can change that back or whatever though =). Finally, I added an extra \n before the message text gets added into the MIME output because otherwise the message text wasn't showing up. /* note: someone mentioned a command-line utility called 'mutt' that can mail attachments. */ /* If chunk_split works on your system, change the call to my_chunk_split to chunk_split */ /* Note: if you don't have base64_encode on your sytem it will not work */ // = // simple class that encapsulates mail() with addition of mime file // attachment. // = class CMailFile { var $subject; var $addr_to; var $text_body; var $text_encoded; var $mime_headers; var $mime_boundary = --==_846811060==_; var $smtp_headers; function CMailFile($subject,$to,$from,$msg,$filename,$mimetype = application/octet-stream, $mime_filename = false) { $this-subject = $subject; $this-addr_to = $to; $this-smtp_headers = $this-write_smtpheaders($from); $this-text_body = $this-write_body($msg); $this-text_encoded = $this-attach_file($filename,$mimetype,$mime_filename); $this-mime_headers = $this-write_mimeheaders($filename, $mime_filename); } function attach_file($filename,$mimetype,$mime_filename) { $encoded = $this-encode_file($filename); if ($mime_filename) $filename = $mime_filename; $out = -- . $this-mime_boundary . \n; $out = $out . Content-type: . $mimetype . ; name=\$filename\;\n; $out = $out . Content-Transfer-Encoding: base64\n; $out = $out . Content-disposition: attachment; filename=\$filename\\n\n; $out = $out . $encoded . \n; $out = $out . -- . $this-mime_boundary . -- . \n; return $out; // added -- to notify email client attachment is done } function encode_file($sourcefile) { if (is_readable($sourcefile)) { $fd = fopen($sourcefile, r); $contents = fread($fd, filesize($sourcefile)); $encoded = chunk_split(base64_encode($contents)); fclose($fd); } return $encoded; } function sendfile() { $headers = $this-smtp_headers . $this-mime_headers; $message = $this-text_body . $this-text_encoded; mail($this-addr_to,$this-subject,$message,$headers); } function write_body($msgtext) { $out = -- . $this-mime_boundary . \n; $out = $out . Content-Type: text/plain; charset=\us-ascii\\n\n; $out = $out . $msgtext . \n; return $out; } function write_mimeheaders($filename, $mime_filename) { if ($mime_filename) $filename = $mime_filename; $out = MIME-version: 1.0\n; $out = $out . Content-type: multipart/mixed; ; $out = $out . boundary=\$this-mime_boundary\\n; $out = $out . Content-transfer-encoding: 7BIT\n; $out = $out . X-attachments: $filename;\n\n; return $out; } function write_smtpheaders($addr_from) { $out = From: $addr_from\n; $out = $out . Reply-To: $addr_from\n; $out = $out . X-Mailer: PHP3\n; $out = $out . X-Sender: $addr_from\n; return $out; } } // usage - mimetype example image/gif // $mailfile = new CMailFile($subject,$sendto,$replyto,$message,$filename,$mimetype); // $mailfile-sendfile(); // Splits a string by RFC2045 semantics (76 chars per line, end with \r\n). // This is not in all PHP versions so I define one here manuall. function my_chunk_split($str){ $stmp = $str; $len = strlen($stmp); $out = ; while ($len 0) { if ($len = 76) { $out = $out . substr($stmp, 0, 76) . \r\n; $stmp = substr($stmp, 76); $len = $len - 76; } else { $out = $out . $stmp . \r\n; $stmp = ; $len = 0; } } return $out; } // end script ? // == // end code // == - Original Message - From: Tolga thorr Orhon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 21, 2001 3:47 PM Subject: Re: [PHP] sending attachements with mail Yes you can do it, but it takes some time as you need to know MIME extensions. It took 2 hours to implement just picture attachments. It will surely be easier to use some kind of script but I couldnt find any that gets attachments direcly (as I am getting attachments from MySql DB) so I did my own. -- Tolga 'thorr' Orhon Mark Wouters [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Nobody knows if it's possible to send attachements with mail()?? Thanks, -- Mark Wouters eXpanded Media Web Designer Parijsstraat 74, B-3000 Leuven - Louvain Tel: +32 (16) 31.10.12 Fax: +32 (16) 31.10.19 E-mail
Re: [PHP] Job listings DB
Hi, I am designing a system for my company to get employee resumes via the Web, rather than paper. All resumes now go into a mySQL DB, which can be searched by HR (at least that's the theory :) [I would do it like that also] My questions: For job listings - how do I design the tables? Can I dump all job listings into a single table, and all applications/resumes into another one? Or should they be normalized? [They should be normalized] If normalized - how much? For example, in a listing, I have job code, department, location, salary range, etc. - should I have separate tables for each of these? Like [Yes, I would say so] jcode dept loc 1 213 2 2 77 3 where dept and loc are FKs to other tables? Or is this taking it too far? [It is not a necessity, but it would be easier to modify or upgrade later, wich we always do] Same for application form. All this information that I am getting - should I put into a single table, or split across separate tables? I do plan to search by differenet criteria later. What about items in drop-downs? For example, if I have a drop-down for salary ranges or countries - should this information come from a table, or should I hard-code into the form itself? How do I make the decision as to which is appropriate? [I would never hard code anything that can change, salary ranges can changes, country can change too :) ] [Besides, in what I call Code Table like country I would have 3 fields: country_id, country_name, country_zorder, you increment country_zorder by 5 The reason: You can later order by country table by name, by id or by a specific order that you defined (putting more popular country on top)] Any assistance much appreciated. TIA, Vikram -- Give a homeless man a bundle of firewood, and he'll be warm for one day. Douse him with a gallon of gasoline and set him on fire, and he'll be warm for the rest of his life! [ouch!] -- PHP General 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] php site hacked?
You are not the only one, this is strange indeed, I would not believe it is a hacked tho. Maybe a technicien mixed up the dns db, or something like that ! Go to: http://uk2.php.net/ wich is fine, py - Original Message - From: sunny hundal [EMAIL PROTECTED] To: Altunergil, Oktay [EMAIL PROTECTED]; 'Philip Olson' [EMAIL PROTECTED]; Don Pro [EMAIL PROTECTED] Cc: php list [EMAIL PROTECTED] Sent: Saturday, May 12, 2001 2:31 PM Subject: RE: [PHP] php site hacked? ok, i just clicked on the uk.php.net/mirrors.php and i got nothing. so i went to uk.php.net and i get some wierd online.co.uk corporate site which has no relation to php at all. am i the only one who gets this feeling someone's replaced the uk.php.net files?? /sunny --- Altunergil, Oktay [EMAIL PROTECTED] wrote: I hate the fact that php.net, phpbuilder.com are down very frequently and mysql.com is slow usually.. It's too bad for our image. Oktay Altunergil -Original Message- From: Philip Olson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:26 PM To: Don Pro Cc: php list Subject: Re: [PHP] Documentation http://uk.php.net/mirrors.php regards, philip On Fri, 11 May 2001, Don Pro wrote: Does anyone know alternative sites for PHP documentation? www.php.net seems to be down. Thankls, Don -- PHP General 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 General 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 General 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] Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- PHP General 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 General 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] class inheritance question
Hello, Class A{ function aa(){} } Class B extends A{ function bb(){ $this-aa();// I know this is ok } } Class C extends B{ function cc(){ $this-bb();// Will this work ? } } py
[PHP] updating flash file with php
Hello, any of you has a tutorial/info on how to update a flash file (swf) with a php script ? (data coming from a text file and a database) py
[PHP] phpize ??
Hello, I am trying to install apc php cache. When I try to run phpize, I get: unable to find config.m4 make shure you run phpize in the top level directory of the module Can somebody tell me how to run phpize and by the way, what is phpize ?? py -- PHP General 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] displaying information
Hello, if you use mysql as a database, see the function Limit For exemple: if ( !isset( $start ){ $start = 0; } $total = 10; // total amount to grab in database $sql = "SELECT * FROM my_table ORDER BY field Limit $start, $total"; $start += 10; // increment your start You display those fields, and you show a next link: a href="? print "$PHP_SELF?start=$start"; ?Next/a But if you do not use mysql, I do not know... py Nick Davies wrote: On Fri, 9 Mar 2001, Jason Stechschulte wrote: On Thu, Mar 08, 2001 at 09:32:25PM -, george wrote: I am building a site which pulls FAQ's out of the database onto a page,but having just finished reading the FAQ's I realise that they will have to be spread over a few pages, how to I get the new page to take over where the old page finished. I would try programming, that usually works for me. You will have to let the program know where you left off, you could pass it in the url, set a cookie, or put it to the session. Either way, just do a little programming and voila. Or you could just pass the offset in the url and use SQL to limit the search. I can't remeber the exact stuff but all you need to do is write the select with an offset (where to start the select) and a limit (10 results perhaps). You will then only get that data set. Just add limit to the offset and pass that onto the next instance of the page to use as the next offset. -- PHP General 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 General 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]