Search the Community

DILEMMA: My goal is to style the body of a newsletter template. Although I am able to get the formatting into the database and -table, I am unable to retrieve it for insertion in the newsletter's template. Please find below an example of the way in which the value string of only one of the several SQL INSERT statements is created. The string that results is later combined with a name string and other elements of a valid INSERT statement. EXAMPLE OF THE WAY THE INSERTED VALUE IS FORMATTED include_once('../_utilities/php/classes/class.lunarpages.php'); $lunarpages = new Lunarpages(); $mysqli_obj = $lunarpages->get_mysqli_obj(); var_dump($mysqli_obj); $sql_letter_val = "('"; $substr_start = 0; $substr_length = 8; foreach ($newsvar_names as $name => $value) { if (substr($name, $substr_start, $substr_length) == '$letter_') { $sql_letter_val .= $mysqli_obj->real_escape_string($value) . "', '"; } } WHAT APPEARS IN THE DATA TABLE AFTER INSERTION <h1>ようこそ！</h1> <p>「<span style='font-family:Bradley Hand, cursive;font-size:1.8em;'>Seven Gates</span>」と言うのは文法キャプチッブのオンラインニューズレターです。</p> <p>このニューズレターの初版は文法キャプチッブの紹介としてニューズレターの構成及び文法キャプチッブの本質をユーザー達にその母語で説明しています。第二版のニューズレター以降のニューズレターは英語で書いてあるものです。もしニューズレターの初版を英語でも読んだ方が好いとすれば、ウェブ型の変形が<a href='https://www.grammarcaptive.com/?newsletter=1' title='Seven Gates - Edition No. 1' target='_blank'>ここに</a>見付かります。</p> THE RETRIEVAL CODE public function get_letter_data() { $sql = "SELECT letter.*, qa.qa_question, qa.qa_answer FROM sevengates_letter AS letter JOIN sevengates_qa AS qa ON qa.letter_no = letter.letter_no WHERE letter.letter_no =?"; $mysqli_stmt = $this->mysqli_obj->stmt_init(); $mysqli_stmt->prepare($sql); $mysqli_stmt->bind_param('i', $this->letter_no); $mysqli_stmt->execute(); $meta = $mysqli_stmt->result_metadata(); while ($field = $meta->fetch_field()) { $params[] = &$row[$field->name]; } call_user_func_array(array($mysqli_stmt, 'bind_result'), $params); while ($mysqli_stmt->fetch()) { foreach($row as $key => $val) { $c[$key] = $val; } $prelim_result[] = $c; } foreach ($prelim_result as $arr) { foreach ($arr as $name => $value){ $letter_results[$name] = $value; } } return $letter_results; } WHAT IS RETRIEVED and APPEARS IN THE NEWSLETTER ようこそ！ DISCUSSION: Everything after the <h1> element has been omitted. QUESTION: What must I do to get everything after ようそう！to appear? Roddy

When I read from my MS Access database(unicode), the Cyrillic characters are not being written correctly in browser(utf-8). How to encode the data by VBScript in real time or how to convert it manually in MS Access? This is what I've found on this topic, but it seems to be quite complicated: http://stackoverflow.com/questions/22054934/capture-and-insert-unicode-text-cyrillic-into-ms-access-database/22072399#22072399

Hi, Sorry about my total lack of technical knowledge. What do you save .css files as? Is it UTF-8 or ANSI? Also in the raspbian distro I'm using it has the option of 'Current Locale(UTF-8)' and 'UTF-8' but not for 'ANSI'. The other options are ISO-8859-1, ISO-8859-15, CP1252. And next to the options is another box with CR+LF and you can choose just LF or just CR. I'm trying to use the raspberry pi as a webserver so I can see what my website designs look like on my Apple Ipod. 1. It shows up on the ipod but the css doesn't seem to be linking. 2. I can open it in the Dillo web browser on the raspbian distro and it is working fine. 3. If I type the IP address of my Raspberry PI into my Apple Ipod using the safari browser or my Windows10 using the Edge browser it just loads the basic HTML without any CSS. 4. It works if I just run the files from my local account on Windows, i.e. the same files I have on the raspberry pi but loading them straight from my windows machine and not going through the raspberry pi. I have put everything in the same folder: /var/www I have put a link in the header part of the HTML file for the CSS: <link rel="stylesheet" href="/var/www/smallest.css">

Unfortunately, the it-nic got the "great" idea to start selling domains with accented characters to improve their revenues. :facepalm:Those domains may contains not only italian accented vowels, but even many others of other nations.So, even italian site with italian target have now to handle email addresses such as info@Iñtërnâtiônàlizætiøn.it. Trying to manage this problem using php, the only way I found is using the punycode translation, to that info@Iñtërnâtiônàlizætiøn.it becomes info@xn--itrntinliztin-vdb0a5exd8ewcye.it I tested in the FROM field and it works (I don't have an email address with special chars to use for the tests). Anyway, this brings us to another problem: imagine this simple/frequent scenario1) Contact Web form. A guy inserts his data and sends it.2) The company receives the email and replies (if they don't know of punycode, will be quite scaring!).3) The guy of point 1, who inserted his email in plain utf-8, receives the reply at his address but with this strange, different email address, which is not what he typed in the web form, looking like phishing or spam. I also tried a different approch: mb_encode_mimeheader(): it seems ok visually in the email clients, but trying to reply, the address get into the encoded way... something like=?UTF-8?B?ScOxdMOrcm7DonRpw7Ruw6BsaXrDpnRpw7huQHJpa3NvZnQuaXQ=?=IMPRACTICAL, working or not! Does anyone know a better way to send emails with the host part with accented vowels?