Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming yields is required, the following 93 results were found.

  1. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    "\t" . $this_fri . "\t" . $this_sat . "\t" . $this_sun . "\t" . $this_t . "\t" . $this_t2;...do some more here ???... } } Yields -- Note this data matches the brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as...

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

  2. Delete related records from multiple tableshttps://joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- yields: sessionID sessionID sessionID --------- --------- --------- 148797 148797 148797 148798 148798 148798 148799 (null) 148799 148800...

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

  3. Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    AS newText, `content_column` as oldText FROM `MYTABLE_content` WHERE `content_column` LIKE CONCAT('%',@stringtoFind,'%') -- yields id title OldFoundInOld NewFoundInOld OldFoundInNew newText oldText 1 Article 1 yes no no Hello World Hello World 2 Article...

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

  4. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    . " "; The key of the above array is the name of the variable you passed in your HTML form. If the above yields NO empty data (and size is not 0) then it was successful. If not, then either your system isn't accepting the file type you are trying to...

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

  5. htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html --yields http://www.mysite.com/index.php?myFolder=blog&myFiles=pretty_much_anything_i_want_to_type_here.html Anything not ending in...

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

  6. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    // print the json echo $json_result; // [OPTIONAL] convert it to an array // $array = json_decode($json_result,TRUE); // yields......... Without cURL You'll have seen this all over the Internet as the accepted solution... Doesn't work for me because...

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

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

    above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the following XML node: 2 -> yields issue: PHP Warning: simplexml_load_string(): 2 in /home/public_html/my_folder/my_xml_processing_script.php on line 160...

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

  8. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    = preg_replace("/[^a-z0-9\_]/", "_",$v_Output); // replace any consecutive underscores to a single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_){2})\\2+#", "$2", trim($v_Output, "_")); // returns a string return $v_Output; }...

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

  9. Zoho Deluge: Convert Map to URL Parametershttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-map-to-url-parameters.html

    { l_UrlParams.add(v_Key.toString() + "=" + m_Payload.get(v_Key)); } info v_Endpoint + "?" + l_UrlParams.toString("&"); // yields...

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

  10. SSRS Display question mark when date is blankhttps://joellipman.com/component/content/article/ssrs-display-question-mark-when-date-is-blank.html?catid=75&Itemid=165

    moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  11. UNC Paths in Sharepoint 2007 linkshttps://joellipman.com/component/content/article/unc-paths-in-sharepoint-2007-links.html?catid=77&Itemid=165

    the link when you OK it if you are trying to enter a real UNC path: File://\\myServer\myShare\myFolder\myFile.doc -- yields file:////myServer/myShare/myFolder/myFile.doc

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

  12. Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, (...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  13. Convert seconds to total time in PHPhttps://joellipman.com/articles/cms/website-development/php/convert-seconds-to-total-time-in-php.html

    $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // yields // 82800 = 23:00:00 // 108000 = 30:00:00 On one line: $total_time=intval(intval($total_seconds)/...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 81 - 93 of 93