Search - Joel Lipman .Com

1. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
2. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
3. JDatabase: using the Joomla database with examples: / Joomla /; ... , 'username')) ->from($db->quoteName('#__my_users')) ->where($db->quoteName('user_id').'=42'); $db->setQuery($query); $row = $db->loadRow(); -- using the data $this_name = $row[0 ...; Created on 27 January 2013
4. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... { $this_user_id=$row['UserID']; $this_user_full=$row['Fullname']; $this_user_query=str_replace("STRING_TO_REPLACE_PER_ITERATION", $this_user_id, $timesheet_query_per_user); $this_mon=$this_tue=$this_wed=$this_thu=$this_fri=$this_sat=$this_sun=$this_t=$this_t2=""; $sub_result=mysql_query($this_user_query); while($sub_row=mysql_fetch_assoc($sub_result)) ...; Created on 27 April 2012
5. Migrate Joomla Users to WordPress: / Wordpress /; This is for Joomla 1.5.x sites! Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot ...; Created on 03 October 2011
6. Difference between two dates - the midnight hour: / Web-Development /; ... as an example, the equation that's happening is: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 = date("H:i", strtotime($sub_row['TimeFromSession'])); $this_time_to1 ...; Created on 06 April 2011
7. PHP & MySQL Search Engine: / Personal Home Page /; ... = array(); $result = mysql_query($filter_sql); if ($result) { while($row=mysql_fetch_assoc($result)) { $row["Score"] = 0; foreach($terms_rx as $term_rx){ $row["Score"] += preg_match_all("/$term_rx/i", ...; Created on 09 March 2011
8. Creating a Top 10 chart with less code: / Personal Home Page /; ... create an array of search terms with their frequency count $search_table_results=mysql_query("SELECT DISTINCT column1 FROM table1"); while($row=mysql_fetch_assoc($search_table_results)) { $this_value=trim($row['column1']); $this_value_num=mysql_num_rows(mysql_query("SELECT ...; Created on 18 February 2010