SLSCoder

"update process is writing two separate characters": That's curious. I'll have to figure that out. I'm thinking when it's written into the db it gets escaped. It should show up as 2 lines yes? I'll find it and fix it. Thanks. "- the percent sign??": Sorry, I meant the HEX response looks like HTML codes without the percent sign. dechex(ord('%')); Thanks for that. I looked for how to do this for over 2 hours and never did find it.

Barand thank you. It looks like to read HEX I just need to recognize that every 2 numbers represents 1 character in HTML - the percent sign?? I did try using the double backslash but I'll try it again and let you know what I come up with.

gizmola thank you. I don't write each record to html on the server or use in line <?php ... ?> tags. I pass the whole thing (with more than just the recordset) to the client and write the html in Javascript. When I look at the example record having a line feed in the database (HeidiSQL) I see \n in the text: ie: "We chartered a \n fishing trip". No \r or \r\n exist in any records, only \n. It's a Linux server and no records are saved with \r in them. I tried your HEX suggestion. I get long numbers but don't understand what they indicate. The response I got for that record was this: text: we chartered a \n fishing trip. hex: 7765206368617274657265642061205C6E2066697368696E6720747269702E When I use this: $sql = "SELECT REPLACE(TextField, '\n', '<br>') AS TextField FROM mytable WHERE ID = 2"; The line feed breaks the line in php (I see in view-source) which makes me think mysql doesn't see it. Php runs it anyway and MySql ignores it. I break sql lines in PHP all the time just so I can read the sql. Mysql ignores them. I tried a double slash to escape it in php. It seemed to ignore that too and gave me the same result: ie: "We chartered a \n fishing trip". That's what I see in the browser. I changed the value in javascript val = val.replaceAll("\n", "<br>") and that didn't work either. I see in the database: we chartered a \n fishing trip I see in the browser: we chartered a \n fishing trip Now I'm confused

Am I missing something? If I understand your solution clearly, you're asking me why I don't want to loop through records to fix any values that include line breaks. My answer to that would obviously be that I think to fix the values in the query would be significantly more efficient than to loop through and fix each record after the query. If you don't want to answer my question please just say so. I'm beginning to think that asking questions on this forum is a bad idea.

Thanks Barand but I know I can do that. I've got a lot of records in a record set and I'd really rather not have to loop through them all to fix line feeds.

I'm creating a sql statement in php: The value of TextField is "We chartered a \n fishing trip". $sql = "SELECT REPLACE(TextField, '\n', '<br>') AS TextField FROM mytable WHERE ID = 2"; I've tried every combination I can think of like 2 backslashes, 3, 4 . . . I tried using chr(92) instead of the backslash. I can't make it work. How can I get it to return the field (ex. TextField) with a br tag in it instead of a line feed?

In view of this very ugly thread I've started using your solution every time I read a data array field. I actually use $arMine["NoField"]??'' with no spaces. It works well. It's a little messy (and it's gonna take forever to fix them all) but you guys win. Thanks Kicken

Thanks. I've got every one of your problems here covered. Your illusions about my code are unfounded and incorrect. This conversation is over. This forum did not help me - again. Thank you for your time.

I fear PHP has lost site of its objective. PHP is famous because it's EASY - less so anymore with every new version. More code is not generally a better solution. This looks like bloatware to me: if(isset($arMine["NoField"])) . That would be hundreds of cases many of which are html input field values. This is a *little* better: $arMine["NoField"] ?? '' Thanks. I may even use this. ginerjm: Thanks for your responses. If I *want* warnings I would have no problem displaying them. If I'm in production and my users encounter a bug I've gotta fix it. So if I need warnings I just turn them on. I need to be ABLE to shut them off and always could. It doesn't work anymore. I don't know why. I've explained what I did. 'ALL php code' - as I stated above, all my files require_once a session file which handles that and a lot of other stuff for every page in the app. If I upgrade PHP it's a BIG move. PHP demolishes my code with every single new version (in the old days upgrades were better not destructive). That to say it happens first on a dev site and once re-debugged can be used in production. Of course debugging may well include the need to see warnings. webdeveloper123: Thanks for your response. I don't want the warnings to EVER show up unless I want them. That because I don't want to have to write code to cover every single case where I use a (maybe non-existent) field value in a data array.

OK, thanks anyway.

I know but it's just a pain in pretty near every interface. I store db fields in the same array as page functionality fields - sometimes. A given field (usually a functionality field) may or may not be in the array. If not, I just want an empty string. The solve is if(isset($arMine["NoField"])) ... For the field that threw the error I needed to debug I did that so it's fixed. In general ... not really. I'd rather lose the warnings. Is there no way to actually stop warnings from displaying?

I'm running PHP 8.1 in Apache2 on a Debian server. I need PHP to display error messages but not warning messages. I've got 2 config files, cli & fpm. I'm not sure which one Apache2 is using. Both have error_reporting set like this: error_reporting = E_ALL & ~E_WARNING & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT Moreover, every time a page loads session code loads with it. At the top of my page: SessionHandler.php is this: error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT); I've also tried changing it to this: error_reporting(E_ALL & ^ E_WARNING & ^ E_NOTICE & ^ E_DEPRECATED & ^ E_STRICT); Still the warning messages display. I've got a habit of trying to display values in associative arrays where the key doesn't exist. PHP throws a warning up for doing this: Warning: Undefined array key "ScpFeatureBundleID" How can I get rid of this warning without stopping errors from displaying?

Thanks. open_basedir is not set. It's remmed out. I saw that on stackoverflow. You were right /var/log Nothing in there. I wonder why it wouldn't access /usr/share.

OK, I moved the fonts to /var/www/fonts/truetype and set ownership & group to www-data. The permissions look right. JpGraph seems to be happy now. Funny though, the JpGraph default path was /usr/share/fonts/truetype which is what sent me down that trail. I just didn't realize that you can't access any folder on the server from a PHP website. It's fixed now. Thanks.

It's my box. It's a standard debian apache 2 installation. All the sites are in /var/www/ Where are the PHP error logs? What does "bundle it into your application's codebase" mean? Multiple sites; multiple PHP apps will need access to the fonts.