[PHP-DB] Converting text field to barcode CODE 39
Hello. Can anyone tell me where I can find information or examples about printing on screen or in PDF (with FDPF for example) for text fields stored on a MySQL Database with PHP 4 , PHP 5. Best regards, Jorge Gimenez
[PHP-DB] Digital Signature and PHP4/5
Hello. I am looking for info about PHP+ Database (Mysql/Postrgesql) + Digital Signature. Does anyone know about any site, book... about this? Best regards, Jorge Gimenez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Read HTML code and store it in database
Hello. I am looking a way t oread html code with a php script. I have a php script separated from my server that gives that some results I need to read and store. I can't access to the data server of this php because it's embebed on the machine. The script would be $url=Function_to_connect_url(url); //code to search data in $url; //code to store data; Any ideas?. Best regards, Jorge Giménez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Special character on an INSERT statement
Hi .
I'm trying to do this on an INSERT statement.
$sql= "INSERT (' TONS OF CD'S ')
or any phrase with the character ' .
Obviously it gives an error when execeting mysql_query.
How can I do it ?
Thanks,
Jorge Giménez
Fw: [PHP-DB] Special character on an INSERT statement
Hi again.
I'm still trying but I can't do it.
I have tried this :
$values=$values.addslashes("'".$value).addslashes("'");
The result of this would be something like this
INSERT INTO Carrocerias VALUES (\'Ber\',\' Berlina\')
The mysql_errno is 1064.
I've tried mysql_escape_tring with the same result.
Before INSERT statement I put this
mysql_escape_string("\");
but it didn't work.
Can anyone where I could found an example ? I have looked on the online
manual of php but they are SELECT examples, there are no INSERT examples.
I ' m a newbie PHP programmer .
Thanks again,
Jorge Giménez
- Original Message -
From: "Jorge Giménez Mayorgas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 6:48 PM
Subject: [PHP-DB] Special character on an INSERT statement
Hi .
I'm trying to do this on an INSERT statement.
$sql= "INSERT (' TONS OF CD'S ')
or any phrase with the character ' .
Obviously it gives an error when execeting mysql_query.
How can I do it ?
Thanks,
Jorge Giménez
--
PHP Database 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-DB] Re: Special Character on INSERT statement
Hi again
It is solved I used $value="'".urlencode($value)."'"
And urldecode for showing the data.
Thanks everybody for the help.
Later,
Jorge Giménez
- Original Message -
From: Jorge Giménez Mayorgas <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 11:33 AM
Subject: Fw: [PHP-DB] Special character on an INSERT statement
> Hi again.
>
> I'm still trying but I can't do it.
>
> I have tried this :
>
> $values=$values.addslashes("'".$value).addslashes("'");
> The result of this would be something like this
> INSERT INTO Carrocerias VALUES (\'Ber\',\' Berlina\')
> The mysql_errno is 1064.
>
> I've tried mysql_escape_tring with the same result.
> Before INSERT statement I put this
> mysql_escape_string("\");
> but it didn't work.
>
> Can anyone where I could found an example ? I have looked on the online
> manual of php but they are SELECT examples, there are no INSERT examples.
> I ' m a newbie PHP programmer .
>
> Thanks again,
>
> Jorge Giménez
>
> - Original Message -
> From: "Jorge Giménez Mayorgas" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 28, 2001 6:48 PM
> Subject: [PHP-DB] Special character on an INSERT statement
>
>
> Hi .
>
> I'm trying to do this on an INSERT statement.
>
> $sql= "INSERT (' TONS OF CD'S ')
> or any phrase with the character ' .
> Obviously it gives an error when execeting mysql_query.
>
> How can I do it ?
>
> Thanks,
>
> Jorge Giménez
>
>
>
[PHP-DB] MSSQL Views and Multiples selects on Mysql
Hi. I am migrating part of a big database of MSSQL to MySQL . The tables are migrated and data is ok but I need the views that I used on MSSQL . I tried this , I replaced the name of the view used with the sql statement , a very big select statement. I have checked SQL syntax with MySQL documentation and I think it's ok. It gives me with mysql_errorno the error 1064, any ideas? . Is there any program , script , etc to migrate to MySQL SQL syntax the views of MSSQL . Later, Jorge Gimenez
Re: [PHP-DB] Trouble connecting to MSSQL 2k DB
Try put the php dlls on %systemroot%/system. I have IIS 5.0 + PhP 4.0.6 + MSSQL on a W2k server working perfectly. Later, Jorge Giménez - Original Message - From: "Sean Swehla" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 13, 2001 8:10 PM Subject: [PHP-DB] Trouble connecting to MSSQL 2k DB > I'm running Win2k server, with MSSQL 2k, & PHP 4.0.6. Every time I try > to connect to the SQL sesrver within the script I get the following > output: > > X-Powered-By: PHP/4.0.6 > Content-type: text/html > > Warning: MS SQL message: Login failed for user 'tu'. Reason: Not > associated with a trusted SQL Server connection. (severity 14) in [script > path] on line 9 > > Warning: MS SQL: Unable to connect to server: PHP in [script path] on > line 9 > > Warning: MS SQL: Unable to connect to server: (null) in [script path] > on line 10 > > Warning: MS SQL: A link to the server could not be established in > [script path] on line 10 > > Lines 9 & 10 are as follows: > > $link_identifier = mssql_connect($server, $user, $pw); > mssql_select_db($db); > > I have the php_mssql.dll file installed in %systemroot%/system32 and the > appropriate line in php.ini. I've found hundreds of references on various > websites and in the mailing list archives to php_mssql70.dll, but cannot > locate it anywhere. Any help/thoughts/guidance would be appreciated. > > -=-=- > Sean Swehla, MCP > Network Architect > VPN Solutions, LLC > > -- > PHP Database 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 Database 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]
