Re: [PHP-DB] Text corruption when storing to MySql
I missed a variable in my previous postshould have been this: $submitted_text = $_POST['textFromForm']; function clean_ms_word($submitted_text) { $crap = array(chr(0x82),chr(0x83),chr(0x84),chr(0x85),chr(0x86),chr(0x87),chr(0x88),chr(0x89),chr(0x8a),chr(0x8b),chr(0x8c),chr(0x91),chr(0x92),chr(0x93),chr(0x94),chr(0x95),chr(0x96),chr(0x97),chr(0x98),chr(0x99),chr(0x9a),chr(0x9b),chr(0x9c),chr(0x9f)); $clean = array('‚','ƒ','„','&ldots;','†','‡','','‰','Š','‹','Œ','‘','’','"','"','•','–','—','˜','™','š','›','œ','Ÿ'); $content = str_replace($crap,$clean,$writing); return $content; } $usable = clean_ms_word($submitted_text); HTH, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Text corruption when storing to MySql
Gaby T. wrote: I am running into a problem where as I want to store test form a text field to a database (MySql in this case, sql type "text"). Apparently, if people are cutting and pasting text from another document (typically MS WORD) into the textfield, the text gets only partially saved. I am assuming wierd characters are being introduced in this manner (I definitively know this is a problem with rounded quotes) and although I am using the basic "addslashes" function, it's not enough. Has anyone seen this before and is there a fix? Thanx Gaby I believe Tom Rodgers from the PHP general list provided this answer when I posted a similar question about a year ago... $submitted_text = $_POST['textFromTextArea']; function clean_ms_word($writing) { $crap = array(chr(0x82),chr(0x83),chr(0x84),chr(0x85),chr(0x86),chr(0x87),chr(0x88),chr(0x89),chr(0x8a),chr(0x8b),chr(0x8c),chr(0x91),chr(0x92),chr(0x93),chr(0x94),chr(0x95),chr(0x96),chr(0x97),chr(0x98),chr(0x99),chr(0x9a),chr(0x9b),chr(0x9c),chr(0x9f)); $clean = array('‚','ƒ','„','&ldots;','†','‡','','‰','Š','‹','Œ','‘','’','"','"','•','–','—','˜','™','š','›','œ','Ÿ'); $content = str_replace($crap,$clean,$writing); return $content; } $usable = clean_ms_word($submitted_text); This has worked wonderfully for my applications! Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] password generator
Here's one I've used recently with success http://www.devhood.com/tools/tool_details.aspx?tool_id=784 Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OCIBindByName Help Needed
Hello, I've been working on this all day. I'm trying to insert some text ($essay) into a CLOB field (essay) in my table (clob_test). Can someone please tell me why the following PHP code returns ORA-01036: illegal variable name/number? Better yet, please tell me how to fix it?? $DB_Resource = OCIPLogon($user,$pass,$db); $Clob = OCINewDescriptor($DB_Resource, OCI_D_LOB); $Query_Resource = OCIParse($DB_Resource, "INSERT INTO clob_test (firstName,lastName,essay) VALUES ('Roger','Dodger','$essay')"); OCIBindByName($Query_Resource, ':essay', &$Clob, -1, OCI_B_CLOB); OCIExecute($Query_Resource, OCI_DEFAULT); $Clob->free(); OCIFreeStatement($Query_Resource); Please help preserve my sanity, Roger
[PHP-DB] What is this Mealer Deamon message?
I sent a post earlier..and got this in reply... Hi. This is the qmail-send program at pb1.pair.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. <[EMAIL PROTECTED]>: This message is looping: it already has my Delivered-To line. (#5.4.6) WTF is this? WTF does it mean? Thanks, R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ORA-01704: string literal too long AND PHP/PEAR
Ok all of you Oracle experts out there, I've had one heck of a day wrestling with this oracle stuff. My experience with Oracle is turning into a greek tragedy. I'm using PHP/PEAR to execute my queries on an oracle table. I'm trying to store very long pieces of text into a CLOB field. Currently I'm getting a string too long error. I've googled to find that there are certain limits when inserting into a table. The CLOB datafield may hold 4 gigs of text, but you may only insert 4000 bytes at a time. Or at least that's how I understand it. Anyone got a work around for this? I've tried: OCIBindByName($sql,":fieldName",&$myVariable, -1); But I'm not sure I'm using it correctly with PEAR. In my code, I have my sql statement, then I do the OCIBindByName() call, then I do my insert. But, this gets me: ocibindbyname(): supplied argument is not a valid OCI8-Statement resource Which is an actual PHP/PEAR errorI think... Anyone out there have any work around suggestions? I really dont want to parse the insert statement into pieces each being less then 4000 bytes. Thanks, R
[PHP-DB] Oracle Auto_Increment Error
Hello, BACKGROUND: I'm able to create tables in oracle, populate fields in oracle tables, select, retrieve and update fields in oracle. So I know my connection code is working. PROBLEM: I'm working with PHP and PEAR and I'm trying to create an auto_increment field in an oracle database table. The table has 3 fields and they are id, firstName, and lastName. Below I have included my code for creating, sequencing and triggering the table. I'm also including my insert statement which is currently creating an error. All I get is "DB Error: unknown error". Can anyone please tell me why this error is being generated? CODE: // // This will create table // $sql = "CREATE TABLE test (id INT NOT NULL PRIMARY KEY, firstName VARCHAR(255) NOT NULL, lastName VARCHAR(255) NOT NULL)"; $result = $db->query($sql); if (DB::isError($result)) { die ($result->getMessage()); } // // sequence // $sql = "CREATE SEQUENCE test_seq start with 1 increment by 1 nomaxvalue"; $result = $db->query($sql); if (DB::isError($result)) { die ($result->getMessage()); } // // trigger // $sql = "CREATE TRIGGER test_trigger before insert on test for each row begin select test_seq.nextval into :new.id from dual"; $result = $db->query($sql); if (DB::isError($result)) { die ($result->getMessage()); } //# // insert //# $sql = "INSERT INTO test (firstName,lastName) VALUES ('Roger', 'Dodger')"; $result = $db->query($sql); if (DB::isError($result)) { die ($result->getMessage()); } Thanks in advance, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SOLVED=> 'while' not picking up on first DB record
I'm sorry for the double post. Other then letting both lists know this was solved, it won't happen again. Sorry. Thank you for the solution! I new it was simple. I've been staring at it too long. Fresh eyes always helps! Thanks again, Roger You are making the fetch twice, and not using the first fetch. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] 'while' not picking up on first DB record
Hello, Can anyone from the lists please tell me why this bit of code is not picking up on the first record in the database? If the 'id' I'm looking for is '1' it doesn't populate the _SESSION variables. Any 'id' greater then '1' will populate the _SESSION variables. $q = "SELECT * FROM employee"; $r = mysql_query($q); $row = mysql_fetch_array($r); while ($row = mysql_fetch_array($r)) { if ($employee == $row["id"]) { $_SESSION['dear'] = $row["last_name"]; $_SESSION['to_email'] = $row["email"]; } } Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle and PHP
Hello, I was wondering if there are any PHP people out there that are really into using Oracle databases? I've always used mysql but now I find myself in a situation that requires the use of an Oracle database. I've printed out the information posted by Thies C. Arntzen titled "Making Efficient use of Oracle8i thru Apache and PHP 4" but I was wondering if I may see some other code examples. Very basic examples dealing with connections, queries and the such. Also, is there an application for Oracle databases that is similar to PHPMyAdmin for mysql databases? Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] test, please delete
test, please delete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php