[PHP] mySQL relations query

2002-11-05 Thread Edgard Berendsen
I know this can be a little out of topic but:

I have a books database and each book belongs to a publisher.
There is also a publisher database with information like (name,
location, etc). In the books database there is a key to identify the
publisher.

I need a mySQL query for showing each book with each publisher
name and location.

I don't want to do it using nested loops in .php because I think that
using a master SQL query that can access both tables (all inside mySQL)
and their relations can be much faster.

Thanks




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] parsing variables through webpages

2002-10-07 Thread Edgard Berendsen

I send hidden variables from a form to a php. In the php
I have the following code to convert the global vars sent:

If  (isset($_GET['foo']))
$foo = $_GET['foo']
else
$foo = 0;

But this only works using the GET method!

Thanks for your answer.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Free 'search engine' code

2002-08-11 Thread Edgard Berendsen

Hello,

where can I find the best source for a search engine and
a counter in PHP ?

thanks.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Free 'search engine' code

2002-08-11 Thread Edgard Berendsen


 What sort of counter?
 Hidden? Text file or database based?  Images or text on screen?  Per page?
 Per site?

Hidden or not hidden, database or no database based, with or wtithout
images, per page or per site.

 What sort of search engine?
 Are you searching and indexing text files or text in a databases?  Are
there
 categories and search methods, or just something simple?

For searching HTML files, with cateogries.

Thanks





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Cronjob security

2002-06-04 Thread Edgard Berendsen

If you go to the URL I receive a mail telling me if anybody of
my DB has birthday. Nothing special.

Thanks!

Analysis  Solutions [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Sire:

 ... but I've read it is un-secure.  Is this true?

 Depends.  What happens if I go to that URI and try to run the script?
 If it would cause problems, then yes, it's insecure.  If it doesn't
 matter, than no, it's not.  So, what would happen if I hit your script
 with my web browser?

 --Dan





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] cron: No such file or directory

2002-06-03 Thread Edgard Berendsen

I'm trying to do a cronjob.
If I'm right I should have a php file with
#!/usr/lib/php -q
at the beginning and a cronjob like

MAILTO=[EMAIL PROTECTED]
0 * * * * /usr/lib/php/ $HOME/myfile.php

whereis php tells me:
php: /usr/lib/php /usr/include/php

What's wrong?

At the beginning when I tried with other paths like /usr/bin/php I received
a mail
with 'No such file or directory' error, now I don't receive anything!
Even I change to the old /usr/bin/php wrong dir and I still receive
nothing!!!





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Re: No such file or directory

2002-06-03 Thread Edgard Berendsen

I have a web-hosting and they gave me ssh2 acces.
There I can run lynux commands with no problems.

I don't find php.exe for exectuting the script.
Can I upload a php.exe to the server and run it without any
other file from php?

What can I do?


Edgard Berendsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I'm trying to do a cronjob.
 If I'm right I should have a php file with
 #!/usr/lib/php -q
 at the beginning and a cronjob like

 MAILTO=[EMAIL PROTECTED]
 0 * * * * /usr/lib/php/ $HOME/myfile.php

 whereis php tells me:
 php: /usr/lib/php /usr/include/php

 What's wrong?

 At the beginning when I tried with other paths like /usr/bin/php I
received
 a mail
 with 'No such file or directory' error, now I don't receive anything!
 Even I change to the old /usr/bin/php wrong dir and I still receive
 nothing!!!







-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Cronjob security

2002-06-03 Thread Edgard Berendsen

I'm using the following cronjob in my remote server:

MAILTO=[EMAIL PROTECTED]
0 0 * * * wget -Ofile.log -q -T10 http://www.domain.com/script.php /dev/null

the script.php is a normal php script.
This is the only way I can run a cronjob successfully but I've read
it is un-secure.
Is this true?

Thanks



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] newbie: cron jobs

2002-05-30 Thread Edgard Berendsen

Hi,
I'm new to cron jobs and I need to do one.

1- It's possible to program cron jobs in a remote server where
you can't modify something, for example, a normal web-hosting?

2-Where can I find more informationa about?

3-It's there something special I should know to program one?




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] newbie: cron jobs

2002-05-30 Thread Edgard Berendsen

thanks!

but how can I acces cron -e?
with a php script or I have to use telnet?

Cal Evans [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 1: Yes, if your host has given you permission to run cron jobs. Some hosts
 lock cron to only root or to a specific subset of users. If you have
 permission to create them, crontab -e will give you the editor to edit
them.
 (hint: man crontab.  read it. Now read it again.)

 2: man cron,  man crontab,
 http://www.google.com/search?hl=enq=cron+tutorial

 3: This is one of those, If you have to ask, you can't afford it
 questions. Technically, no, there is nothing special about a cron job
cron
 is a program that runs other programs or shell scripts at pre-determined
 intervals. However, it doesn't bother to check to see if it's a good idea
to
 run the job or if you are going to eradicate all life on earth by running
 this job. cron just runs the job.  If I were you, I'd consult with a
 professional or at least a ranking armature before trying to implement a
 cron job on any machine you care about.

 My $0.02 worth,
 =C=
 *
 * Cal Evans
 * Journeyman Programmer
 * Techno-Mage
 * http://www.calevans.com
 *


 -Original Message-
 From: Edgard Berendsen [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, May 30, 2002 8:11 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP] newbie: cron jobs


 Hi,
 I'm new to cron jobs and I need to do one.

 1- It's possible to program cron jobs in a remote server where
 you can't modify something, for example, a normal web-hosting?

 2-Where can I find more informationa about?

 3-It's there something special I should know to program one?




 --
 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] unable to copy and chmod

2002-01-15 Thread Edgard Berendsen

The probem is that when I copy the file, the owner is set to
something that PHP lately can't change !
This happened to me in 2 tottaly different servers.

I want to copy a file (as a template) and make it writable using PHP.


[EMAIL PROTECTED] [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

 Any file copied with PHP will stay writable from PHP, as the owner is set
to whatever PHP is running under.

 Explain how the file got there and how you'd like to change it (through
PHP, FTP etc.)

 bvr.





-- 
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] unable to copy and chmod

2002-01-14 Thread Edgard Berendsen

unable to copy and chmod

I'm trying to copy a file and chmod it to make it writable, but after I copy
it using PHP I can't even chmod in ftp !
I can't change the file owner too.



-- 
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]