php-general Digest 12 Feb 2001 07:44:46 -0000 Issue 507
Topics (messages 39137 through 39181):
Re: afraid !
39137 by: Joe Stump
39168 by: Kath
39169 by: Jaxon
Search & replace text
39138 by: CDitty
39155 by: David Robley
Re: comparisons
39139 by: Curtis Maurand
39148 by: Phil Driscoll
39159 by: Curtis Maurand
gambling goes MLM
39140 by: w334nnlsfd3d.hotmail.com
jpeg parsing
39141 by: Chinatown
oops - wrong! (was: how to alter assoc_array?)
39142 by: Jaxon
39145 by: Jaxon
mysql auto-increment
39143 by: Christian Dechery
A way to duplicate data across databases
39144 by: Carsten Gehling
First connection?
39146 by: Info
39147 by: Jaxon
Re: good free/cheap IDE for PHP
39149 by: Brian White
transactions
39150 by: Christian Dechery
39160 by: Curtis Maurand
Building php4.0.4pl1 with mysql 3.23.32
39151 by: Scott Brown
Re: To The Hacker: CodeBoy
39152 by: rswfire
39154 by: Jason Murray
39180 by: Matt McClanahan
open_basedir error message.
39153 by: Floyd Baker
rewriting this SQL query to remove subselect
39156 by: Scott Mebberson
39179 by: Ifrim Sorin
rewriting this SQL statement to remove subselect
39157 by: Scott Mebberson
Problems installing PHP 4.0.4pl1 on RedHat 6.2
39158 by: Pablo Pasqualino
change password in NIS using PHP
39161 by: karu
"wide open"
39162 by: Dan Harrington
39164 by: Jason Murray
39165 by: Josh G
unsubscribe php-general
39163 by: John McKown
fscanf problem
39166 by: John Vanderbeck
Re: Previous Next problems !!
39167 by: Manuel Lemos
way to save data
39170 by: McShen
Re: FDF Toolkit uncompression error
39171 by: Kurt R. Hoehn
checking for presnet file name
39172 by: John LYC
39176 by: Ankur Verma
Preserve variables between page loads?
39173 by: Chuck Mayo
39177 by: Ankur Verma
Re: column into array?
39174 by: andrew
Re: newline processing problem?
39175 by: Ankur Verma
Arrgghh, Regular Expressions?!?!
39178 by: Scott Mebberson
Fatal Error!
39181 by: chuck.moongroup.com
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Heaven forbid you use a command line. I wouldn't trade my *NIX prompt for
anything. Once you learn it you're set. MySQL's prompt is much like Oracle's
prompt and we all know Access has NO business anywhere near "enterprise"
software.
I'd recommend learning the command prompt (which an hour's read on linuxdoc.org
can fix). If you decide to move to PHPMyAdmin (ack!) I'd be willing to bet you
move right back to the power of the prompt.
My $0.02
--Joe aka "Lover of the Prompt"
On Sun, Feb 11, 2001 at 07:17:50PM -0000, php php wrote:
> Hi!
> i've just joined ur mailing list!
> i used to work on asp with oracle and access!
> i'm working on windont NT but i want to publish my site at a provider that
> has linux? do i have to change my code for that ?
> do u know any provider that accepts acces and mysql with php4?
> i'm afraid of using mysql with php cause i'm in hurry and that i discovered
> that mysql interface is not as good and easy as of oracle and access! is it
> true that if i want to insert data to a table i have to do it from the
> commend line?
> Thanks a lot
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> --
> 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]
--
-------------------------------------------------------------------------------
Joe Stump, PHP Hacker, [EMAIL PROTECTED] -o)
http://www.miester.org http://www.care2.com /\\
"It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V
-------------------------------------------------------------------------------
Hell yes to phpmyadmin, IMHO.
I use it on all my servers.
- Kath
----- Original Message -----
From: "php php" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 2:17 PM
Subject: [PHP] afraid !
> Hi!
> i've just joined ur mailing list!
> i used to work on asp with oracle and access!
> i'm working on windont NT but i want to publish my site at a provider that
> has linux? do i have to change my code for that ?
> do u know any provider that accepts acces and mysql with php4?
> i'm afraid of using mysql with php cause i'm in hurry and that i
discovered
> that mysql interface is not as good and easy as of oracle and access! is
it
> true that if i want to insert data to a table i have to do it from the
> commend line?
> Thanks a lot
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> --
> 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]
>
anyone try myphpPagetool?
it seems to be of the same camp.
regards,
jaxon
On 2/11/01 10:28 PM, "Kath" <[EMAIL PROTECTED]> wrote:
> Hell yes to phpmyadmin, IMHO.
>
> I use it on all my servers.
>
> - Kath
>
> ----- Original Message -----
> From: "php php" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, February 11, 2001 2:17 PM
> Subject: [PHP] afraid !
>
>
>> Hi!
>> i've just joined ur mailing list!
>> i used to work on asp with oracle and access!
>> i'm working on windont NT but i want to publish my site at a provider that
>> has linux? do i have to change my code for that ?
>> do u know any provider that accepts acces and mysql with php4?
>> i'm afraid of using mysql with php cause i'm in hurry and that i
> discovered
>> that mysql interface is not as good and easy as of oracle and access! is
> it
>> true that if i want to insert data to a table i have to do it from the
>> commend line?
>> Thanks a lot
>> _________________________________________________________________________
>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>>
>>
>> --
>> 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]
>>
>
Hello all. I am trying to search through a text file on my server to
replace the user email. I can open the file and read it, but cannot get it
to "find" the actual string and replace it. Can someone look over my code
and see what the problem is? I am afraid that ereg is not my strongest
point.
Also, at what point should I start writing the file out? Wouldn't there be
a permissions error if I was reading and writing at the same time?
Thanks
CDitty
$oldemail = "[EMAIL PROTECTED]";
$newemail = "[EMAIL PROTECTED]";
$user = "cditty";
$file = fopen("/path/to/the/user/file/$user.dat", "r");
if(!$file){
echo "<p>Unable to open remote file.\n";
exit;
}else{
echo "Success<br>";
}
while (!feof($file)) {
$line = fgets($file, 255);
if(eregi($oldemail, $line, $out)) {
str_replace($oldemail, $newemail, $line);
}
echo $line . "<BR>";
}
fclose($file)
On Mon, 12 Feb 2001 06:41, CDitty wrote:
> Hello all. I am trying to search through a text file on my server to
> replace the user email. I can open the file and read it, but cannot
> get it to "find" the actual string and replace it. Can someone look
> over my code and see what the problem is? I am afraid that ereg is not
> my strongest point.
>
> Also, at what point should I start writing the file out? Wouldn't
> there be a permissions error if I was reading and writing at the same
> time?
>
> Thanks
> CDitty
>
>
> $oldemail = "[EMAIL PROTECTED]";
> $newemail = "[EMAIL PROTECTED]";
> $user = "cditty";
> $file = fopen("/path/to/the/user/file/$user.dat", "r");
> if(!$file){
> echo "<p>Unable to open remote file.\n";
> exit;
> }else{
> echo "Success<br>";
> }
> while (!feof($file)) {
> $line = fgets($file, 255);
> if(eregi($oldemail, $line, $out)) {
> str_replace($oldemail, $newemail, $line);
You need to assign the output of this function to a string:
$new_line = str_replace($oldemail, $newemail, $line);
> }
>
> echo $line . "<BR>";
and then
echo $new_line . '<BR>;
> }
> fclose($file)
--
David Robley | WEBMASTER & Mail List Admin
RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
AusEinet | http://auseinet.flinders.edu.au/
Flinders University, ADELAIDE, SOUTH AUSTRALIA
That was the solution. It worked like a charm.
$cmpresult = strcmp($pick1,$pick2);
if $cmpresult == 0)
{
my code;
}
Can I also write that like the following?
if (strcmp($pick1,$pick2) == 0)
{
perform some action;
}
Will that work?
Curtis
----- Original Message -----
From: "Phil Driscoll" <[EMAIL PROTECTED]>
To: "Curtis Maurand" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 2:34 PM
Subject: Re: [PHP] comparisons
> In spite of yor best efforts here, PHP converts the string values to
numbers (because the strings look like numbers) before doing the comparison.
>
> Force a string comparison by using strcmp and everything will work fine -
remember that strcmp returns true if the strings are not equal and false if
equal.
>
> Cheers
>
> ________________ Reply Header ________________
> Subject: [PHP] comparisons
> Author: "Curtis Maurand" <[EMAIL PROTECTED]>
> Date: Sun, 11 Feb 2001 18:47:31 +0000
>
> Hello,
> I'm having a rather strange problem. I'm trying to compare two values.
"01" and "1". The variables names that they are submitted under are pick1
and pick2. i use the following code
>
> $mypick1 = strval($pick1);
> $mypick2 = strval($pick2);
>
> I then perform the following comparison:
>
> if ($mypick1 == $mypick2)
> {
> $error = 1;
> $errorstring[1] = "Your first pick and second pick are the same.";
> }
>
> However, I get the error that they are equal.
>
> If I call the comparison as foloows:
>
> if(strval($mypick1) == strval($mypick2)
> {
> $error = 1;
> $errorstring[1] = "Your first pick and second pick are the same.";
> }
>
> I still get the error. Anyone have any ideas? These two valuse mustbe
evaluated as different.
>
> Thanks in advance
> Curtis
>
>
>
Can I also write that like the following?
if (strcmp($pick1,$pick2) == 0)
{
perform some action;
}
that will work, but I prefer
Can I also write that like the following?
if (!strcmp($pick1,$pick2))
{
perform some action;
}
Cheers
Phil
> that will work, but I prefer
> Can I also write that like the following?
>
> if (!strcmp($pick1,$pick2))
> {
> perform some action;
> }
Thanks. That works for me.
Curtis
Fortunes are being made online everyday! Now is your chance to become involved with
one of the most explosive Internet industries...Internet Gaming!
But wait there is much more...LIVE Webcast Lotto and Bingo, International Sports
Betting, and Virtual Stock Trading.
We are PLAYING GAMES, HAVING FUN AND MAKING MONEY!
How are we making money? We do it with the most RED HOT compensation plan ever seen in
the industry...our NO-FLUSH Binary with incredible matching bonuses.Anyone can do
this! You could be earning everytime someone you introduce plays a game.
This is a Worldwide opportunity and it is EXPLOSIVE!
Check it out at: http://frdrt.pokeadot.com
To be removed send an email to: [EMAIL PROTECTED]
Hello. I'll keep short. Does any of you guys out there know why
"imagecreatefromjpeg" cannot open remote files ? I have php-4.0.4pl1-Win32 with
default gd lib. All other gd-things work fine, and I DO have the access rights to the
file.
"thank you for your cooperation" :)
CT
Okay, I don't have it :)
This should be recreating a 3 row array of key:value pairs with a "~"
character prepended to each key, but is only echoing _one_ key:value pair -
anyone see why?
while($array = mysql_fetch_array($result, MYSQL_ASSOC))
{
list($key, $value) = each($array);
$key_prep="~$key";
$new_array=array("$key_prep => $value");
echo $key_prep;
echo " assigned to ";
echo $value;
}
outputs:
~boy assigned to hello
where are my other two rows? :)
regards,
jaxon
>>> If $array contains the following:
>>>
>>> boy => hello
>>> girl => hi
>>> dog => bark
>>>
>>> How can I alter all the elements the same way?
>>>
>>> e.g. so that it now conatins:
>>>
>>> Xboy => Xhello
>>> Xgirl => Xhi
>>> Xdog => Xbark
>>>
>>> thanks!
>>> 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]
>>
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Get personalized email addresses from Yahoo! Mail - only $35
>> a year! http://personal.mail.yahoo.com/
>
ack.
ignore me.
not enough coffee.
the 'while' was in the wrong place.
also dropped the array() in favor of array_name[] to ensure I keep it
associative.
$array = mysql_fetch_array($result, MYSQL_ASSOC);
while (list ($key,$value) = each($array))
{
$key ="~" . $key;
$tagged_array[$key] = $value;
}
thanks!
jaxon
On 2/11/01 4:10 PM, "Jaxon" <[EMAIL PROTECTED]> wrote:
>Okay, I don't have it :)
>This should be recreating a 3 row array of key:value pairs with a "~"
>character prepended to each key, but is only echoing _one_ key:value pair -
>anyone see why?
>
>while($array = mysql_fetch_array($result, MYSQL_ASSOC))
>{
> list($key, $value) = each($array);
> $key_prep="~$key";
> $new_array=array("$key_prep => $value");
>
> echo $key_prep;
> echo " assigned to ";
> echo $value;
>}
does mysql auto_increment always has to be 1 by 1, can't I set it to go 10
by 10, or something like that?
and is there a way I can tell him to START (the first record) with a number
or do I have to put a bogus record or even alter it's value so the next
insertion is incremented from that...
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer
I'm making a script that generates test sites usíng dummy data stored in one
MySql database ("uwebsitebase")
Now, using php-scripting, I'm copying these data to a demo-database
("uwebdemo"). The structure is the same - the same tables with the same
fields. Only difference will be that the copied data should get new primary
keys which are auto-incremented. No problem there.
However, the process is tedious. I have tables that contains some 30 fields
and it's just a bore selecting all fields from one table, and then writing a
complete insert statement with all the fields except the PK.
Is there an easier way? Remember 1) It's PHP 2) It's across databases.
I have to script it, since I need the new keys on other places.
- Carsten
Hi,
Fifteen years ago I did lots of Informix SQL on Unix -- including transaction
processing -- BUT I find there isn't a lot of immediate help from that experience -- I
tried using some webmonkey examples as "basic training" for php with MySQL and got
nowhere.
I'm on Red Hat with Apache 1.3.9, PHP 4.02 and MySQL 3.22.32
Is there a good place to find typical PHP and MySQL code examples for that
configuration?
My pages are "virtual" hosted and I have access to phpMyAdmin 2.0.5 which is a menu
access by my ISP.
My php.ini is at /usr/local/lib
I've built a very small database of five fields in database "eprofitsys" in table
"employees" and would like to connect to it within a .php file. So, obviously, I am
at ground zero. Anyone want to lift me up.
Lonnie
Lonnie,
Try something like this:
create a file called db_connection_params.inc - I do this maintainability :)
(change to match your specifics)
<?
$host="localhost";
$usr="username";
$pass="password";
$database="database_name";
?>
Here is a sample page with connection/query:
<?
$sql = "SELECT * from table WHERE field = something";
include("db_connect_params.inc");
$link_id = mysql_connect($host, $usr, $pass); //setup a connection handle
mysql_select_db($database, $link_id); //select database catalog (schema,
namespace, etc)
$result = mysql_query($sql, $link_id); //return result set to php
echo $result;
?>
There are lot's of different ways to do this, check out the mysql functions:
http://www.php.net/manual/en/ref.mysql.php
HTH!
regards,
jaxon
On 2/11/01 4:40 PM, "Info" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Fifteen years ago I did lots of Informix SQL on Unix -- including transaction
> processing -- BUT I find there isn't a lot of immediate help from that
> experience -- I tried using some webmonkey examples as "basic training" for
> php with MySQL and got nowhere.
>
> I'm on Red Hat with Apache 1.3.9, PHP 4.02 and MySQL 3.22.32
>
> Is there a good place to find typical PHP and MySQL code examples for that
> configuration?
>
> My pages are "virtual" hosted and I have access to phpMyAdmin 2.0.5 which is a
> menu access by my ISP.
>
> My php.ini is at /usr/local/lib
>
> I've built a very small database of five fields in database "eprofitsys" in
> table "employees" and would like to connect to it within a .php file. So,
> obviously, I am at ground zero. Anyone want to lift me up.
>
> Lonnie
>
At 12:04 9/02/2001 -0600, Jeff Oien wrote:
>What does IDE stand for?
"Integrated Development Environment"
Usually means you have (at least ) an editor, compiler and debugger
all tightly integrated together into the one application.
-------------------------
Brian White
Step Two Designs Pty Ltd - SGML, XML & HTML Consultancy
Phone: +612-93197901
Web: http://www.steptwo.com.au/
Email: [EMAIL PROTECTED]
Hi,
I was reading mysql's manual, about transactions and all... and I didn't
find what they said about 'atomic operations' being as safe as transactions.
I couldn't figure out HOW to update 5 tables at a time ENSURING that ALL
will be update or NONE. How can this be done without transactions? With
code? I don't think so...
can anyone clear my mind here...
I have this problem... I need to update 4 tables at once, and if something
goes wrong I have to UNDO everything....
____________________________
. Christian Dechery (lemming)
. http://www.tanamesa.com.br
. Gaita-L Owner / Web Developer
look at the syntax for locking the tables.
Curtis
----- Original Message -----
From: "Christian Dechery" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 7:14 PM
Subject: [PHP] transactions
> Hi,
>
> I was reading mysql's manual, about transactions and all... and I didn't
> find what they said about 'atomic operations' being as safe as
transactions.
> I couldn't figure out HOW to update 5 tables at a time ENSURING that ALL
> will be update or NONE. How can this be done without transactions? With
> code? I don't think so...
>
> can anyone clear my mind here...
> I have this problem... I need to update 4 tables at once, and if something
> goes wrong I have to UNDO everything....
> ____________________________
> . Christian Dechery (lemming)
> . http://www.tanamesa.com.br
> . Gaita-L Owner / Web Developer
>
>
> --
> 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]
>
I've got a real weird problem happening after building 4.0.4pl1 and mysql
3.23.32 on my test machine. I previously had 4.0.1 up and running with an
earlier version of mysql - I think it was 3.22.xx - and this combination
worked fine.
I *seem* to successfully connect to my mysql database... it's not returning
any error.... but it's not returning any data either.
PHP was configed with:
./configure' '--with-apache=/root/Apachetoolbox/apache_1.3.17'
'--enable-exif' '--enable-memory-limit=yes' '--enable-track-vars'
'--with-calendar=shared' '--enable-safe-mode' '--enable-magic-quotes'
'--enable-trans-sid' '--enable-sysvsem' '--enable-sysvshm' '--enable-wddx'
'--enable-yp' '--enable-sockets' '--with-gd=/usr/local'
'--enable-gd-imgstrttf' '--with-mysql' '--with-mysql' '--with-pgsql'
'--with-ldap'
And compiled and installed fine into 1.3.17 (as far as I could see)....but
I'm not getting any results out of it.
I can force an error on the connect to the database by supplying a bad
userid - so it must be talking to mysqld fine... but I get no data out of
it, and no errors.
Here's an example of the code which is accessing the database - the database
open is handled by a separate function:
function ThePrice($prodid,$typ)
{
$inqSQL="select * from pricing where ProdCode ='" . $prodid . "' and
Price_effDate<='".date("Y m d")."' order by price_effdate desc";
echo "<!-- " . $inqSQL . " -->\n";
$result = mysql_db_query("thedbname",$inqSQL);
if (!$result) {
echo mysql_error();
exit;
}
$rtnvalue = "!?";
if ($row = mysql_fetch_array($result)) {
if ($typ=="S")
$rtnvalue = $row["ProdSetup"];
else
$rtnvalue = $row["ProdMonthly"];
}
mysql_free_result($result);
echo "<!-- product: $prodid Type: $typ Price: $rtnvalue . -->\n";
return($rtnvalue);
}
$rtnvalue shows up as the default value !?. Sometimes. Sometimes they show
up blank. It's almost like the script is dying, but not telling me it's
dying.
The database fields are setup like this:
mysql> describe pricing;
+---------------+--------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+------------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| ProdCode | varchar(50) | | | | |
| Price_effdate | date | | | 0000-00-00 | |
| ProdSetup | double(16,4) | | | 0.0000 | |
| ProdMonthly | double(16,4) | | | 0.0000 | |
+---------------+--------------+------+-----+------------+----------------+
5 rows in set (0.00 sec)
So the field names do match... and mysql will return values when I select
the rows from it directly.
Does anyone have any suggestions??? As near as I can tell mysql_fetch_array
is failing - but there is a return result otherwise I'd be getting an error
message out of this routine...
I'm really confused here.
Is my build bad? Or is this 4.0.4pl1 version a little different?
Jonathon,
I apologize for making a big deal out of this.
But to me, this is a big deal. I found your
actions very threatening. And even days later I
have actually lost sleep over it and been in a
relatively bad mood because of it.
Furthermore, below you stated I posted a URL.
That URL was to a geocities.com site. That site
has nothing to do with PHP and has nothing to do
with my local computer. In fact, that
geocities.com site only showed screenshots of
what I had been working on. Obviously, it must
have sparked your interest because you went to
work on finding out my IP Address so that you
could break into my system.
I am not a hacker. I do not try to hack and
don't know how people go about doing it. I'm a
programmer. To me, those two are very different.
A programmer is constructive. A programmer
likes to take a problem and turn it into a
solution. A programmer is creative. A
programmer has respect for other people's domains
and boundaries. A hacker is destructuve. A
hacker takes a solution and turns it into a
problem. A hacker has no respect for other
people's domain or boundaries. As you have
clearly done. You have overstepped a boundary
with me.
I did not know someone would come snooping up my
IP Address to break into my site. I did not know
it was even possible. The need to go into my
database and add your username, etc. was uncalled
for. Furthermore, you did not stop there. You
also went into my FTP site (which was empty) and
my SMTP server (which was empty) adding folders,
etc. I have full logs of your activity. You did
this day after day for almost five days, sir. I
find that uncalled for.
If you have copies of any of my files I suggest
you delete them immediately. I have Intellectual
Property rights to these files and will prosecute
you if I find out you have used them to any
means.
Again, I'm sorry for making a big deal out of
this. But it is a big deal. You have threatened
me in a very personal way.
End of Thread.
--- Jonathan Sharp <[EMAIL PROTECTED]> wrote:
> Ok, I just checked my mail and found this
> thread... to clear this up...
>
> In one of your posts you posed a url to a
> script you were working on...and I
> backed up a directory and it gave me a
> directory listing...one folder was
> /admin/ it gave another listing...then showed
> phpMyAdmin and then it gave
> your full db schema...no passwords or
> anything...i was able to insert a
> record...and a user to your mysql server...
> password is (abc123) that's all
> i did...nothing else...and i'd hardly consider
> that a hack...more of a
> "browse"
>
> Cheers,
> -Jonathan
> aka: "Codeboy the *dangerous* hacker"
>
> > -----Original Message-----
> > From: Philip Olson
> [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 08, 2001 4:24 PM
> > To: James, Yz
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP] To The Hacker: CodeBoy
> >
> >
> > > True, but none of which are applicable to
> me, as I've not
> > slandered, defamed
> > > or spoofed anything or anyone. As far as
> hacking is concerned,
> > I wouldn't
> > > know my arse from my elbow :)
> >
> > just a fyi, my post had nothing to do with
> you. or the other james (which
> > that line you're referring too had to do
> with) but rather, that of the
> > person in question ("hacker"). but anyway,
> let's let this thread die.
> > it's time.
> >
> > Philip
> >
> >
> > --
> > 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]
>
=====
=====================================
[ rswfire ]
http://rswfire.swifte.net/
http://profiles.yahoo.com/rswfire
=====================================
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
> Furthermore, below you stated I posted a URL. That URL was
> to a geocities.com site. That site has nothing to do with
> PHP and has nothing to do with my local computer. In fact,
> that geocities.com site only showed screenshots of what I
> had been working on. Obviously, it must have sparked your
> interest because you went to work on finding out my IP
> Address so that you could break into my system.
One would probably guess the URL of the site you were
working on was in the screenshots. You don't need to
"find" an IP address at that point.
Furthermore, Jonathan stated that he didn't "break into" your
system - you left phpMyAdmin *wide* open, which is frankly
asking for trouble. Imagine how much fun you'd have had if
someone with *malicious* intent had found it.
And lastly ... if he was *really* going to do anything, would
he really be so stupid as to leave his commonly-known pseudonym,
which can be (as you proved) easily traced back to himself?
I think this whole issue has been blown out of proportion enough
on the list now, and as it's no longer a PHP-related discussion
I suggest you move it to private mail.
And, try some valium for loss of sleep. :)
Jason
--
Jason Murray
[EMAIL PROTECTED]
Web Design Team, Melbourne IT
Fetch the comfy chair!
On Sun, Feb 11, 2001 at 03:51:33PM -0800, rswfire wrote:
> I am not a hacker. I do not try to hack and
> don't know how people go about doing it. I'm a
> programmer. To me, those two are very different.
> A programmer is constructive. A programmer
> likes to take a problem and turn it into a
> solution. A programmer is creative. A
> programmer has respect for other people's domains
> and boundaries. A hacker is destructuve. A
> hacker takes a solution and turns it into a
> problem. A hacker has no respect for other
> people's domain or boundaries. As you have
> clearly done. You have overstepped a boundary
> with me.
I feel compelled to repost this, because you seem to have the right
principles in mind, but the wrong term. I realize it's usually viewed
as useless nitpicking to point this out, but it seems appropriate in
this context to stress the misconception of what a hacker is. So if
you have a free moment, please do read over some of the well-written
explanations about where the word comes from, and what it stands for.
http://www.tuxedo.org/~esr/jargon/html/entry/hacker.html
http://www.tuxedo.org/~esr/jargon/html/entry/hacker-ethic.html
http://www.tuxedo.org/~esr/jargon/html/entry/cracker.html
Your description of a programmer does fit well with who a hacker really
is, so I'm sure you would appreciate what they have to say. There is,
of course, a great wealth of writing on the topic, the links above are
simply succinct definitions. For more in depth discussion, I'd suggest
browsing the bibliography included in the jargon file, which includes
excellent works, both fiction and non-fiction, relating to the subject.
http://www.tuxedo.org/~esr/jargon/html/Bibliography.html
Matt
Hello.
I need an explanation of this error message please.
This is the entire result of my upload of a jpg to a blob and I get the
open_basedir error on straight uploads also. Although they do get uploaded.
On this one I started from scratch with some 5 star directions and still flunk
out. :-<
==
Warning: open_basedir restriction in effect. File is in wrong directory. in
/usr/local/plesk/apache/vhosts/webpay.com/httpdocs/php/pic2blob/do_insert.php3
on line 10
Warning: fopen("/tmp/phpfbQ1wb","r") - Invalid argument in
/usr/local/plesk/apache/vhosts/webpay.com/httpdocs/php/pic2blob/do_insert.php3
on line 10
Warning: Unable to find file identifier 0 in
/usr/local/plesk/apache/vhosts/webpay.com/httpdocs/php/pic2blob/do_insert.php3
on line 10
Success!
You have inserted the following into your database:
tn_999.jpg, a 2937 byte file with a mime type of image/pjpeg.
==
Here is the offending line 10.
$binary_junk = addslashes(fread(fopen($img1, "r"), filesize($img1)));
Can someone tell me what's going on here. I don't seem to have a problem in
fact, but there are enough messages that say I do.
Thanks.
Floyd
--
Hi Guys,
I understand that as of version 3.24, MySQL will support subselects. But
untill then (because 3.23 is the latest stable release) I need to convert
this SQL satement into something that can be used with v3.2? - the version
just before the latest release.
$search = "SELECT count(search_table.word) as score,
search_table.qid,page_data.contents
FROM search_table,page_data
WHERE page_data.pID = search_table.qid AND search_table.word
IN($querywords)
GROUP BY search_table.qid
ORDER BY score DESC";
Does anybody have any ideas, thanks for this guys. Any help is much
appreciated.
You could try a two step query:
$querywords="CREATE TABLE temptable SELECT ... ";
$sel_querywords=mysql_query($querywords);
$search = "SELECT count(search_table.word) as score,
search_table.qid,page_data.contents
FROM search_table,page_data,temptable
WHERE page_data.pID = search_table.qid AND search_table.word =
temptable.word
GROUP BY search_table.qid
ORDER BY score DESC";
then drop temptable .
HTH
Sorin Ifrim
Scott Mebberson <[EMAIL PROTECTED]> wrote in message
967ab7$t1$[EMAIL PROTECTED]">news:967ab7$t1$[EMAIL PROTECTED]...
> Hi Guys,
>
> I understand that as of version 3.24, MySQL will support subselects. But
> untill then (because 3.23 is the latest stable release) I need to convert
> this SQL satement into something that can be used with v3.2? - the
version
> just before the latest release.
>
> $search = "SELECT count(search_table.word) as score,
> search_table.qid,page_data.contents
> FROM search_table,page_data
> WHERE page_data.pID = search_table.qid AND search_table.word
> IN($querywords)
> GROUP BY search_table.qid
> ORDER BY score DESC";
>
> Does anybody have any ideas, thanks for this guys. Any help is much
> appreciated.
>
>
>
>
> --
> 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]
>
Hi Guys,
I understand that as of version 3.24, MySQL will support subselects. But
untill then (because 3.23 is the latest stable release) I need to convert
this SQL satement into something that can be used with v3.2? - the version
just before the latest release.
$search = "SELECT count(search_table.word) as score,
search_table.qid,page_data.contents
FROM search_table,page_data
WHERE page_data.pID = search_table.qid AND search_table.word
IN($querywords)
GROUP BY search_table.qid
ORDER BY score DESC";
Does anybody have any ideas, thanks for this guys. Any help is much
appreciated.
Hi...
I am trying to install PHP 4.0.4pl1 on RedHat 6.2 with Apache 1.3.17
and MySQL 3.23.32
I already compiled MySQL and it works fine
Now I am trying to compile PHP, but the problem is that when I run
"make", nothing happends...
First, I have runned ./configure on the Apache source dir... and then
on the PHP source dir, I run ./configure --with-mysql=/usr/local/mysql
--with-apache=/usr/local/src/apache-1.3.17
then everything seems fine... I didnt get any error...
but when I run make... it says that there is nothing to do
I think that the problem is that the ./configure isn't making the
makefile
Can anybody help?
thanks!!
Pablo Pasqualino
Mar del Plata, Argentina
http://www.marplatense.com
Hi ,
Does anyone know how to change user password in NIS using PHP?
Any help is appreciated.
Pls mail to my e-mail address.
Many thanks in advance.
Thanks and regards,
Karu
> Furthermore, Jonathan stated that he didn't "break into" your
> system - you left phpMyAdmin *wide* open, which is frankly
> asking for trouble. Imagine how much fun you'd have had if
> someone with *malicious* intent had found it.
--in the physical world, if a door is left unlocked, even ajar a couple
inches, the physical act of pushing the door open so that one can enter
the door is defined as "breaking and entering".
"Harmlessly" pushing an unlocked door open, and walking in and writing on
a whiteboard "Gangstaboy was here" is just as much of a crime as
unauthorizedly logging into a machine, no matter how "wide open" it is,
even if "harm" is not done.
I don't do this to point fingers, I speak this on the part of someone
whose good friend got nabbed by police for "harmless" activity on the
internet -- and as a result spent time in the slammer.
take note
Dan
> > Furthermore, Jonathan stated that he didn't "break into" your
> > system - you left phpMyAdmin *wide* open, which is frankly
> > asking for trouble. Imagine how much fun you'd have had if
> > someone with *malicious* intent had found it.
>
> --in the physical world, if a door is left unlocked, even ajar a couple
> inches, the physical act of pushing the door open so that one can enter
> the door is defined as "breaking and entering".
--in the physical world, in the US, perhaps.
Note to everyone else: I have no idea or interest in regional differences
of this definition now, either :)
My *point* was that he should be glad that all he did was add an entry
to the database instead of deleting every damn table in there, hence
the bit about "someone with *malicious* intent".
Still, can we please leave this alone for now on the list? It's already
gone on for far too long.
Jason
--
Jason Murray
[EMAIL PROTECTED]
Web Design Team, Melbourne IT
Fetch the comfy chair!
Actually IIRC pushing open a door that's ajar is not breaking and
entering, but trespass :)
Gfunk - http://www.gfunk007.com/
I sense much beer in you. Beer leads to intoxication, intoxication to
hangovers, and hangovers to... suffering.
----- Original Message -----
From: "Jason Murray" <[EMAIL PROTECTED]>
To: "'Dan Harrington'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 1:44 PM
Subject: RE: [PHP] "wide open"
> > > Furthermore, Jonathan stated that he didn't "break into" your
> > > system - you left phpMyAdmin *wide* open, which is frankly
> > > asking for trouble. Imagine how much fun you'd have had if
> > > someone with *malicious* intent had found it.
> >
> > --in the physical world, if a door is left unlocked, even ajar a couple
> > inches, the physical act of pushing the door open so that one can enter
> > the door is defined as "breaking and entering".
>
> --in the physical world, in the US, perhaps.
>
> Note to everyone else: I have no idea or interest in regional differences
> of this definition now, either :)
>
> My *point* was that he should be glad that all he did was add an entry
> to the database instead of deleting every damn table in there, hence
> the bit about "someone with *malicious* intent".
>
> Still, can we please leave this alone for now on the list? It's already
> gone on for far too long.
>
> Jason
>
> --
> Jason Murray
> [EMAIL PROTECTED]
> Web Design Team, Melbourne IT
> Fetch the comfy chair!
>
> --
> 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]
>
unsubscribe php-general
my code...
WRITE TO FILE:
if ($item_file = fopen("$thisdir/item.dat", "w"))
{
fwrite($item_file, "$new_item\n$asin\n$description\namazon");
fclose($item_file);
echo "<P CLASS=Normal>$new_item created</P>";
}
READ FROM FILE:
$item_file = fopen("$thisdir/item.dat", "r");
fscanf($item_file, "%s\n%s\n%s\n%s", $display, $asin, $description,
$link);
fclose($item_file);
PROBLEM:
$display comes out correct, but $asin, $descrition and $link are always
empty
SAMPLE FILE:
MyItem
11517
ThisIsMyDecriptionWithoutSpaces
amazon
- John Vanderbeck
- Admin, GameDesign
Hello Niel,
On 08-Feb-01 10:12:15, you wrote:
>I'm looking for a way to have a "next 10 records" "previous 10 records" type
>of sinario, extracting records from a database. Now the only problem is that
>I want to do it in Interbase. I know mysql has a seek option and a method of
>only returning a segment of records but I'm having no luck in interbase..
You may want to try this class that does precisely what you need with Interbase
and any other database supported by Metabase:
Query result table display class
http://phpclasses.UpperDesign.com/browse.html/package/130
Metabase
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--
hi
I realized that there are 2 ways to save data. Using mySQL or a textfile.
Which do you think is better? i like using myysql instead a textfile cuz
it's faster and it's securier.
Thank You Frank it worked but the FDF Toolkit seems to have a problem with
4.0.4p11 so I had to roll back to 4.0.3p11 and eveything seems to be running
ok.
Kurt
<Tim Frank [EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Kurt,
I fought with this same problem for about an hour today. For me there
was something changed when the file was downloaded that made it
corrupt... I think it was a LF to a CR + LF or something. I tried Dling
the file with Lynx on a linux machine and it was still corrupt. My fix
was to DL the file on a windows machine and then FTP the file to my unix
box in ASCII mode (NOT BINARY). I don't know why or what was causing the
problem, but that is how I fixed it.
Now I'm trying to install it ;)
Hope that helps
Tim Frank
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 05/02/01, 8:10:18 AM, [EMAIL PROTECTED] ("Kurt R. Hoehn") wrote
regarding [PHP] FDF Toolkit uncompression error:
> Hello,
> I've downloaded the FDF toolkit from adobe (fdftk4_05_C.tar.Z) and it
> doesn't uncompress. I've noticed that other people are using it. Has
> anyone else experianced this same problem and if so what was your work
> around.
> Thank You
> Kurt
> --
> 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]
is there a pre-defined variable that return present php file name...
for example...
url : www.domain.com/mypage.php
$var == "mypage";
????
thanks
try using
$PHP_SELF
and
$REQUEST_URI
regards
Ankur Verma
HCL Technologies
A1CD, Sec -16
Noida, UP
India
----- Original Message -----
From: "John LYC" <[EMAIL PROTECTED]>
To: "PHP List" <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 10:52 AM
Subject: [PHP] checking for presnet file name
> is there a pre-defined variable that return present php file name...
>
> for example...
>
> url : www.domain.com/mypage.php
>
> $var == "mypage";
>
> ????
>
> 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]
This may have crossed the list a bazillion times, but I couldn't really find
anything appropriate in the archives... maybe I just didn't look hard enough.
In a MySQL app, I have the usual row of paging links at the bottom of the page
and need to pass to the next iteration more variables than I can comfortably
url-encode in the hyperlink. If all these paging links were submit buttons I
could pass anything I wanted in hidden form fields, but since they're
hyperlinks I don't seem to have that option.
Is there a way to selectively preserve variables between iterations? Something
like variables that are global to PHP, as opposed to being global within the
script?
try using session variables.
take a look at phplib if you are using PHP3 or
http://www.php.net/manual/en/ref.session.php
if you are using PHP4
hope that helps
Ankur Verma
HCL Technologies
A1CD, Sec -16
Noida, UP
India
----- Original Message -----
From: "Chuck Mayo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 12, 2001 10:53 AM
Subject: [PHP] Preserve variables between page loads?
> This may have crossed the list a bazillion times, but I couldn't really
find
> anything appropriate in the archives... maybe I just didn't look hard
enough.
>
> In a MySQL app, I have the usual row of paging links at the bottom of the
page
> and need to pass to the next iteration more variables than I can
comfortably
> url-encode in the hyperlink. If all these paging links were submit buttons
I
> could pass anything I wanted in hidden form fields, but since they're
> hyperlinks I don't seem to have that option.
>
> Is there a way to selectively preserve variables between iterations?
Something
> like variables that are global to PHP, as opposed to being global within
the
> script?
>
>
> --
> 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]
Hi PHPers!
how can I reference a result set by array index numbers???
this $sql="select field from table where id_field = 1";
would return a result like this:
field
-----------
first
second
third
from this table
id_field field
--------|--------
1 first
1 second
1 third
2 fourth
2 fifth
how can I do something like this:
$array=mysql_db_query($database, $sql, $link_id);
echo array[0]; //I want this to print "first"
echo array[1]; //I want this to print "second"
I know mysql_fetch_array pulls a ROW into an array, but in this case the row
is only one item wide, so I essentially want column results in an indexed
array.
TIA!
andrew
try using "\r\n" instead of a simple "\n".
hope that helps
Ankur Verma
HCL Technologies
A1CD, Sec -16
Noida, UP
India
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 6:51 AM
Subject: [PHP] newline processing problem?
>
> I have some code which generates a large string to be used by the mail()
> function. At the same point in the string each time, PHP stops processing
> "\n" correctly and instead of a newline outputs nothing, so the text
starts to
> get run together.. but it doesn't seem to happen on every "\n". Has
anyone
> else run into this problem? It used to work correctly but I made a few
> changes to portions of the code that were totally uninvolved, and it
started
> behaving this way. Unfortunately, I didn't notice the problem until I'd
made
> a number of small changes to unrelated things and didn't remember what
they
> were.
>
>
>
> Gordon Morehouse
> [EMAIL PROTECTED]
> www.evernex.com
>
> --
> 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]
Hi guys,
I need to write a regular expression search that can search through a block
of HTML code and find anything similar to these:
<IMG alt="" border=0 hspace=10 src="" vspace=20>
<IMG align=baseline alt="" border=0 hspace=0 src="">
<IMG align=right alt="" border=1 hspace=2 src="" vspace=>
<IMG align=textTop alt="" border=0 hspace=0 src="">
<IMG align=baseline alt="" border=0 hspace=0 src="">
<IMG alt="" border=0 hspace=0 src="">
<IMG alt="" border=2 hspace=0 src="">
<IMG alt="" border=2 hspace=0 src="" style="" vspace=2>
<IMG align=left alt="" border=2 hspace=0 src="" style="" vspace=2>
And return what I want in an array.
I need the search or piece of code to be able to differ as to which one it
is using, ie/ with align or without align. I need all of the values returned
in an array.
Does anybody think that they could help me out with this one. I know that it
is pretty tricky but I am not that good with reg exp and I need some help.
Anything is very much appreciated. Thanks Guys!!
Scott Mebberson
Fatal error: input in flex scanner failed in /var/www/html/gcdb/lang on
line 1
Using gcdb version 1.1.4 (see: http://sourceforge.net/projects/gcdb/)
I get the error listed above... I believe the error is arising from this
code (from gcdb.php):
if(!(isset($sess_lang))) {
$db = getDBConnection();
$result = mysql_query("select * from Configuration");
$config_row = mysql_fetch_array($result);
require("lang/".$config_row["Language"]);
} else {
require("lang/".$sess_lang);
}
I searched the buglist for php and found a few references to this error
but nothing I'd call definitive... I also found a reference in the PHP
documentation which says this error occurs when a require points at a
directory instead of a file...
I'm just learning php but the code sample above appears to me to be
pointing at a directory but I'm not sure... I'm also too tired to
continue tonight... if anybody has seen this and knows what it is I'd
appreciate a hand...
Thanx!
--
Chuck Mead, chuck -AT- moongroup.com, Owner, MoonGroup.com
(Note: html formatted email sent to me is filtered & deleted unread)
GnuPG Public Key Available: http://wwwkeys.us.pgp.net
