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