Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 set to use to encode queries sent to the server. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8; Note that resultsets still are returned in the character set of the data returned. Specifying shared memory name Use...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); // decode and display in HTML-safe $my_description = html_entity_decode(htmlentities($my_description,...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 " + v_AccessToken); m_Header.put("Content-Type","application/x-www-form-urlencoded;charset=UTF-8"); // optional m_Data= Map(); m_Data.put("data",m_RecordData.toJSONList()); // NOTE: convert this to a JSON Array r_RecordUpdate = invokeUrl [ url...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Reorder Columns in a Tablehttps://www.joellipman.com/articles/database/reorder-columns-in-a-table.html

22 July 2013 int(11) NOT NULL, `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- To CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 CURLOPT_SSL_VERIFYHOST, false); $my_beautiful_body = ' --joes_awesome_divider Content-Type: application/json; charset=UTF-8 { "name": "'.$name.'" } --joes_awesome_divider Content-Type: '.$mime_type.' '.file_get_contents($file).' --joes_awesome_divider--...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Outputting PHP files into different file formatshttps://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8'); header('Content-Disposition: attachment; filename=foo.txt'); echo 'contents of file'; PHP to XLS $export_file =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 Just storing this in case. // cURL With SSL via method GET: FAIL $header = array( "Content-Type: text/xml;charset=UTF-8", "Accept: gzip,deflate", "User-Agent: WWPC uAPI Test", "Cache-Control: no-cache", "Pragma: no-cache", "Connection: Keep-Alive",...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 I tried but to no avail The solution above was as easy as that. Here are a number of other things I tried first: mysql_set_charset(): No iconv(): No htmlentities(): No preg_replace_callback(): No sxe(): No $xml = simplexml_load_string( utf8_encode($rss)...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *