CISM4157 Assignment | Complete Solution
- ExpertT
- Rating : 109
- Grade : A+
- Questions : 1
- Solutions : 1026
- Blog : 0
- Earned : $53187.54
INSTRUCTIONS: Complete the table below by providing an explanation of what the PHP and SQL keyword/phrase does and provide an example of how the code is used.
# |
PHP Keyword/ phrase |
Explanation |
Example |
Chapter 8 |
|||
i.e. |
<?php … ?> |
The PhP tags allow for code within the tags to be interpreted and executed, while any PHP code outside the tags will not work |
<?php echo ”Hello World!” ?> |
1 |
# AND /* … */ |
|
|
2 |
$ |
|
|
3 |
define(name,value) |
|
|
4 |
echo |
|
|
5 |
include AND include_once |
|
|
6 |
require AND require_once |
|
|
7 |
if…else AND if…elseif |
|
|
8 |
switch…case |
|
|
9 |
while AND do…while |
|
|
10 |
for |
|
|
11 |
function |
|
|
Chapter 9 |
|||
12 |
array()
|
|
|
13 |
foreach |
|
|
Chapter 10 |
|||
14 |
class {} |
|
|
15 |
$this à property |
|
|
16 |
private |
|
|
17 |
extends |
|
|
# |
SQL Keyword/ phrase |
Explanation |
Example |
i.e. |
AS |
The SQL keyword AS is used when creating a column alias to rename column headings. The alias follows immediately after the original column name and before the new column name. |
SELECT ID AS "Student ID", Status AS "Class Status" FROM student_table; |
18 |
CREATE TABLE |
|
|
19 |
ALTER TABLE |
|
|
20 |
MODIFY/ CHANGE |
|
|
21 |
INSERT |
|
|
22 |
UPDATE |
|
|
23 |
DELETE |
|
|
24 |
DROP TABLE |
|
|
25 |
SELECT…WHERE |
|
|
26 |
ORDER BY |
|
|
27 |
COUNT() |
|
|
28 |
SUM()/ AVG () |
|
|
29 |
MIN()/ MAX() |
|
|
30 |
GROUP BY AND GROUP BY…HAVING |
|
|
[Solved] CISM4157 Assignment | Complete Solution
- This Solution has been Purchased 2 time
- Submitted On 17 Mar, 2015 01:09:47
- ExpertT
- Rating : 109
- Grade : A+
- Questions : 1
- Solutions : 1026
- Blog : 0
- Earned : $53187.54
This Tutorial is rated A+ p...
CISM4157 Assignment Complete Solution
CISM4157 Assignment / Complete Solution/A++ WORK
CISM4157 Assignment | Complete Solution
This Tutorial is rated A+ previously,if you have any questions regarding this tutorial then you can contact me.
...