[PHP] cookies
You have to call setcookie() before anything is outputtedthat was it sounds like. SL.
[PHP] User/Group for PHP
Yo, Anyone know of a cfg option that would make files written by php be a different user/group than the apache server user/group? With my current setup, the only way to give php write access also allows any surfer write access to that same folder...which is "not a good thing". Thanks, SL.
Re: [PHP] SQL - Select rand() ?
Sup, In the newer versions of mySQL, you can get random results like SELECT id FROM table ORDER BY rand() LIMIT 0,1 SL. - Original Message - From: "James, Yz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 17, 2001 2:55 PM Subject: [PHP] SQL - Select rand() ? > Hi Guys, > > If I wanted to retrieve just one field randomly from a MySQL table, would I > just use something like: > > "SELECT RAND(id) FROM table LIMIT 0,1" ? > > I suppose the best thing for me to do would be to try it, but I am fast > losing the will to stay awake ;) > > Thanks, as always, > > James. > > > > -- > 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] Which is better coding style...
Personally, I hate trailing {'s
I think this
function blah()
{
switch( $bob )
{
case 1:
$var = "whatever";
break;
}
}
Is much easier to read and follow. As for the exiting question...
The "proper" way is to use the breaks. "They" say that multiple returns in
any function = bad programming. The .0001 second that it takes to break and
return the value will never matter.
Plus, you or someone else may have to add to that function later. Let's say
I wanted to add "" to the end of $retval. If you use the normal way I
can just make one change, return $retval . ""; instead of changing 3
different returns.
SL.
- Original Message -
From: "Boget, Chris" <[EMAIL PROTECTED]>
To: "Php (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 11:57 AM
Subject: [PHP] Which is better coding style...
> Which is better?
>
> function blah() {
> switch( $bob ) {
> case 1:
>return "this";
>
> case 2:
> return "that";
>
> default:
> return "other";
>
> }
> }
>
> function blah() {
> $retval = "";
>
> switch( $bob ) {
> case 1:
>$retval = "this";
>break;
>
> case 2:
> $retval = "that";
>break;
>
> default:
> $retval = "other";
>break;
>
> }
>
> return $retval;
>
> }
>
>
> In other words, is it good practice to exit out of a block (any
> block... not just switch; if, for, while) prematurely as demon-
> strated in the first example? Or should you do it as demon-
> strated in the second example?
>
> Chris
>
--
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] Site Searchable function
Hey,
Well, I would write two scripts. One to pregen a reference database and
one to search using that database.
The pregen could use the readdir function that Matthew Luchak suggested.
You could use the fopen command to get the pages.
fopen("http://localhost/name-of-file") will return the rendered page instead
of the page with the mixed-in source. You could then use the striptags()
function. Now you have just the text and it has any dynamic content from
the php code. Parse that file, throw out any words that are less than like
3 characters.
There are tons of ways to store the words and pages, the simpilest being to
just to store the word and then a list of the pages that it appears on.
Maybe even tie in how many times it appears in each page.
Anyway, throw that pregen page into a daily or hourly cron and boom, done.
Then write a search page that just looks for each word, find the correct
pages, and makes links to them.
I don't know of any sites that explain how to do search engines but this way
will work :)
SL.
- Original Message -
From: "Kevin A Williams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 11:11 AM
Subject: [PHP] Site Searchable function
Hi,
I was wondering whether anyone could direct me in the direction of creating
a search function like the one on php.net?
I have tried looking rather fruitlessly to implement a system, would one
possible implementation be to use reference files for the information and
then use string matching to analyse the information, or search the source
.php files (although security issues of revealing scripts).
Thanks in advance
--
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] Starting PHP script with crontab
Sup, You have to make the output write to a file. Like lynx http://www.page.come > /home/me/bleh.htm SL. - Original Message - From: "Bertjan Schrader" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 4:15 AM Subject: [PHP] Starting PHP script with crontab > I need tot start a PHP script at night with the crontab. I tried to do it > with lynx (lynx http://www.domain.nl/test.php) as a commandline within the > crontab. Lynx is starting but the PHP script is not working. Anyone an idea > how to do it? > > OS: Redhat Linux 5.2 > Apache > PHP as a apache module > > thanks! > > > > -- > 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] PERL vs. PHP
No, you won't. PHP is has very similar syntax to c/c++ and perl but the concepts are extremely different. SL. - Original Message - From: "Jason Caldwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 3:10 PM Subject: [PHP] PERL vs. PHP > If I know PHP will I *basically* know PERL? Looking at some PERL code... it > looks nearly identical. > > Thanks. > Jason > > > > > -- > 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] mysql_free_result
Sup, PHP will automatically free results after the script finishes. But, PHP has a memory cap, I think the default is 8megs -- check php.ini. Anyway, so lets say you wanted to pull 2 large results sets. You may get a memory error. So you could pull 1 result, do the necessary calculations, free the result, fetch the next set, etc. I doubt it would slow the script, but if you actually *needed* to use it...the script would probably be pretty slow anyway. SL. - Original Message - From: "Randy Johnson" <[EMAIL PROTECTED]> To: "Rasmus Lerdorf" <[EMAIL PROTECTED]>; "Randy Johnson" <[EMAIL PROTECTED]> Cc: "Php-General" <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 1:02 AM Subject: RE: [PHP] mysql_free_result > Does the Mysql_free_result slow down the script at all? > > Randy > > -Original Message- > From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 20, 2001 8:49 PM > To: Randy Johnson > Cc: Php-General > Subject: Re: [PHP] mysql_free_result > > > > Does php release the memory used by the result set when it is done > > executing? > > Correct > > > if so why should I use mysql_free_result() > > In case you are making multiple queries within the same script and want to > keep your runtime memory usage low. > > -Rasmus > > > > -- > 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] Apache, PHP, Windows XP, MSIE 6, Cheese, and Cookies.
Yea, I got a solution. Choose a flavor of linux, format your HD, install, and run the that server like it was meant to run. Apache is not even 100% on NT much less the XP beta, it's like your running a beta on a beta...That's why it's not working. Here is a good quote from apache.org: "Please note that at this time, Windows support is entirely experimental, and is recommended only for experienced users." :) I'm not trying to be a linux zealot, but you will encounter more strange problems like this on windows... SL. - Original Message - From: "Padraic Tynan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 1:28 PM Subject: [PHP] Apache, PHP, Windows XP, MSIE 6, Cheese, and Cookies. Hey, I'm new to the list, and this issue may have already been addressed... It seems that with Apache and PHP (running in Windows XP Beta 2, which identifies to Apache as an NT system) as the server and being accessed by MSIE 6.0b or MSIE 5.5 that cheese doesn't taste right. No, wait, that's not the issue. The issue is that unless the page is what the browser opens with (ex: desktop shortcut, address bar request, being set as the browser's "home" -- anything where no page, not even the "Action cancelled." page, is opened) the cookies I setcookie() are saved as session cookies (yo know, not saved in a file), whereas if it's the first page the browser opens, they're saved in the Cookies folder where they're supposed to go, as a bona fide file. Is there a solution to this issue yet? Has anyone else noticed it? :) -- 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] problem with storing & displaying image in db
Why not just store the filename?
SL.
- Original Message -
From: "Keyur Kalaria" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>
Sent: Saturday, April 21, 2001 9:52 AM
Subject: [PHP] problem with storing & displaying image in db
> Hello everybody,
>
> I am facing a strange problem while uploading and displaying images in a
> database table.
>
> I have taken blob field to store the images.
>
> Images which are less then around 100kb are stored & displayed properly
but
> images which are greater than 100kb are giving problems while displaying
> although no errors were generated while inserting them in database.
>
> what could be the problem ? is it due to the blob type ?
>
> i am using the following statements to insert the file to database.
>
> insert.php
> ***
> $imgsize=GetImageSize($photofile);
> $photo=addslashes(fread(fopen($photofile, "r"), filesize($photofile)));
> $query="insert into photo(photoformat,photo,photowidth,photoheight) values
> ('$photoformat','$photo',$imgsize[0],$imgsize[1])";
>
> $photoformat, $photofile are the input fields of the form which is
> submitted.
>
> ***
>
> in my html pages i use the following :
>
>
>
> and my display.php is as follows:
>
> display.php
> ***
> $query="select * from photo where id='$id'";
> $result=mysql_query($query);
> $photo_rec=mysql_fetch_array($result);
> Header( "Content-type: image/$photo_rec[photoformat]; name=".microtime());
> echo $photo_rec["photo"];
>
> ***
>
>
> Thanks in advance
>
> Keyur
> $$$
>
>
>
>
>
> --
> 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] getting rows from separate tables stacked in a single array ? (newbie, mysql)
Sup,
It can be done...but it will be complicated. First off. You should
check out the extract() php command.
http://php.net/extract
This function makes entries in an array into local variables. Let's say
your row array has 2 columns, title and duration.
You can do:
while( $row = mysql_fetch_assoc($result) )
{
extract( $row , EXTR_PREFIX_ALL , "qt_"); // last parameter is a prefix
to add onto the var names
echo "title = $qt_title , duration = $qt_duration";
}
---
Now onto the mysql goodness. I don't know of any way to stack rows from
different tables. It really wouldnt work because the column names would
probably be different. Doing a join isn't going to work either because the
tables will probably not contain the same number of rows.
I suggest selecting just the row id and creation time from each of your
tables. Like:
$result1 = mysql_query();
$result2 = mysql_query();
$result3 = mysql_query();
Then
while( !$dead1 || !$dead2 || !$dead3 )
{
if(!$row1 && !$dead1) $row1 = mysql_fetch_assoc() or $dead1 = true;
if(!$row2 && !$dead2) $row2 = mysql_fetch_assoc() or $dead2 = true;
if(!$row3 && !$dead3) $row3 = mysql_fetch_assoc() or $dead3 = true;
// compare all 3 times, find nearest one
// store winning row id into a temp var, like win_id;
// have a list of table names which corresponds to the rows. row1 =
blah_tbl , row2 = eh_tbl , row3 = wow_tbl
// store table name from winning row, store in win_table;
// and finally set the winning row to 0, so that row will be fetched next
time through the loop
$each_result = mysql_query("select * from $win_table where id =
$win_id");
Output_my_Result( $each_result );
}
It sure ain't pretty, but that's how I could do it...Hopefull all that helps
you somehow.
SL.
- Original Message -
From: "Nicolas Mermet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 2:42 PM
Subject: [PHP] getting rows from separate tables stacked in a single array ?
(newbie, mysql)
> Hi.
>
> This will probably sound simple to all of you but I am hitting my head on
> a brick wall so far :-).
>
> I need to generate a list (sorted by descending time) of different objects
> referenced in multiple tables. All those objects share a key related to a
> project.
>
>
> This works splendidly from a single table :
>
>
>
>
> $sql="select * from storyboards, where spot_id = \"$spot_id\" order by
> date_posted desc";
> $result=MySQL_query($sql,$db);
> while($row=MySQL_fetch_array($result))
> {
> $qt_title = $row["title"];
> $qt_duration = $row["duration"];
> $qt_date_posted = $row["date_posted"]; //(timestamp)
> $qt_description = $row["description"];
> $qt_id = $row["quicktime_id"];
>
>
> }
>
> Is there a mysql query that would allow me to stack complete rows in
> multiple tables at once (It seems more elegant because I can sort them
> while extracting them) or is there a way in PHP to concatenate results in
> a single array and then sort them by time... ?
>
> I tried to use a join query, wich produced an invalid query error. (I
> think it tries to produce a table with merged data, not just a stack of
> rows).
>
>
> $sql4="select * from quicktimes, other_images, storyboards, where
> quicktimes.spot_id, other_images.spot_id, storyboards.spot_id =
> \"$spot_id\" order by date_posted desc";
>
> thank you for your help !
> nicolas
>
> --
> 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] random letters and numbers
Sup,
I made this and have been using it for about 6 months without problem.
mt_rand() is 4 times faster than normal rand(), remember to use mt_srand()
to seed. The 8 in the while controls how long the $password will be...
$count = 0;
mt_srand( (double) microtime() * 100);
while( $count < 8 )
{
$randval = mt_rand(48 , 122);
$timeout++;
// currently allows 0-9 and a-z (lowercase), add 65-90 for uppercase
if(($randval > 47 && $randval < 58) || ($randval > 96 && $randval < 123))
{
$password .= chr($randval);
$count++;
}
}
SL.
- Original Message -
From: "Randy Johnson" <[EMAIL PROTECTED]>
Cc: "Php-General" <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 12:10 AM
Subject: [PHP] random letters and numbers
> Is there a way to generate a random set of characters ranging from 8 to 12
> characters and numbers where it is crucial that the letters and numbers
are
> truly random because I need to create temporary files for people to
download
> information.
>
> Any links/suggestions would be greatly appreciated
>
> Thanks
>
> Randy
>
>
> --
> 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] getting rows from separate tables stacked in a single array ? (newbie, mysql)
Doh, I shoulda thought of that, a temp table is the best way to do it.
Altho, I don't see why you have a spot_id as a key for that table. Your are
probably never going to access that table via that arbitrary number. If
anything, you should make item_id the key. The id on your other tables
should also be keys.
SL.
- Original Message -
From: "Nicolas Mermet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 8:50 PM
Subject: Re: [PHP] getting rows from separate tables stacked in a single
array ? (newbie, mysql)
>
> Thanks a bunch, SL. I was expecting some heavy manipulation of that sort.
> Wouldnt have been able to write that code. (yet ! ;-). I will try that
> tomorow.
>
> This afternoon In despair I ended tweaking the db and creating an extra
> table to link all the desired tables with a time indice, temporarily
> solving my problem but promising future headaches when I devellop the db
> admin page. Here is how I dit it:
>
>
>
> table "all_items"
> item_id (id of the items in their original tables)
> date_posted (original item post date)
> table_name (where the item comes from)
> spot_id (key to the project)
>
>
> It works with this code:
>
>
>
>
> //connecting to the link table to get time-ordered list of relevant items,
> their origin and their keys
>
> $sql4="select DATE_FORMAT(date_posted, '%a %m/%d/%y at %l:%i %p.'),
> item_id, item_table from spot_items where spot_id = \"$spot_id\" order by
> date_posted desc";
> $result4=MySQL_query($sql4);
> while($spotitems=MySQL_fetch_array($result4))
> {
> list($items_date_posted, $items_id, $items_table) = $spotitems ;
>
> //linking to the real tables to get the real item info
>
>
> $sql5="select * from $items_table where item_id = \"$items_id\"";
> $result5=MySQL_query($sql5);
> while($items=MySQL_fetch_array($result5))
> {
> $items_title = $items["title"];
> $items_description = $items["description"];
> $items_duration = $items["duration"];
> }
>
> //outputing in fonction of the item origin
>
> if ($items_table == "movie")
> echo "$items_title (Quicktime, duration: $items_duration)
> $items_date_posted$items_description
> if ($items_table == "storyboard")
> echo "$items_id\ $items_title (Storyboard) $items_date_posted
> $items_description";
>
> if ($items_table == "picture")
> echo "$items_title(Picture) $items_date_posted
$items_description";
>
>
> }
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> thanks again,
> Nicolas.
>
> --
> 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 Query time?
Sup,
Adding "explain" before the select query will show you how long it will
take, along with some other info, but it won't actually give you the
results.
I use a the function microtime (http://php.net/microtime) to figure
execution time. When called, microtime will return a string with
miliiseconds then seconds seperated by a space. So you have to do something
like this...
function sn_Msecs()
{
$mt = microtime();
$mt = explode(" " , $mt);
return ($mt[1] + $mt[0]);
}
That will return seconds.milliseconds or something like 13123141.1231, it is
not in proper math form.
Just call it before a block of code or query, then call it after and
subtract the second one from the first.
SL.
- Original Message -
From: "James, Yz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 2:17 PM
Subject: [PHP] SQL Query time?
> Hi all,
>
> I have seen a few pages that echo the time it's taken to execute an SQL
> query, like "The results in the database were returned in 0.3 seconds."
> Anyone know if there's a built in function to display this, and if there
is,
> what it is? My more-than-useless-ISP seems to have taken an aversion to
> allowing me to surf tonight without disconnecting me.
>
> Thanks.
> James.
>
>
>
> --
> 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] problems with a netscape post
Try giving the form a name? I normally use something like... Any it works in NS 4+ SL - Original Message - From: "Quentin Gillet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 19, 2001 10:06 AM Subject: RE: [PHP] problems with a netscape post > I have the same problem, I'm curious to hear what people say about this > > -Message d'origine- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Envoyé : dimanche 19 août 2001 16:34 > À : [EMAIL PROTECTED] > Objet : [PHP] problems with a netscape post > > > Hi, > > I am trying to post some form data to a php page that then updates a > mysql database and echos back to the browser that the data has been > inputted. Here is the general form of my post;- > > > > .. form widgets here . > > > > > this works perfectly with IE and opera, but with netscape 4.* it > either takes ages for the event to transpire or times out. I am not > trying to post any files ect, just text field data, 1k max, anyone > have any ideas what is going wrong? > > thanks > > > -- > 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]
