SQL Helper Functions - Revision history

AlexN at 06:41, 18 June 2019

2019-06-18T06:41:50Z

2019-06-18T06:41:19Z

2016-01-05T09:37:56Z

2016-01-05T09:36:38Z

‎Information

2016-01-05T09:33:46Z

2015-11-05T14:49:50Z

‎Select Queries

2014-07-28T17:28:29Z

2013-07-10T11:17:38Z

2011-11-13T23:34:42Z

2011-11-13T21:13:47Z

‎Select Queries

← Older revision		Revision as of 06:41, 18 June 2019
Line 1:		Line 1:
−	~~#REDIRECT [[Interacting_With_The_Database]]~~
−
	<div class="docs-alert-info">		<div class="docs-alert-info">
	<span class="title">These Functions are Deprecated</span><br />		<span class="title">These Functions are Deprecated</span><br />

@@ Line 3: / Line 3: @@
 <div class="docs-alert-info">
 <span class="title">These Functions are Deprecated</span><br />
-Use [[Interacting_With_The_Database]] to run any custom queries.
+Use [https://developers.whmcs.com/advanced/db-interaction/ Interacting_With_The_Database] to run any custom queries.
 </div>

← Older revision		Revision as of 09:37, 5 January 2016
Line 1:		Line 1:
		+	#REDIRECT [[Interacting_With_The_Database]]
		+
	<div class="docs-alert-info">		<div class="docs-alert-info">
	<span class="title">These Functions are Deprecated</span><br />		<span class="title">These Functions are Deprecated</span><br />

@@ Line 7: / Line 7: @@
 ==Information==
-You can use the common PHP/MySQL mysql_query() syntax to perform your SQL queries & updates with that connection, but there are also some helper functions defined by the core of WHMCS that you can make use of to have escaping of input automatically taken care of. Use of these functions will also show an error in the Activity Log should a SQL error occur and you have the appropriate option enabled in your General Settings.
+Use common PHP/MySQL 'mysql_query()' syntax to perform custom SQL queries with the WHMCS connection. There are also helper functions defined in WHMCS. Use of these functions will escape the input passed so a developer does not need to. The functions will also show an Activity Log error should a SQL Error occur when enabled in General Settings.
 ==Select Queries==

← Older revision		Revision as of 09:33, 5 January 2016
Line 1:		Line 1:
−	In all WHMCS templates, custom pages and addon modules, there will always be an active database connection ~~established by WHMCS so you~~ never need to connect to the WHMCS database again within ~~your~~ custom code ~~- just~~ use the ~~already~~ existing connection.	+	<div class="docs-alert-info">
		+	<span class="title">These Functions are Deprecated</span><br />
		+	Use [[Interacting_With_The_Database]] to run any custom queries.
		+	</div>
		+
		+	In all WHMCS templates, custom pages and addon modules, there will always be an active database connection. There will never be a need to connect to the WHMCS database again within custom code. All developers should use the existing connection.

	==Information==		==Information==

@@ Line 41: / Line 41: @@
+}
 </source>
 ==Update Queries==

@@ Line 59: / Line 59: @@
 ==Insert Queries==
-'''Syntax: insert_query($table,$values)
+'''Syntax: insert_query($table,$values)'''
 Insert queries are the simplest of them all requiring just the table name and an array of fields to insert. This function call will return the ID of the newly created record.
@@ Line 68: / Line 68: @@
 $newid = insert_query($table,$values);
 </source>
 {{Developer_Links}}

@@ Line 1: / Line 1: @@
 In all WHMCS templates, custom pages and addon modules, there will always be an active database connection established by WHMCS so you never need to connect to the WHMCS database again within your custom code - just use the already existing connection.
-You can use the common PHP/MySQL mysql_query() syntax to perform your SQL queries & updates with that connection, but there are also some helper functions defined by the core of WHMCS that you can make use of to have escaping of input automatically taken care of.  These are used as follows.
+==Information==
 ==Select Queries==

← Older revision		Revision as of 23:34, 13 November 2011
Line 67:		Line 67:
	$newid = insert_query($table,$values);		$newid = insert_query($table,$values);
	</source>		</source>
		+
		+	{{Developer_Links}}

@@ Line 19: / Line 19: @@
 $id = $data['id'];
 $firstname = $data['firstname'];
-$firstname = $data['firstname'];
+$lastname = $data['lastname'];
 </source>