[PHP] MySQL PHP issue?
OK, I have check all the mysql doc and php docs on using exists in the query, but it seems I still can not get the query to work. Here it is: SELECT * FROM icisp.account WHERE id in (select oldaccountID from BillMax.account) Or Using sELECT * FROM icisp.account WHERE id exists(select oldaccountID from BillMax.account) Anyone have any idea what I'm doing wrong? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL PHP issue?
It is version 3.23.56 -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:44 PM To: php-general@lists.php.net Subject: Re: [PHP] MySQL PHP issue? Jay Blanchard wrote: > Asking a MySQL question on a PHP list? *slaps knee!* I bet you think you're funny. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL PHP issue?
SH^*&^t Thanks guys. Figured something like that. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:53 PM To: Dustin Wish; php-general@lists.php.net Subject: RE: [PHP] MySQL PHP issue? [snip] It is version 3.23.56 [/snip] Sub-queries are not supported in that version of MySQL. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] number format?
I have a number like -56.98 I need to convert it to -5698. I tried --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php works in IE not Firefox?
Anyone run across an issue where a php script works in IE and not Firefox? Christianboards.org is a PHP nuke site running on a Enism linux box that is having this issue. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005
RE: [PHP] php works in IE not Firefox?
Fixed it. Corrupted code in php nuke on FTP. Weird. And I understand that PHP is a language that produces HTML code. Not sure if there was an issue with Firefox and PHP based pages. -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 3:00 PM To: Dustin Wish Cc: php-general@lists.php.net Subject: Re: [PHP] php works in IE not Firefox? PHP does not work in Firefox. It doesn't work in IE either, or any browser for that matter. It works "in" Apache and can even work on the command line. PHP can generate web pages. The resulting web code may not work right, but that's not php's fault. That's the fault of the developer who wrote the php code that generates web pages that don't work. You could easily take php nuke and customize it so it ends up not working in FireFox. It could be something as simple as changing the style sheets, and probably is. Whoever is customizing php nuke should be aware of the differences between browsers. CSS is a pretty thorny area in IE. After all, it hasn't been updated in years. On May 13, 2005, at 2:12 PM, Dustin Wish wrote: > Anyone run across an issue where a php script works in IE and not > Firefox? > Christianboards.org is a PHP nuke site running on a Enism linux box > that is > having this issue. > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 > > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] stripping content and parsing returned pages?
I have been looking everywhere for any tips or tutorials on, posting to separate websites and parsing the return values for input into a mysql db. I understand the parsing or stripping of html content from a page, but not how to post to a form on a different site and once the values are returned parse and redirect. I have read alittle about using CURL to perform some of this, but no real help there. I need to post to a login script, then once the page is processed, I will parsed the returned page for the data after logined. any help please? "In expanding the field of knowledge, we but increase the horizon of ignorance." Henry Miller (1891-1980); US author. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.614 / Virus Database: 393 - Release Date: 3/5/2004
RE: [PHP] Secret Codes in Spam and PHP
We should make that the new X-files movie. "When good mail goes SPAM!" Dustin Wish System Engineer & Programmer INDCO Networks Pres. OSSRI Pres. WTA Arkansas "Do not go where the path may lead, go instead where there is no path and leave a trail." Ralph Waldo Emerson (1803-1882) *** -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 5:17 PM To: [EMAIL PROTECTED] Cc: Kristopher Spencer-Yates; [EMAIL PROTECTED] Subject: Re: [PHP] Secret Codes in Spam and PHP -- Original message from Kristopher Spencer-Yates : -- > As many of you may have noticed, A friend and I have noticed the odd > text at the bottom of spam. My friend once stated "What if this is some > secret code.. they send it to everyone to hide that it is code.. but the > person it is intended for knows how to decipher?" Hmm.. interesting. Now that they know that we know, we're all in danger. Be on the look out for assassins. -- 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] csv inssue
I was curious if anyone could help me. I need to write an insert to take data from a csv file to put into a MySQL db. I am not sure know to parse out 5 items of the string at a time i.e. (1,2,3,4,5,1,2,3,4,5,1...etc) so that the five putted items get inserted everytime. Like: "insert into products (item,price,rate,name,desc) values (1,2,3,4,5)" Then on to the next one and so forth. I am already parsing the file, but not sure if it needs to go into an array or set to vars then done in a loop. Please help! Here is the script so far: Database Insert Script Line Item $counter: $color\n"; } ?> Dustin Wish System Engineer & Programmer INDCO Networks Pres. OSSRI Pres. WTA Arkansas "Do not go where the path may lead, go instead where there is no path and leave a trail." Ralph Waldo Emerson (1803-1882) *** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] csv inssue
Go it fixed. I used the same code to a degree, but use the array items as
needed by just accessing $val[1], $val[2] etc. so if I need a custom select
with in the loop I access the array
Insert into mytable (item,product) values ($val[1],$val[2]);
Dustin Wish
System Engineer & Programmer
INDCO Networks
Pres. OSSRI
Pres. WTA Arkansas
"Do not go where the path may lead, go instead
where there is no path and leave a trail."
Ralph Waldo Emerson (1803-1882)
***
-Original Message-
From: Jim Grill [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 10:32 AM
To: [EMAIL PROTECTED]
Cc: PHP General List
Subject: Re: [PHP] csv inssue
> Well it was very close the only issue is the trailing comma on the
inserts.
> See below:
>
> INSERT INTO mytable (one,two,three,four,five) VALUES(14,Radial H714
> 155/80r13s,26,
> All Season
> S Rated
> UTQG: 380/A/B
> WSW: White Sidewall
>
> 4 groove version of all-season performance radial. The unique tread
pattern
> disperses water to the sides of the tire while the extra-wide grooves
> enhance wet handling and braking.,H714_4g.jpg),
>
> INSERT INTO mytable (one,two,three,four,five) VALUES(14,Radial H714
> 155/80r13s,26,
> All Season
> S Rated
> UTQG: 380/A/B
> WSW: White Sidewall
>
> 4 groove version of all-season performance radial. The unique tread
pattern
> disperses water to the sides of the tire while the extra-wide grooves
> enhance wet handling and
>
braking.,H714_4g.jpg),(www.hankooktireusa.com/products_view_info.asp?Item_ID
> =21&CatID=4,25 14,Radial H714 175/65r14s,37,
> All Season
> S Rated
> UTQG: 380/A/B
> WSW: White Sidewall
>
> 4 groove version of all-season performance radial. The unique tread
pattern
> disperses water to the sides of the tire while the extra-wide grooves
> enhance wet handling and braking.),
Damn... You remind me that I need to rotate my tires this weekend. :-)
You did something wrong. :-) There should only ever be one single query
that should look like:
$query = 'INSERT INTO mytable (one,two,three,four,five) VALUES
("blah","blah","blah","blah","blah"),
("blah","blah","blah","blah","blah"),
("blah","blah","blah","blah","blah"),
("blah","blah","blah","blah","blah"),
("blah","blah","blah","blah","blah")';
Also, I did forget the quotes on the values. This will fix that: $query .=
'("'.implode('","',$vals).'"),';
There is a line that gets rid of the the trailing comma:
/*kill the last comma*/
$query = substr($query, 0, -1);
Take another look and then post some code if you still have trouble.
Jim Grill
--
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] Multiple denial of service vulnerabilities in PHP
- Multiple denial of service vulnerabilities in PHP - Oxygen3 24h-365d, by Panda Software (http://www.pandasoftware.com) MADRID, April 7, 2005 - iDefense has reported multiple denial of service vulnerabilities in the PHP scripting language, which could allow an attacker to crash the system. The problem lies in how the routines php_handle_iff() and php_handle_jpeg() handle the PHP function getimagesize(), which is used to determine the size and dimensions of a large number of image formats, including GIF, JPG, PNG, TIFF, etc. The first flaw lies in the php_handle_iff() function, defined in ext/standard/image.c, and could allow a remote attacker to use up all of the CPU resources, resulting in a denial of service. The second vulnerability is due to insufficient validation of JPEG file headers in the php_handle_jpeg() function, also defined in ext/standard/image.c. This format contains a length field that could be manipulated to cause an infinite loop on copying file data to memory. These vulnerabilities could be exploited by unauthenticated remote users to consume 100 percent of the CPU resources on vulnerable systems. To do this, an attacker can supply a malicious image to the getimagesize() PHP routine. The getimagesize() PHP routine is frequently used when handling user-supplied image uploads, which increases the probability of a success attack. The original security advisory about these vulnerabilities is available at: http://www.idefense.com/application/poi/display?id=222&type=vulnerabilities&; flashstatus=true -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PDF generator?
I have a PDF that I need to insert values into from a web form. I would like to input directly into the PDF from the web. Any pointers to the right direction? Dustin Wish System Engineer & Programmer INDCO Networks Pres. OSSRI Pres. WTA Arkansas "Do not go where the path may lead, go instead where there is no path and leave a trail." Ralph Waldo Emerson (1803-1882) ***
[PHP] Behind the scenes coding?
I have been looking everywhere for any tips or tutorials on posting to separate websites and parsing the return values for input into a mysql db. I understand parsing html pages, but not how to post to a form on a different site and once the values are returned parse and redirect. I have read alittle about using CURL to perform some of this, but no real help there. I need to post to a login script, then once the page is processed, I will parsed the returned page for the data. any help please? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] behind the scenes coding?
I have been looking everywhere for any tips or tutorials on posting to separate websites and parsing the return values for input into a mysql db. I understand parsing html pages, but not how to post to a form on a different site and once the values are returned parse and redirect. I have read alittle about using CURL to perform some of this, but no real help there. I need to post to a login script, then once the page is processed, I will parsed the returned page for the data. any help please?
[PHP] loking for a item in string?
I am opening a file and then have to look for a value inside the string. Is there an easy way to do this? I need the value in this string for the var djLast = '45.11';
RE: [PHP] Re: php editor or php IDE for linux with autocompletion
Speaking of IDE's, does anyone know if Codeweavers has ported Dreamweaver to Linux? It is my favorite IDE for programming web apps. -Original Message- From: M. Sokolewicz [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 9:38 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: php editor or php IDE for linux with autocompletion [EMAIL PROTECTED] wrote: > Hi. > > We use linux as default development system. > > Does anyboy know about a linux based php editor with autocompletion? Must > be open source free software (free as in speech, not beer). > > We like quanta and kate, but there is no autocompletion. > > Does anyone know about a php IDE? > > I got a look at the php editors page, but the things I found there did not > match the requirements. > > Thanks in advance. I prefer vim, which does have auto-completion, as an add-on. But I wouldn't call it an IDE... =/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
