php-windows Digest 14 Feb 2001 00:56:46 -0000 Issue 444
Topics (messages 5542 through 5559):
Re: assigning variable names on the fly, backed myself in to a corner
5542 by: Darvin Andrioli
5544 by: Asendorf, John
5556 by: Ignatius Teo
5557 by: Ignatius Teo
Re: How to save a file to a blob field?
5543 by: Winston Valenzuela
Re: IIS Manipulation
5545 by: Richard
5546 by: David Harrison
pdflib put a image to a pdf file
5547 by: Glenn Lindgren
mysql and phpmyadmin
5548 by: Manuela
5549 by: Tom Mathews
5550 by: Ben Cairns
5551 by: Phil Driscoll
PHP + COM
5552 by: Dario Carnelutti
5558 by: Alain Samoun
INSERT into MSSQL Server
5553 by: Conover, Ryan
5559 by: Frank M. Kromann
Re: [PHP] INSERT into MSSQL Server
5554 by: Peter Houchin
5555 by: Michael McGlothlin
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]
----------------------------------------------------------------------
Ignatius wrote:
> try assigning it to another variable first:
> for ....
> $tag = "$tag_num$i";
> $type = "tag_type$i";
> $sql = .... VALUES (..., $tag, $type....);
The last statement must be:
$sql = .... VALUES (..., $$tag, $$type....);
so you get the value of the variable named tag_type$i, otherwise yo get only the
string "tag_type value of $i"
Darvin
> -----Original Message-----
> From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 13 February 2001 07:58
> To: Php-Windows (E-mail)
> Subject: [PHP-WIN] assigning variable names on the fly,
> backed myself in
> to a corner
>
>
> I've written a little script that makes a form using a simple
> for loop:
>
> if ( $num_reg != "" ) { //we're doing regulars
>
> for ( $i = 1 ; $i <= $num_reg ; $i++ ) {
> echo "<tr><td>A<input type=\"hidden\"
> name=\"tag_type${i}\"
> value=\"A\"></td>";
> echo "<td><input type=\"text\"
> name=\"tag_num${i}\"></td>";
> echo "<td><input type=\"text\" name=\"tag_cost${i}\"
> value=\"\"></td>";
> echo "<td><input type=\"text\"
> name=\"tag_late${i}\"></td></tr>\n";
> }
>
> $tag_count = $num_reg;
>
> }
>
> Now what I have is a number of variables that look something like this
>
> $tag_type1, $tag_num1, $tag_cost1, $tag_late1, $tag_type2, $tag_num2,
> $tag_cost2, $tag_late2, etcetera... up to any number of tags...
>
> now I'm trying to write a little for loop that drops this
> information into a
> database after the POST:
>
> for ( $i=1 ; $i <= $tag_count ; $i++ ) { //tag_count came
> from the post
> (dl_post_3.php)
>
> $sql = "INSERT into cfull2.tbl_dl_tags (TAGID_NUM,
> CUSTID_NUM, TAG_NO,
> TAG_YEAR, TYPE_CODE, COST, TYPE) VALUES ($CUSTID_NUM,
> $tag_num$i, $tag_year,
> '$tag_type$i' , $tag_cost$i )";
>
> $stmt = OCIParse ( $connection , $sql );
>
> OCIExecute ( $stmt , OCI_DEFAULT );
> OCICommit( $connection );
> OCIFreeStatement ( $stmt );
> }
>
>
> This obviously doesn't work and I'm not really sure what to
> do now. Is this
> a case of variable variable names? I don't quite get those either :)
>
> Thanks in advance all,
>
> John
>
>
> ---------------------
> John Asendorf - [EMAIL PROTECTED]
> Web Applications Developer
> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> Licking County, Ohio, USA
> 740-349-3631
> Ipsa scientia potestas est
>
>
> --
> PHP Windows 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]
>
That's the ticket. Thanks a million!
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Ipsa scientia potestas est
> -----Original Message-----
> From: Darvin Andrioli [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 13, 2001 6:52 AM
> To: 'Ignatius Teo'; 'Asendorf, John'; 'Php-Windows (E-mail)'
> Subject: RE: [PHP-WIN] assigning variable names on the fly, backed
> myself in to a corner
>
>
> Ignatius wrote:
>
> > try assigning it to another variable first:
> > for ....
> > $tag = "$tag_num$i";
> > $type = "tag_type$i";
> > $sql = .... VALUES (..., $tag, $type....);
>
> The last statement must be:
> $sql = .... VALUES (..., $$tag, $$type....);
>
> so you get the value of the variable named tag_type$i,
> otherwise yo get only the string "tag_type value of $i"
>
> Darvin
>
>
> > -----Original Message-----
> > From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 13 February 2001 07:58
> > To: Php-Windows (E-mail)
> > Subject: [PHP-WIN] assigning variable names on the fly,
> > backed myself in
> > to a corner
> >
> >
> > I've written a little script that makes a form using a simple
> > for loop:
> >
> > if ( $num_reg != "" ) { //we're doing regulars
> >
> > for ( $i = 1 ; $i <= $num_reg ; $i++ ) {
> > echo "<tr><td>A<input type=\"hidden\"
> > name=\"tag_type${i}\"
> > value=\"A\"></td>";
> > echo "<td><input type=\"text\"
> > name=\"tag_num${i}\"></td>";
> > echo "<td><input type=\"text\" name=\"tag_cost${i}\"
> > value=\"\"></td>";
> > echo "<td><input type=\"text\"
> > name=\"tag_late${i}\"></td></tr>\n";
> > }
> >
> > $tag_count = $num_reg;
> >
> > }
> >
> > Now what I have is a number of variables that look
> something like this
> >
> > $tag_type1, $tag_num1, $tag_cost1, $tag_late1, $tag_type2,
> $tag_num2,
> > $tag_cost2, $tag_late2, etcetera... up to any number of tags...
> >
> > now I'm trying to write a little for loop that drops this
> > information into a
> > database after the POST:
> >
> > for ( $i=1 ; $i <= $tag_count ; $i++ ) { //tag_count came
> > from the post
> > (dl_post_3.php)
> >
> > $sql = "INSERT into cfull2.tbl_dl_tags (TAGID_NUM,
> > CUSTID_NUM, TAG_NO,
> > TAG_YEAR, TYPE_CODE, COST, TYPE) VALUES ($CUSTID_NUM,
> > $tag_num$i, $tag_year,
> > '$tag_type$i' , $tag_cost$i )";
> >
> > $stmt = OCIParse ( $connection , $sql );
> >
> > OCIExecute ( $stmt , OCI_DEFAULT );
> > OCICommit( $connection );
> > OCIFreeStatement ( $stmt );
> > }
> >
> >
> > This obviously doesn't work and I'm not really sure what to
> > do now. Is this
> > a case of variable variable names? I don't quite get those
> either :)
> >
> > Thanks in advance all,
> >
> > John
> >
> >
> > ---------------------
> > John Asendorf - [EMAIL PROTECTED]
> > Web Applications Developer
> > http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> > Licking County, Ohio, USA
> > 740-349-3631
> > Ipsa scientia potestas est
> >
> >
> > --
> > PHP Windows 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]
> >
>
T29wcy4ueWVwLiBUaGFua3MgZm9yIHBvaW50aW5nIHRoYXQgb3V0Li4udGhhdCdzIHdoYXQgSSBt
ZWFudC4NCg0KSWduYXRpdXMNCg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9t
OiBEYXJ2aW4gQW5kcmlvbGkgW21haWx0bzpkYXJ2aW4uYW5kcmlvbGlAY2FyaWNlc2UuaXRdDQo+
IFNlbnQ6IFR1ZXNkYXksIDEzIEZlYnJ1YXJ5IDIwMDEgMjI6NTINCj4gVG86ICdJZ25hdGl1cyBU
ZW8nOyAnQXNlbmRvcmYsIEpvaG4nOyAnUGhwLVdpbmRvd3MgKEUtbWFpbCknDQo+IFN1YmplY3Q6
IFJFOiBbUEhQLVdJTl0gYXNzaWduaW5nIHZhcmlhYmxlIG5hbWVzIG9uIHRoZSBmbHksIGJhY2tl
ZA0KPiBteXNlbGYgaW4gdG8gYSBjb3JuZXINCj4gDQo+IA0KPiBJZ25hdGl1cyB3cm90ZToNCj4g
DQo+ID4gdHJ5IGFzc2lnbmluZyBpdCB0byBhbm90aGVyIHZhcmlhYmxlIGZpcnN0Og0KPiA+IGZv
ciAuLi4uDQo+ID4JJHRhZyA9ICIkdGFnX251bSRpIjsNCj4gPgkkdHlwZSA9ICJ0YWdfdHlwZSRp
IjsNCj4gPgkkc3FsID0gLi4uLiBWQUxVRVMgKC4uLiwgJHRhZywgJHR5cGUuLi4uKTsNCj4gDQo+
IFRoZSBsYXN0IHN0YXRlbWVudCBtdXN0IGJlOg0KPiAkc3FsID0gLi4uLiBWQUxVRVMgKC4uLiwg
JCR0YWcsICQkdHlwZS4uLi4pOw0KPiANCj4gc28geW91IGdldCB0aGUgdmFsdWUgb2YgdGhlIHZh
cmlhYmxlIG5hbWVkIHRhZ190eXBlJGksIA0KPiBvdGhlcndpc2UgeW8gZ2V0IG9ubHkgdGhlIHN0
cmluZyAidGFnX3R5cGUgdmFsdWUgb2YgJGkiDQo+IA0KPiBEYXJ2aW4NCj4gDQo+IA0KPiA+IC0t
LS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+ID4gRnJvbTogQXNlbmRvcmYsIEpvaG4gW21haWx0
bzpKQXNlbmRvcmZAbGNvdW50eS5jb21dDQo+ID4gU2VudDogVHVlc2RheSwgMTMgRmVicnVhcnkg
MjAwMSAwNzo1OA0KPiA+IFRvOiBQaHAtV2luZG93cyAoRS1tYWlsKQ0KPiA+IFN1YmplY3Q6IFtQ
SFAtV0lOXSBhc3NpZ25pbmcgdmFyaWFibGUgbmFtZXMgb24gdGhlIGZseSwgDQo+ID4gYmFja2Vk
IG15c2VsZiBpbg0KPiA+IHRvIGEgY29ybmVyDQo+ID4gDQo+ID4gDQo+ID4gSSd2ZSB3cml0dGVu
IGEgbGl0dGxlIHNjcmlwdCB0aGF0IG1ha2VzIGEgZm9ybSB1c2luZyBhIHNpbXBsZSANCj4gPiBm
b3IgbG9vcDoNCj4gPiANCj4gPiBpZiAoICRudW1fcmVnICE9ICIiICkgICB7ICAgICAgICAgLy93
ZSdyZSBkb2luZyByZWd1bGFycw0KPiA+IA0KPiA+IAlmb3IgKCAkaSA9IDEgOyAkaSA8PSAkbnVt
X3JlZyA7ICRpKysgKSAgew0KPiA+IAkJZWNobyAiPHRyPjx0ZD5BPGlucHV0IHR5cGU9XCJoaWRk
ZW5cIiANCj4gPiBuYW1lPVwidGFnX3R5cGUke2l9XCINCj4gPiB2YWx1ZT1cIkFcIj48L3RkPiI7
DQo+ID4gCQllY2hvICI8dGQ+PGlucHV0IHR5cGU9XCJ0ZXh0XCIgDQo+ID4gbmFtZT1cInRhZ19u
dW0ke2l9XCI+PC90ZD4iOw0KPiA+IAkJZWNobyAiPHRkPjxpbnB1dCB0eXBlPVwidGV4dFwiIG5h
bWU9XCJ0YWdfY29zdCR7aX1cIg0KPiA+IHZhbHVlPVwiXCI+PC90ZD4iOw0KPiA+IAkJZWNobyAi
PHRkPjxpbnB1dCB0eXBlPVwidGV4dFwiDQo+ID4gbmFtZT1cInRhZ19sYXRlJHtpfVwiPjwvdGQ+
PC90cj5cbiI7DQo+ID4gCX0JDQo+ID4gCQ0KPiA+IAkkdGFnX2NvdW50ID0gJG51bV9yZWc7DQo+
ID4gCQ0KPiA+IH0NCj4gPiANCj4gPiBOb3cgd2hhdCBJIGhhdmUgaXMgYSBudW1iZXIgb2YgdmFy
aWFibGVzIHRoYXQgbG9vayANCj4gc29tZXRoaW5nIGxpa2UgdGhpcw0KPiA+IA0KPiA+ICR0YWdf
dHlwZTEsICR0YWdfbnVtMSwgJHRhZ19jb3N0MSwgJHRhZ19sYXRlMSwgJHRhZ190eXBlMiwgDQo+
ICR0YWdfbnVtMiwNCj4gPiAkdGFnX2Nvc3QyLCAkdGFnX2xhdGUyLCBldGNldGVyYS4uLiB1cCB0
byBhbnkgbnVtYmVyIG9mIHRhZ3MuLi4NCj4gPiANCj4gPiBub3cgSSdtIHRyeWluZyB0byB3cml0
ZSBhIGxpdHRsZSBmb3IgbG9vcCB0aGF0IGRyb3BzIHRoaXMgDQo+ID4gaW5mb3JtYXRpb24gaW50
byBhDQo+ID4gZGF0YWJhc2UgYWZ0ZXIgdGhlIFBPU1Q6DQo+ID4gDQo+ID4gZm9yICggJGk9MSA7
ICRpIDw9ICR0YWdfY291bnQgOyAkaSsrICkgeyAgLy90YWdfY291bnQgY2FtZSANCj4gPiBmcm9t
IHRoZSBwb3N0DQo+ID4gKGRsX3Bvc3RfMy5waHApDQo+ID4gDQo+ID4gICAgICAkc3FsID0gIklO
U0VSVCBpbnRvIGNmdWxsMi50YmxfZGxfdGFncyAoVEFHSURfTlVNLCANCj4gPiBDVVNUSURfTlVN
LCBUQUdfTk8sDQo+ID4gVEFHX1lFQVIsIFRZUEVfQ09ERSwgQ09TVCwgVFlQRSkgVkFMVUVTICgk
Q1VTVElEX05VTSwgDQo+ID4gJHRhZ19udW0kaSwgJHRhZ195ZWFyLA0KPiA+ICckdGFnX3R5cGUk
aScgLCAkdGFnX2Nvc3QkaSApIjsNCj4gPiANCj4gPiAgICAgICRzdG10ID0gT0NJUGFyc2UgKCAk
Y29ubmVjdGlvbiAsICRzcWwgKTsNCj4gPiANCj4gPiAgICAgIE9DSUV4ZWN1dGUgKCAkc3RtdCAs
IE9DSV9ERUZBVUxUICk7DQo+ID4gICAgICBPQ0lDb21taXQoICRjb25uZWN0aW9uICk7DQo+ID4g
ICAgICBPQ0lGcmVlU3RhdGVtZW50ICggJHN0bXQgKTsNCj4gPiB9DQo+ID4gDQo+ID4gDQo+ID4g
VGhpcyBvYnZpb3VzbHkgZG9lc24ndCB3b3JrIGFuZCBJJ20gbm90IHJlYWxseSBzdXJlIHdoYXQg
dG8gDQo+ID4gZG8gbm93LiAgSXMgdGhpcw0KPiA+IGEgY2FzZSBvZiB2YXJpYWJsZSB2YXJpYWJs
ZSBuYW1lcz8gIEkgZG9uJ3QgcXVpdGUgZ2V0IHRob3NlIA0KPiBlaXRoZXIgIDopDQo+ID4gDQo+
ID4gVGhhbmtzIGluIGFkdmFuY2UgYWxsLA0KPiA+IA0KPiA+IEpvaG4NCj4gPiANCj4gPiANCj4g
PiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gPiBKb2huIEFzZW5kb3JmIC0gamFzZW5kb3JmQGxj
b3VudHkuY29tDQo+ID4gV2ViIEFwcGxpY2F0aW9ucyBEZXZlbG9wZXINCj4gPiBodHRwOi8vd3d3
Lmxjb3VudHkuY29tIC0gTkVXIEZFQVRVUkVTIEFEREVEIERBSUxZIQ0KPiA+IExpY2tpbmcgQ291
bnR5LCBPaGlvLCBVU0ENCj4gPiA3NDAtMzQ5LTM2MzENCj4gPiBJcHNhIHNjaWVudGlhIHBvdGVz
dGFzIGVzdA0KPiA+IA0KPiA+IA0KPiA+IC0tIA0KPiA+IFBIUCBXaW5kb3dzIE1haWxpbmcgTGlz
dCAoaHR0cDovL3d3dy5waHAubmV0LykNCj4gPiBUbyB1bnN1YnNjcmliZSwgZS1tYWlsOiBwaHAt
d2luZG93cy11bnN1YnNjcmliZUBsaXN0cy5waHAubmV0DQo+ID4gRm9yIGFkZGl0aW9uYWwgY29t
bWFuZHMsIGUtbWFpbDogcGhwLXdpbmRvd3MtaGVscEBsaXN0cy5waHAubmV0DQo+ID4gVG8gY29u
dGFjdCB0aGUgbGlzdCBhZG1pbmlzdHJhdG9ycywgZS1tYWlsOiANCj4gPiBwaHAtbGlzdC1hZG1p
bkBsaXN0cy5waHAubmV0DQo+ID4gDQo+IA==
Tm8gcHJvYnMgSm9obi4gSSdsbCB0YWtlIHRoYXQgaW4gbm9uLXNlcXVlbnRpYWwgc21hbGwgVVMg
ZGVub21pbmF0aW9ucywgdGhhbmtzISA6LSkgQW5kIG9mIGNvdXJzZSBEYXJ2aW4gY2FuIGhhdmUg
aGFsZi4NCg0KSWduYXRpdXMNCg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBGcm9t
OiBBc2VuZG9yZiwgSm9obiBbbWFpbHRvOkpBc2VuZG9yZkBsY291bnR5LmNvbV0NCj4gU2VudDog
V2VkbmVzZGF5LCAxNCBGZWJydWFyeSAyMDAxIDAwOjMzDQo+IFRvOiBEYXJ2aW4gQW5kcmlvbGk7
ICdJZ25hdGl1cyBUZW8nOyBBc2VuZG9yZiwgSm9objsgJ1BocC1XaW5kb3dzDQo+IChFLW1haWwp
Jw0KPiBTdWJqZWN0OiBSRTogW1BIUC1XSU5dIGFzc2lnbmluZyB2YXJpYWJsZSBuYW1lcyBvbiB0
aGUgZmx5LCBiYWNrZWQNCj4gbXlzZWxmIGluIHRvIGEgY29ybmVyDQo+IA0KPiANCj4gVGhhdCdz
IHRoZSB0aWNrZXQuICBUaGFua3MgYSBtaWxsaW9uIQ0KPiANCj4gLS0tLS0tLS0tLS0tLS0tLS0t
LS0tDQo+IEpvaG4gQXNlbmRvcmYgLSBqYXNlbmRvcmZAbGNvdW50eS5jb20NCj4gV2ViIEFwcGxp
Y2F0aW9ucyBEZXZlbG9wZXINCj4gaHR0cDovL3d3dy5sY291bnR5LmNvbSAtIE5FVyBGRUFUVVJF
UyBBRERFRCBEQUlMWSENCj4gTGlja2luZyBDb3VudHksIE9oaW8sIFVTQQ0KPiA3NDAtMzQ5LTM2
MzENCj4gSXBzYSBzY2llbnRpYSBwb3Rlc3RhcyBlc3QNCj4gDQo+IA0KPiA+IC0tLS0tT3JpZ2lu
YWwgTWVzc2FnZS0tLS0tDQo+ID4gRnJvbTogRGFydmluIEFuZHJpb2xpIFttYWlsdG86ZGFydmlu
LmFuZHJpb2xpQGNhcmljZXNlLml0XQ0KPiA+IFNlbnQ6IFR1ZXNkYXksIEZlYnJ1YXJ5IDEzLCAy
MDAxIDY6NTIgQU0NCj4gPiBUbzogJ0lnbmF0aXVzIFRlbyc7ICdBc2VuZG9yZiwgSm9obic7ICdQ
aHAtV2luZG93cyAoRS1tYWlsKScNCj4gPiBTdWJqZWN0OiBSRTogW1BIUC1XSU5dIGFzc2lnbmlu
ZyB2YXJpYWJsZSBuYW1lcyBvbiB0aGUgZmx5LCBiYWNrZWQNCj4gPiBteXNlbGYgaW4gdG8gYSBj
b3JuZXINCj4gPiANCj4gPiANCj4gPiBJZ25hdGl1cyB3cm90ZToNCj4gPiANCj4gPiA+IHRyeSBh
c3NpZ25pbmcgaXQgdG8gYW5vdGhlciB2YXJpYWJsZSBmaXJzdDoNCj4gPiA+IGZvciAuLi4uDQo+
ID4gPgkkdGFnID0gIiR0YWdfbnVtJGkiOw0KPiA+ID4JJHR5cGUgPSAidGFnX3R5cGUkaSI7DQo+
ID4gPgkkc3FsID0gLi4uLiBWQUxVRVMgKC4uLiwgJHRhZywgJHR5cGUuLi4uKTsNCj4gPiANCj4g
PiBUaGUgbGFzdCBzdGF0ZW1lbnQgbXVzdCBiZToNCj4gPiAkc3FsID0gLi4uLiBWQUxVRVMgKC4u
LiwgJCR0YWcsICQkdHlwZS4uLi4pOw0KPiA+IA0KPiA+IHNvIHlvdSBnZXQgdGhlIHZhbHVlIG9m
IHRoZSB2YXJpYWJsZSBuYW1lZCB0YWdfdHlwZSRpLCANCj4gPiBvdGhlcndpc2UgeW8gZ2V0IG9u
bHkgdGhlIHN0cmluZyAidGFnX3R5cGUgdmFsdWUgb2YgJGkiDQo+ID4gDQo+ID4gRGFydmluDQo+
ID4gDQo+ID4gDQo+ID4gPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiA+ID4gRnJvbTog
QXNlbmRvcmYsIEpvaG4gW21haWx0bzpKQXNlbmRvcmZAbGNvdW50eS5jb21dDQo+ID4gPiBTZW50
OiBUdWVzZGF5LCAxMyBGZWJydWFyeSAyMDAxIDA3OjU4DQo+ID4gPiBUbzogUGhwLVdpbmRvd3Mg
KEUtbWFpbCkNCj4gPiA+IFN1YmplY3Q6IFtQSFAtV0lOXSBhc3NpZ25pbmcgdmFyaWFibGUgbmFt
ZXMgb24gdGhlIGZseSwgDQo+ID4gPiBiYWNrZWQgbXlzZWxmIGluDQo+ID4gPiB0byBhIGNvcm5l
cg0KPiA+ID4gDQo+ID4gPiANCj4gPiA+IEkndmUgd3JpdHRlbiBhIGxpdHRsZSBzY3JpcHQgdGhh
dCBtYWtlcyBhIGZvcm0gdXNpbmcgYSBzaW1wbGUgDQo+ID4gPiBmb3IgbG9vcDoNCj4gPiA+IA0K
PiA+ID4gaWYgKCAkbnVtX3JlZyAhPSAiIiApICAgeyAgICAgICAgIC8vd2UncmUgZG9pbmcgcmVn
dWxhcnMNCj4gPiA+IA0KPiA+ID4gCWZvciAoICRpID0gMSA7ICRpIDw9ICRudW1fcmVnIDsgJGkr
KyApICB7DQo+ID4gPiAJCWVjaG8gIjx0cj48dGQ+QTxpbnB1dCB0eXBlPVwiaGlkZGVuXCIgDQo+
ID4gPiBuYW1lPVwidGFnX3R5cGUke2l9XCINCj4gPiA+IHZhbHVlPVwiQVwiPjwvdGQ+IjsNCj4g
PiA+IAkJZWNobyAiPHRkPjxpbnB1dCB0eXBlPVwidGV4dFwiIA0KPiA+ID4gbmFtZT1cInRhZ19u
dW0ke2l9XCI+PC90ZD4iOw0KPiA+ID4gCQllY2hvICI8dGQ+PGlucHV0IHR5cGU9XCJ0ZXh0XCIg
bmFtZT1cInRhZ19jb3N0JHtpfVwiDQo+ID4gPiB2YWx1ZT1cIlwiPjwvdGQ+IjsNCj4gPiA+IAkJ
ZWNobyAiPHRkPjxpbnB1dCB0eXBlPVwidGV4dFwiDQo+ID4gPiBuYW1lPVwidGFnX2xhdGUke2l9
XCI+PC90ZD48L3RyPlxuIjsNCj4gPiA+IAl9CQ0KPiA+ID4gCQ0KPiA+ID4gCSR0YWdfY291bnQg
PSAkbnVtX3JlZzsNCj4gPiA+IAkNCj4gPiA+IH0NCj4gPiA+IA0KPiA+ID4gTm93IHdoYXQgSSBo
YXZlIGlzIGEgbnVtYmVyIG9mIHZhcmlhYmxlcyB0aGF0IGxvb2sgDQo+ID4gc29tZXRoaW5nIGxp
a2UgdGhpcw0KPiA+ID4gDQo+ID4gPiAkdGFnX3R5cGUxLCAkdGFnX251bTEsICR0YWdfY29zdDEs
ICR0YWdfbGF0ZTEsICR0YWdfdHlwZTIsIA0KPiA+ICR0YWdfbnVtMiwNCj4gPiA+ICR0YWdfY29z
dDIsICR0YWdfbGF0ZTIsIGV0Y2V0ZXJhLi4uIHVwIHRvIGFueSBudW1iZXIgb2YgdGFncy4uLg0K
PiA+ID4gDQo+ID4gPiBub3cgSSdtIHRyeWluZyB0byB3cml0ZSBhIGxpdHRsZSBmb3IgbG9vcCB0
aGF0IGRyb3BzIHRoaXMgDQo+ID4gPiBpbmZvcm1hdGlvbiBpbnRvIGENCj4gPiA+IGRhdGFiYXNl
IGFmdGVyIHRoZSBQT1NUOg0KPiA+ID4gDQo+ID4gPiBmb3IgKCAkaT0xIDsgJGkgPD0gJHRhZ19j
b3VudCA7ICRpKysgKSB7ICAvL3RhZ19jb3VudCBjYW1lIA0KPiA+ID4gZnJvbSB0aGUgcG9zdA0K
PiA+ID4gKGRsX3Bvc3RfMy5waHApDQo+ID4gPiANCj4gPiA+ICAgICAgJHNxbCA9ICJJTlNFUlQg
aW50byBjZnVsbDIudGJsX2RsX3RhZ3MgKFRBR0lEX05VTSwgDQo+ID4gPiBDVVNUSURfTlVNLCBU
QUdfTk8sDQo+ID4gPiBUQUdfWUVBUiwgVFlQRV9DT0RFLCBDT1NULCBUWVBFKSBWQUxVRVMgKCRD
VVNUSURfTlVNLCANCj4gPiA+ICR0YWdfbnVtJGksICR0YWdfeWVhciwNCj4gPiA+ICckdGFnX3R5
cGUkaScgLCAkdGFnX2Nvc3QkaSApIjsNCj4gPiA+IA0KPiA+ID4gICAgICAkc3RtdCA9IE9DSVBh
cnNlICggJGNvbm5lY3Rpb24gLCAkc3FsICk7DQo+ID4gPiANCj4gPiA+ICAgICAgT0NJRXhlY3V0
ZSAoICRzdG10ICwgT0NJX0RFRkFVTFQgKTsNCj4gPiA+ICAgICAgT0NJQ29tbWl0KCAkY29ubmVj
dGlvbiApOw0KPiA+ID4gICAgICBPQ0lGcmVlU3RhdGVtZW50ICggJHN0bXQgKTsNCj4gPiA+IH0N
Cj4gPiA+IA0KPiA+ID4gDQo+ID4gPiBUaGlzIG9idmlvdXNseSBkb2Vzbid0IHdvcmsgYW5kIEkn
bSBub3QgcmVhbGx5IHN1cmUgd2hhdCB0byANCj4gPiA+IGRvIG5vdy4gIElzIHRoaXMNCj4gPiA+
IGEgY2FzZSBvZiB2YXJpYWJsZSB2YXJpYWJsZSBuYW1lcz8gIEkgZG9uJ3QgcXVpdGUgZ2V0IHRo
b3NlIA0KPiA+IGVpdGhlciAgOikNCj4gPiA+IA0KPiA+ID4gVGhhbmtzIGluIGFkdmFuY2UgYWxs
LA0KPiA+ID4gDQo+ID4gPiBKb2huDQo+ID4gPiANCj4gPiA+IA0KPiA+ID4gLS0tLS0tLS0tLS0t
LS0tLS0tLS0tDQo+ID4gPiBKb2huIEFzZW5kb3JmIC0gamFzZW5kb3JmQGxjb3VudHkuY29tDQo+
ID4gPiBXZWIgQXBwbGljYXRpb25zIERldmVsb3Blcg0KPiA+ID4gaHR0cDovL3d3dy5sY291bnR5
LmNvbSAtIE5FVyBGRUFUVVJFUyBBRERFRCBEQUlMWSENCj4gPiA+IExpY2tpbmcgQ291bnR5LCBP
aGlvLCBVU0ENCj4gPiA+IDc0MC0zNDktMzYzMQ0KPiA+ID4gSXBzYSBzY2llbnRpYSBwb3Rlc3Rh
cyBlc3QNCj4gPiA+IA0KPiA+ID4gDQo+ID4gPiAtLSANCj4gPiA+IFBIUCBXaW5kb3dzIE1haWxp
bmcgTGlzdCAoaHR0cDovL3d3dy5waHAubmV0LykNCj4gPiA+IFRvIHVuc3Vic2NyaWJlLCBlLW1h
aWw6IHBocC13aW5kb3dzLXVuc3Vic2NyaWJlQGxpc3RzLnBocC5uZXQNCj4gPiA+IEZvciBhZGRp
dGlvbmFsIGNvbW1hbmRzLCBlLW1haWw6IHBocC13aW5kb3dzLWhlbHBAbGlzdHMucGhwLm5ldA0K
PiA+ID4gVG8gY29udGFjdCB0aGUgbGlzdCBhZG1pbmlzdHJhdG9ycywgZS1tYWlsOiANCj4gPiA+
IHBocC1saXN0LWFkbWluQGxpc3RzLnBocC5uZXQNCj4gPiA+IA0KPiA+IA0KPiANCj4gLS0gDQo+
IFBIUCBXaW5kb3dzIE1haWxpbmcgTGlzdCAoaHR0cDovL3d3dy5waHAubmV0LykNCj4gVG8gdW5z
dWJzY3JpYmUsIGUtbWFpbDogcGhwLXdpbmRvd3MtdW5zdWJzY3JpYmVAbGlzdHMucGhwLm5ldA0K
PiBGb3IgYWRkaXRpb25hbCBjb21tYW5kcywgZS1tYWlsOiBwaHAtd2luZG93cy1oZWxwQGxpc3Rz
LnBocC5uZXQNCj4gVG8gY29udGFjdCB0aGUgbGlzdCBhZG1pbmlzdHJhdG9ycywgZS1tYWlsOiAN
Cj4gcGhwLWxpc3QtYWRtaW5AbGlzdHMucGhwLm5ldA0KPiA=
This is the error that appeared:
Warning: SQL error: [INTERSOLV][ODBC InterBase driver][InterBase]conversion
error from string "BLOB", SQL state S1000 in SQLExecDirect in
c:/homepages/message/post.php on line 7
> Easier to diagnose if you tell us what the error was?
>
> Winston Valenzuela wrote:
>
> > I'm using ODBC to connect to my Interbase 6 database. Using the code:
> >
> > $post_stmt = "Insert into
> > MSGTABLE(firstname,middlename,lastname,msg_subject,msgbody,remote_ip)
> > values('$fname','$mname','$lname','$subj','$mssg','$remote_ip')";
> >
> > and the msgbody field is a blob type. and the data came from a textarea
> > field. But i got an error using this insert statement.
> >
> > How can i do it without an error?
> >
> > --
> > PHP Windows 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 Windows 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'm not much of an NT expert, so forgive me if this is a silly question.
But if the regular internet user doesn't have rights, and I make a web page
to do these functions, how do I get at it via the internet as a different
user that does have rights? Do you have to be sitting at the machine to
take advantage of the extension?
Thanks,
Rick
-----Original Message-----
From: David Harrison [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 9:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] IIS Manipulation
Richard,
I didn't test it but I would imagine that as long as your server is
configured correctly, the box (or site) IUSR account wouldn't have the
necessary priveledges to do anything chaotic. I didn't test that, so might
be worth testing.
If for some reason it does work (again I'd be surprised if it did), you
could probably set up something funky like a single site that has a .php
extension bound to a different php.exe that calls a different .ini file (if
this is possible under windows, under linux I'm sure you can just
o -c<path> Look for php.ini file in this directory) which has the
settings for the IIS stuff contained in that. This way you've only got one
site (which you can lock down with IP restrictions or whatever) that can
access the DLL.
--dave
----- Original Message -----
From: "Richard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 12:36 AM
Subject: RE: [PHP-WIN] IIS Manipulation
> How are these functions controlled? Like, if I install this dll, will
> anyone with a site on my server be able to use these functions? Are there
> any restrictions as to how they can be used?
>
> Thanks,
> Rick
>
> -----Original Message-----
> From: David Harrison [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 11, 2001 1:24 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] IIS Manipulation
>
>
> With the absence of any ADSI interface for PHP (and a COM implementation
> that seems dodgy, at least for me and the others that have tried it), I'd
> sort of given up thinking about using PHP for IIS manipulation and had
> resigned myself to a fate of VBScript for anything I needed to do.
>
> I'd noticed there's a DLL that comes with the latest distribs of PHP
called
> php_iisfunc.dll, which I'd always wondered what it did. Whilst looking at
> the zend.com site today, I found a list of undocumented functions
> (http://www.zend.com/phpfunc/nodoku.php), which makes reference to these
> functions.
>
> Because noone has done it yet (unless I've missed it) I thought I'd just
> spam some quick information about some testing I did with them.
>
> ----------------
>
> string iis_GetScriptMap(string id, string virtualPath, string extension)
>
> Returns IIS script mappings for a site.
>
> eg:
> echo iis_GetScriptMap(iis_GetServerByComment("srvName"), "", ".asp");
> returns:
> .asp,F:\WINNT\System32\inetsrv\asp.dll,1,GET,HEAD,POST,TRACE
>
> ----------------
>
> int iis_AddServer(string Path, string Comment, string ServerIP, int
> ServerPort, string HostName, int ServerRights, int StartServer)
>
> Adds a server to the IIS Metabase with the supplied parameters.
>
> eg:
> iis_AddServer("f:\\", "comment","130.102.1.1", 80,"hostname", 0,1);
>
> Creates a new server with a hostheader name "hostname". Returns the Server
> Instance ID for the created server.
>
> ----------------
>
> int iis_GetServerByComment(string comment);
> int iis_GetServerByPath(string path);
>
> Returns the server instance ID for the server with the comment (ie, the
name
> that appears in MMC). This ID can then be passed to some of the other
> functions (as done below).
>
> eg:
> iis_GetServerByComment("Default Web Site");
> iis_GetServerByPath("f:\inetpub\wwwroot");
> Returns:
> Using 'Default Web Site' as the comment should return 1.
>
>
>
> ----------------
>
> int iis_StopServer(int serverID);
>
> Stops a particular server
>
> eg:
> iis_StopServer("Default Web Site");
> Returns
> 1 on success, 0 on failure, I _think_ - however, I couldn't get this
> function to work.
>
> I'm not sure of the difference between this one and iis_StopService. I
would
> have thought StopService would stop the whole webservice, but it seems to
> take a serverID parameter. Shrug.
>
> ----------------
>
> int iis_StartServer(int serverID);
>
> Starts a particular server
>
> eg:
> iis_StartServer("Default Web Site");
> Returns
> 1 on success, 0 on failure, I _think_. That is, the function returned 1
on
> one site that I'd stopped, and successfully restarted it. However, I
> couldn't make it restart the 'Default Web Site', yet it still returned 1.
> Shrug.
>
> ----------------
>
> int iis_RemoveServer(int serverID);
>
> eg:
> iis_RemoveServer(iis_GetServerByComment("comment"));
> Returns
> 1 on success, -602 on failure (if I made up a fake comment)
>
> ----------------
>
> There are also the following, which return values that I didn't try to
> figure out (laziness), and take a 2nd parameter (referred to in the source
> as string VirtualPath) that I also didn't figure out (also laziness):
>
> iis_getdirsecurity(iis_GetServerByComment("website"), "");
> iis_GetServerRight(iis_GetServerByComment("website"), "");
> iis_GetServiceState(iis_GetServerByComment("website"));
>
> Sorry about the poor documentation, but its better than what is on the PHP
> site :)
>
> I'm not sure how stable/reliable these are. I had a quick look through the
> source but I'm not familiar enough with the metabase functions that are
used
> to know whether or not its done in the most stable way. I know though that
> I've had enough problems with metabase corruption on servers that have
only
> ever been administered through MMC to be wary when trying 3rd party
products
> to do a similar thing.
>
> --dave
>
> --
> PHP Windows 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 Windows 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 Windows 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'm not much of an NT expert, so forgive me if this is a silly question.
> But if the regular internet user doesn't have rights, and I make a web
page
> to do these functions, how do I get at it via the internet as a different
> user that does have rights? Do you have to be sitting at the machine to
> take advantage of the extension?
Nope - you can remove access for the IUSR account from the directory which
contains the files. When you do this, you'll get a standard
username/password dialog asking for login details - you should be able to
use any user account (ie, administrator) to get into that directory. When
you do this, the pages are being executed with the userid of whatever you
use to login - so be careful :)
--dave
Hallo!
I got this problem, I can't insert a image to the pdf
document. I useing " pdf_place_image
($pdfdoc, "test.gif", 100, 100, 1); "
Is it anybody got a tip..
Best regards.
//Glenn
................................................................
80.000 svenskar har nu gratis e-post på Sverige.nu!
http://www.sverige.nu
I have installed mysql on my remote host and phpmyadmin on my local machine,
(which seems good, reading your posts on this NG :-) )
If I try to open index.php I get the following error:
Warning: MySQL Connection Failed: Host '' is not allowed to connect to this
MySQL server in lib.inc.php on line 255
Error
What shoul I write in config.inc.php as host? Not the complete URL to mysql
(IE www.mysite.net/usr/local/mysql )?
Thank you very much in advance,
Manuela
Manuela.
I tried this for a while, and found that it was actually a problem at one of my
ISP's end that they were unable to resolve, so I gave up and installed
phpmyadmin on my remote site as well (its not very big if you pare down the
unwanted bits).
You may have the same problem
Tom
Manuela wrote:
> I have installed mysql on my remote host and phpmyadmin on my local machine,
> (which seems good, reading your posts on this NG :-) )
> If I try to open index.php I get the following error:
>
> Warning: MySQL Connection Failed: Host '' is not allowed to connect to this
> MySQL server in lib.inc.php on line 255
> Error
>
> What shoul I write in config.inc.php as host? Not the complete URL to mysql
> (IE www.mysite.net/usr/local/mysql )?
>
> Thank you very much in advance,
> Manuela
>
> --
> PHP Windows 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]
in your lib.inc.php
put localhost as the host value
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com
"MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK......"
>What shoul I write in config.inc.php as host?
The name of the remote machine (eg whatever.mysite.net) or its IP address.
You also need to check in the mysql privilege tables that your own IP
address is allowed to talk to mysql. This may be tricky without phpmyadmin
running first though - you will probably have to ask your ISP to grant you
the appropriate privileges.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
Hi i have a problem with PHP using a dll that i have created
the dll have this structure
class (PROCESS)
object(CAT)
void(FILTER)
then, when i do this:
$pro=new COM("ENGINE.PROCESS"); it works fine
if i print any property it works but when i try to use the void filter
it gives me a lot of errors
i'm trying this
$pro->CAT.FILTER(XXX);
and i have tried
$pro->CAT->FILTER(XXX);
but nothing works, can somebody help me...
thanks
Dario
I believe that the next PHP version will correct a lot of the COM bugs in
the current version.
Alain
On Tue, Feb 13, 2001 at 05:43:29PM -0400, Dario Carnelutti wrote:
> Hi i have a problem with PHP using a dll that i have created
>
> the dll have this structure
> class (PROCESS)
> object(CAT)
> void(FILTER)
>
> then, when i do this:
> $pro=new COM("ENGINE.PROCESS"); it works fine
> if i print any property it works but when i try to use the void filter
> it gives me a lot of errors
>
> i'm trying this
> $pro->CAT.FILTER(XXX);
>
> and i have tried
> $pro->CAT->FILTER(XXX);
>
> but nothing works, can somebody help me...
>
> thanks
>
> Dario
>
>
> --
> PHP Windows 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 trying to insert some data into a MSSQL Server 7.0 database from Php. Some
of the data has various characters ', > . How can I tell SQL Server to
treat these characters as part of the input.
Ryan Conover
It is only the ' charactor there has a "problem" you have to excape any special
character before inserting.
the text Joe's should be inserted like this"
INSERT INTO table1 (int_field, char_field) VALUES (1, 'Joe''s')
A single quote is escaped by an extra single quote.
- Frank
>I trying to insert some data into a MSSQL Server 7.0 database from Php. Some
>of the data has various characters ', > . How can I tell SQL Server to
>treat these characters as part of the input.
>
>Ryan Conover
>
>--
>PHP Windows 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]
>
>
>
in mysql i'd treat them as a char or varchar i would assume it would be the
same in MSSQL
-----Original Message-----
From: Conover, Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:32 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] INSERT into MSSQL Server
I trying to insert some data into a MSSQL Server 7.0 database from Php. Some
of the data has various characters ', > . How can I tell SQL Server to
treat these characters as part of the input.
Ryan Conover
--
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]
Have you tried addslashes () on the input lines before the insert?
Conover, Ryan wrote:
> I trying to insert some data into a MSSQL Server 7.0 database from Php. Some
> of the data has various characters ', > . How can I tell SQL Server to
> treat these characters as part of the input.
>
> Ryan Conover
>
