Re: [PHP] PHP vs. jsp, advice please
hi! i run some really big apps (crms/email/shopping carts/directories/forums/etc) that make use of persistance type data but NEARLY all of it is just put in and removed from the DB - just all kinds of little/big functions that need to maintain some data or state(s) of some data - my system averages 20 queries per second - thousands and thousands and thousands of simple queries - the only persistance is with mysql connections just my two cents On Tue, 2003-06-10 at 17:51, Jean-Christian Imbeault wrote: Cpt John W. Holmes wrote: Agree 100%. Don't assume that just because you use JSP, or any other language, your program is going to instantly scale well and be easy to maintain. You can write crappy, inefficient code in any language. You can also write good programs in most any language if you put the proper planning into it before hand. Ok, I've got answers concerning the learning curve and maintainability and some pros and cons that I have found very useful. Now the one last point that I would like to really find out about is persistence. I keep hearing that you can get *true* persistence with jsp/servlets/beans/whatever. I'm still trying to find out more details on this as I can't see how you can get that since HTML is stateless and whatever the backend is it all eventually turns into an HTML connection ... Sessions in PHP are nice but as everyone knows they don't allow for true persistence. And if you want to have your objects persist over a session, that's even more work (and in my short programming career I have not yet found a case where persisting a PHP object across a session was worth the trouble/overhead). Can anyone offer an opinion on this? Is persistence with jsp that much easier compared to PHP? And if true persistence is possible is it all it's cracked up to be? I've often dreamed of being able to have true persistence but if I had it maybe I wouldn't find it all that useful once I'd had a go with it. Thanks, Jean-Christian Imbeault -- Jimmy Brake [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] native vs. phplib sessions
homegrown make a rand value for the cookie -- stick that rand value in a db with the actual user account info ... then we pull the real account info using the random value from their cookie -- simple, efficient and pretty dang secure -- also the system is load balance friendly On Fri, 2003-04-04 at 12:26, Dennis Gearon wrote: How many people are using native vs. phplib sessions, vs. their own/homegrown sessions? The archives show a LOT of problems with native sessions. -- Jimmy Brake [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] cookies with internet explorer on macs
Hi! The cookies i set for people using Internet Explorer on mac (OS X or mac os 8-9) are not staying alive as long as I would like(12hours) they only last for a few hours or sometimes even a few minutes, the time on the end users computers are set correctly. IE on windows is fine and Mozilla and other browsers on linux are fine. This is what I use to set the cookie. $rand = md5(uniqid(rand())); setcookie(sessid, $rand, time()+43200, /); Any ideas? Thanks! Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] cookies with internet explorer on macs
thanks ... lots of my customers use entourage ... On Mon, 2003-03-31 at 20:53, Lowell Allen wrote: From: Jimmy Brake [EMAIL PROTECTED] The cookies i set for people using Internet Explorer on mac (OS X or mac os 8-9) are not staying alive as long as I would like(12hours) they only last for a few hours or sometimes even a few minutes, the time on the end users computers are set correctly. IE on windows is fine and Mozilla and other browsers on linux are fine. This is what I use to set the cookie. $rand = md5(uniqid(rand())); setcookie(sessid, $rand, time()+43200, /); Any ideas? A designer I work with was having problems with his sessions sometimes expiring after a few minutes. He uses OS X/Internet Explorer/Entourage. He determined that whenever he checks his email with Entourage, his session cookie is no longer recognized. He got Microsoft support to duplicate and acknowledge the problem. I use Mac OS 9/Internet Explorer/Outlook Express -- no problem. -- Lowell Allen -- Jimmy Brake [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 databases
yes -- i connect to oracle and mysql simultaneously .. On Wed, 2003-03-19 at 15:21, Iwan van Kanten wrote: Is it possible to connect to 2 different databases?? 2 different dtabase typs I mean postgresql and Mysql -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Weird slowdown using complex functions in a loop
where are you storing the information that you are cleaning once it is cleaned? are you appending it to a variable in the script? On Wed, 2003-03-12 at 00:26, pgcd wrote: Hi, I'm trying to write a script to do some basic XML validation - nothing fancy, basically I just close open tags and check the arguments. The script runs fine, except that, when I use it in a loop (I need to validate roughly 200.000 posts), it gets progressively slower - like, the first ten calls to the function need around 0.01 seconds, next ten take 0.03, then it's 0.1 and so on. I've tried disabling parts of the code, I've tried profiling with dbg, I've tried manually optimizing: nothing. I managed to reduce the slowdown a bit, but it's still there, and very evident (as soon as I reach around a hundred posts, a single function call takes as long as 10 seconds). It may be interesting to note that I had to recode it from scratch: I wrote a class to do the same processing, and *that* ate memory like crazy, ending up with nearly 2 GB of used memory (according to XP taskman). If anybody has come across a similar problem, I'd love to know what did they do to solve it, but a suggestion on how to pinpoint the cause of the slowdown would be great as well. Uh, yes: I'm using PHP 4.2.2 and Apache 1.3.24 on an XP machine (but I've tried using PHP 4.3.0 and Apache 2, with the same results). pgcd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] fopen and file dump to a databace...
hi mark!
i import data all the dang time and this is what i use (more or less)
?
$file = file(sompath/somefile.csv);
for($a=1;$acount($file);$a++)
{
$d = csv_parse($file[$a],,);
$first_name = make_safe($d[0]);
$last_name = make_safe($d[1]);
$company_name = make_safe($d[2]);
$address_1_1 = make_safe($d[3]);
$address_1_2 = make_safe($d[4]);
$city = make_safe($d[5]);
$state = make_safe($d[6]);
$zipcode = make_safe($d[7]);
$country = make_safe($d[8]);
$start_date = make_safe($d[9]);
$query = some insert sql;
$db-Insert($query); // i use a class for my mysql connections
}
function csv_parse($data, $separator)
{
$quote = '';
$values = array();
$toggle = 0;
$len = strlen($data);
$count = 1;
for ($i = 0; $i $len; $i++)
{
$tmp = substr ($data, $i, 1);
if (strcmp($tmp, $quote) == 0)
{
$toggle = $toggle ^ 1;
}
$value = $value . $tmp;
if (strcmp($tmp, $separator) == 0)
{
if (! $toggle)
{
# End of word
$value = ereg_replace(,$, , $value);
$value = ereg_replace(^\, ,
$value);
$value = ereg_replace(\$, ,
$value);
$value = ereg_replace(\+, \,
$value);
$num_of_elems = count($values);
$values[$num_of_elems] = $value;
$value = ;
}
}
}
$value = ereg_replace(^\, , $value);
$value = ereg_replace(\$, , $value);
$value = ereg_replace(\+, \, $value);
$num_of_elems = count($values);
$values[$num_of_elems] = $value;
return ($values);
}
function make_safe($text)
{
$text = preg_replace(/(\cM)/, , $text);
$text = preg_replace(/(\c])/, , $text);
$text = str_replace(\r\n, , $text);
$text = str_replace(\x0B, , $text);
$text = str_replace('', , $text);
$text = explode(\n, $text);
$text = implode( , $text);
$text = addslashes(trim($text));
return($text);
}
On Sun, 2003-03-09 at 18:02, Mark Tehara wrote:
HI, I'm looking to take the data from a CSV file, then upload it into a
mysql databace.
I figure i will need the following.
To count the number of lines ... and cut up each line in its veriables then
entering it into the databace.
I have:
$file = fopen(pricelist-snippet.csv,r);
$buffer = fread($file,1);
echo $buffer;
This dumps the data to the screen ...
where would i start to making cutting this data up by the line?
/ Mark
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] crontab
i think one of us misunderstood your posting ... my suggestion was simply to put a php script in your crontab to be run whenever you set it to go .. if you are writing a php script to update crontab for you as Liam understood your message it is not a good idea ( actually it's a really bad idea :) ) but running a php script versus a bash or perl or whatever script/program is no more a concern than those ( always have security in mind ) On Tue, 2003-03-04 at 13:07, John Taylor-Johnston wrote: Cal, Liam, Jimmy, Thanks. If this is a serious security hazard, could you show me some code that is more secure? I am the root. Mind you I've never worked with crontab before. I want to run /var/www/backup_mysql.php I suppose I should start by putting it somewhere not publicly accessible? Thanks, John Liam Gibbs wrote: Can I run a php script in crontab? Do I echo or print? Anyone doing it? This is a serious security hazard. However, what you could do is have a PHP page set cron settings (such as name of file, location, frequency, and importance), then have another cron job (running at a decent frequency) do the organization. However, this is still a security flaw, as hackers can just take a look at your cron jobs and get in and run their own in place of yours. Probably no more a flaw than normal, though, as if a hacker can get in to replace your cron job, they can get in and run any number of things anyway. Make sure to hard code your cron jobs, as having a downloadable page is a bigger security hazard. You don't want the PHP page to do this itself, because it will have to run as root. I did this one time, and if I'm allowed some time to get my page up, I can e-mail you some instructions. What you'll need is a PHP page, a txt file (for the settings) and a cron job that will read the file and do the necessary steps to arrange the cron jobs itself. -- Jimmy Brake [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] vni - unicode
Hi! I was wondering if anyone has vni - unicode conversion script. Thanks Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mac os 9 - file upload problems
Hi, I have a file upload page that accepts file uploads from pretty much every browser and os EXCEPT any browser on mac os 9. I have no idea why, any of you ever have problems with file uploads on mac os 9? How did you solve the issue. -- Jimmy Brake [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Flow diagrams.-- Resending
On Mon, 2002-12-30 at 06:59, Sridhar Moparthy wrote: Hi Jimmy, Thank You for the your reply. Here is the example. If 1. Jobs 'B' and 'C' starts immediately after Completion of job'A' 2. Job 'D' starts after completion of both Jobs 'B' and 'C'. 3. Job 'E' starts after completion of job 'C' 4. ... job = object What makes the jobs different -- should the images for different jobs be different images? Do the connecting lines need to represent objects bouncing around inside a computer, a network or the real world? Do the objects transition between the real world - inside a computer and through networks? I just need to get a grasp. Do the connecting lines always connect to the same place or are they places on an object can connecting lines have bends? If they bend can they cross other lines or pass through objects they are not related to? (lots of other questions like this) Can you show me data from your db(change the names if security is an issue). Also some general descriptions or what each job is would be great. Such as is it a function or an object or class or is this data bouncing between servers and respective processes. And things that you are looking for in the image. H if the layout is always the same then the graphic class can be quite simple but if the layout changes it could make things much more complex. The I would like to see the following image. [image] If you can not see the image, Please see the attached file. Thank you. Sridhar. -Original Message- From: Jimmy Brake [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 4:23 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Flow diagrams.-- Resending can you give us some examples of the data .. the example I would like to see is: based on this information this is what should be displayed On Fri, 2002-12-27 at 11:48, Sridhar Moparthy wrote: Hi Every one, I have information about some processes in the database that tells different process dependencies. I need to display that information as a process flow diagram. Do you know how to prepare and display process flow diagrams dynamically. Do you know anything like JPGraph or Java script or java applet that can do this? If so Please help me. I am using PHP 4.xx and IIS on Win NT platform. Please help me if you know how to do. Thank You, Sridhar Moparthy -- Jimmy Brake [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] uploading + downloading Large files ...
Hi! My users need to upload and download large files (100 + megs). Right now I only allow 100k to be uploaded. Will I need to do anything to php/apache to make sure things continue to be reliable? My google search only found threads with bad endings and they had much smaller files. Should i just make em use ftp or scp? The problem with using one of those protocols is that it makes it difficult for the users to link the files to the proper account/relation/incident and anything that is a problem for users is usually a problem for me. Thanks! Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Flow diagrams.-- Resending
can you give us some examples of the data ... the example I would like to see is: based on this information this is what should be displayed On Fri, 2002-12-27 at 11:48, Sridhar Moparthy wrote: Hi Every one, I have information about some processes in the database that tells different process dependencies. I need to display that information as a process flow diagram. Do you know how to prepare and display process flow diagrams dynamically. Do you know anything like JPGraph or Java script or java applet that can do this? If so Please help me. I am using PHP 4.xx and IIS on Win NT platform. Please help me if you know how to do. Thank You, Sridhar Moparthy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] monster form and compression?
IE has some bugs when you have big forms when using [] test with mozilla or netscape if thats the case -- then errr well umm use what works On Fri, 2002-12-27 at 12:50, Jeff D. Hamann wrote: I have a monster form (really a funky grid - hey the client is always right) that does not display entirely each time the form is displayed. Some times, quite repeatably, the bottom half of the form's select boxes will be blank (not good). Is there a way to compress the web page before it gets sent, or any method to ensure the page will display correctly? Jeff. -- Jeff D. Hamann Hamann, Donald Associates, Inc. PO Box 1421 Corvallis, Oregon USA 97339-1421 Bus. 541-753-7333 Cell. 541-740-5988 [EMAIL PROTECTED] www.hamanndonald.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Flow diagrams.
to my knowledge there is nothing in php that does that good luck On Thu, 2002-12-26 at 11:17, Sridhar Moparthy wrote: Hi Every one, Do you know how to prepare and display process flow diagrams dynamically based on some data from database. I have information about some processes in the database that tells different process dependencies. I need to display that information as a process flow diagram. I am using PHP 4.xx and IIS on Win NT platform. Please help me if you know how to do. Thank You, Sridhar Moparthy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] a good imap library?
Hi! I am looking for a good imap library .. That will let me: login logout list folders list contents of a folder retrieve email retrieve just headers retrieve the attachement of an email get the number of messages in a mailbox set server side filters etc I have been digging around squirrel mail but I am not to happy with what I am seeing -- looks very mature but I would prefer something that is OO. Thanks in advance, Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] update query based on array
not real sure of the setup of the form but if you have mutiple groups of
items to be updated then you should make the rank an array -- rank[pid#]
you should make all the items -- that are related part of the same group
-- by using []
On Mon, 2002-12-09 at 15:06, Jason Dulberg wrote:
I am displaying a list of data (from an sql query) and some of the fields in
that list are editable through a form. If the user chooses to edit one or
more of the rows of data, they must click on a checkbox to add that row to
an update array. The problem is that when I read that array to pass to an
UPDATE sql statement, it only passes the last entry of the array.
Here's an example of the data being passed:
13 - 4 - UPDATE ranking SET category='Prep School', rank='30' WHERE pid=4
14 - 169 - UPDATE ranking SET category='Prep School', rank='30' WHERE
pid=169
15 - 166 - UPDATE ranking SET category='Prep School', rank='30' WHERE
pid=166
The above is created based on the following html code:
//the last row
input type=text name=category value=Prep School
input type=text name=rank value=30 size=4
input type=checkbox name=rankid[15] value=166
So as you can see, its only reading the last row and assigning its values to
the data above as well.
Here's what I'm using for the sql query:
while(list($key,$val)=each($rankid)) {
$upd=mysql_query(UPDATE ranking SET category='$category', rank='$rank'
WHERE pid=$val);
}
If anyone has any suggestions for fixing this problem, please let me know :)
THanks
__
Jason Dulberg
Extreme MTB
http://extreme.nas.net
--
Jimmy Brake [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Looking for good ZIP Code / Latitude / Longitude table
how much does the service cost? or am misunderstanding the class? why do you have to enter a password? On Wed, 2002-10-30 at 11:31, Manuel Lemos wrote: Hello, On 10/30/2002 04:03 PM, Michael Zornek wrote: I've written a nice php/mysql site that let's you search for hospitals and community colleges by zip code. The search is built upon some math that figures out distances by a zip's lat and lon cords. My problem is that my current ZIP table (bout 42,000 rows) seems to be flawed. There are a ton of zip codes round california that have all the same lat and lons. There are other dups as well. So I'm looking for some new data. Does anyone know a good source for this type of info? This class may be used to figure the coordinates of a location given the IP address of a computer (the user computer): http://www.phpclasses.org/netgeoclass -- Regards, Manuel Lemos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cleaning pasted Word text
for file maker pro (windows/mac) -- word (windows/mac)
function make_safe($text)
{
$text = preg_replace(/(\cM)/, , $text);
$text = preg_replace(/(\c])/, , $text);
$text = str_replace(\r\n, , $text);
$text = str_replace(\x0B, , $text);
$text = str_replace('', , $text);
$text = explode(\n, $text);
$text = implode( , $text);
$text = addslashes(trim($text));
return($text);
}
function make_safe2($text)
{
$text = str_replace(\r\n, \n, $text);
$text = preg_replace(/(\cM)/, \n, $text);
$text = preg_replace(/(\c])/, \n, $text);
$text = str_replace(\x0B, \n, $text);
$text = addslashes($text);
return($text);
}
cannot remember I why put in two functions ... but anyhow have fun you
will probably not the the implode / explode either
On Tue, 2002-10-29 at 16:39, Daniel Guerrier wrote:
Paste into notepad, the copy the text from notepad.
Notepad should remove the high ASCII text.
--- Brent Baisley [EMAIL PROTECTED] wrote:
I think you have posted before and probably didn't
get an answer. I'm
not going to give you an answer (because I don't
have one), but perhaps
I can point you in the right direction.
Look at http://www.w3.org/TR/REC-html40/charset.html
and see if that
helps you. Below is a paragraph I pulled from it.
The document character set, however, does not
suffice to allow user
agents to correctly interpret HTML documents as they
are typically
exchanged -- encoded as a sequence of bytes in a
file or during a
network transmission. User agents must also know the
specific character
encoding that was used to transform the document
character stream into a
byte stream.
On Tuesday, October 29, 2002, at 02:20 PM, a.h.s.
boy wrote:
I'm working on a PHP-based CMS that allows users
to post lengthy
article texts by submitting through a form. The
short version of my
quandary is this: How can I create a conversion
routine that reliably
substitutes HTML-acceptable output for high-ASCII
characters pasted
into the form (from a variety of operating
systems)?
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search Advisory Services for Advanced Technology
Environments
p: 212.759.6400/800.759.0577
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] What causes this?
Hi, I am getting this error randomly, just stops and starts. Error: Unable to select database: crm :Commands out of sync; You can't run this command now './configure' '--with-oracle=/opt/oracle/product/8.1.6/' '--with-oci8=/opt/oracle/product/8.1.6/' '--enable-sigchild' '--enable-track-vars' '--enable-wddx' '--with-mysql' '--with-jpeg-dir=../jpeg-6b/' '--with-t1lib=../t1lib-1.3.1' '--enable-wddx' '--with-apache=../apache_1.3.27' '--with-mysql=/usr/local/mysql/' The site ran fine till the upgrade any ideas how I can get rid of this or should I just rollback the update? Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] missing function? array_change_key_case()
Hi! When I run this command ... $foo = array_change_key_case($foo, CASE_UPPER); I get this error .. Call to undefined function: array_change_key_case() in /index.php on line 181 Yet the function (should) exist: http://www.php.net/manual/en/function.array-change-key-case.php I am running 4.x any ideas? Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] missing function? array_change_key_case()
yep thats it ... On Wed, 2002-07-17 at 18:02, John Holmes wrote: Works fine for me on 4.2.1 You have to have at least 4.2.0, do you? ---John Holmes... -Original Message- From: Jimmy Brake [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 8:53 PM To: [EMAIL PROTECTED] Subject: [PHP] missing function? array_change_key_case() Hi! When I run this command ... $foo = array_change_key_case($foo, CASE_UPPER); I get this error .. Call to undefined function: array_change_key_case() in /index.php on line 181 Yet the function (should) exist: http://www.php.net/manual/en/function.array-change-key-case.php I am running 4.x any ideas? Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] ^k ? -- how do I match that?
Hi! I keep getting that evil little character ... ^k from mac users (pre X) and I need to remove it. Does anyone know how to remove? This site has that character as a vertical tab. This character is what is used in MS Excel when people hit return inside a cell. If they copy and paste that into a form its ok, but when I export that data to a csv it gets ugly. http://www.robelle.com/smugbook/ascii.html Thanks in advance! Jimmy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
