Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Computer Programming: HTML, PHP, MySQL

memorize.ai (lvl 286)

(0)

92 cards

()

Section 1

Preview this deck

$=_____;

Front

1 / 92

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (92)

Section 1

(50 cards)

$=_____;

Front

Assign a data to a variable

Back

</ >

Front

closing/ ending tag

Back

•<h1> </h1> •<h2> </h2> •<h3> </h3> •<h4> </h4> •<h5> </h5> •<h6> </h6>

Front

heading tag

Back

show database;

Front

shows all data bases

Back

<input type='radio' name=' ' value=' '> text

Front

radio input type format and attribute

Back

<?php (opening) ?> (closing)

Front

PHP structure/ script

Back

<ol> </ol>

Front

ordered list tag

Back

<a> </a>

Front

•anchor tag •link

Back

<input type='text' name=' ' value=' ' size=' ' placeholder=' '> •readonly •disabled •required

Front

title input type format and attribute

Back

exit

Front

close mysql

Back

<!DOCTYPE html> <html> <head> </head> <body> </body> </html>

Front

HTML structure

Back

<p> </p>

Front

paragraph tag

Back

My Structured Query Language

Front

meaning of mysql

Back

•Personal Home Page •PHP: Hypertext Preprocessor

Front

meaning of PHP

Back

•$=$_POST[' ']; •$=$_GET[' '];

Front

get data from HTMl form

Back

•> -greater than •< -less than •>= -greater than equal to •<= -less than equal to •== -equal to •=== -identical to •!== -not equal to •!=== - not identical to

Front

Rational Expressions

Back

echo' '

Front

display text in php

Back

<table> </table>

Front

table tag

Back

width=' '

Front

table heading/data attribute

Back

<ul> </ul>

Front

unordered list tag

Back

$a=____; (variable or number) •+ (add) •- (subtract) •* (multiply) •/ (divide) •% (modulo, get remainder)

Front

mathematical equation in PHP

Back

•border=' ' ~table border

Front

table tag attribute

Back

<input type='password' name=' ' size=' '> •readonly •disabled •required

Front

password input type format and attribute

Back

•src=' ' ~source attribute ~source of picture (eg. pic.jpg) •width=' ' ~indicate width (eg. 45 px or 45%) •height=' ' ~indicate height (eg. 45 px or 45%) •alt=' ' ~alternative text ~appears when image cant be displayed •title=' ' ~title attribute ~provides title for image

Front

image tag attributes

Back

<img/>

Front

image tag

Back

<form> </form>

Front

form tag

Back

<hr>

Front

horizontal rule

Back

<td> </td>

Front

table data tag

Back

<tr> </tr>

Front

table row tag

Back

<input type='submit' value=' '>

Front

submit input type format and attribute

Back

•action=' ' ~transfer data to php •method=' ' ~get(data seen in url) ~post(private)

Front

form tag attributes

Back

•text •password •radio •checkbox •select •submit

Front

form input type

Back

< /> or < >

Front

empty tag

Back

<th> </th>

Front

table heading tag

Back

mysql -p

Front

open mysql

Back

•if( )..... -if true,operate, if not,disregard •if( ).....else..... -if true, operate, if not, operate 2nd choice •if( ).....elseif( )....else..... -it has multiple choice

Front

Condition Statements

Back

<title> </title>

Front

•title tag •tag for title bar

Back

•href=' ' ~hyperlink reference ~location of file

Front

anchor tag attributes

Back

<li> </li>

Front

list item tag

Back

<audio> •autoplay •controls <source src=' ' type='audio/ '> </audio>

Front

audio tag format and attributes

Back

order of importance: 1=most important 6= least important

Front

why are there different types of heading tags

Back

<select name=' '> <option value=' '> </option> </select>

Front

select format and attribute

Back

Hyper Text Markup Language

Front

meaning of HTML

Back

< >

Front

opening/ startingtag

Back

<!DOCTYPE HTML>

Front

declaration of document type (html)

Back

< >______</ >

Front

content tag

Back

<input type='checkbox' name=' ' value=' '> text

Front

checkbox input type format and attribute

Back

<br>

Front

line break

Back

<video> •width=' ' •height=' ' •autoplay •controls <source src=' ' type='video/ '> </video>

Front

video tag format and attributes

Back

•while( )..... -itu •do.....while( )..... -iut •for( ) -itu

Front

Loop Statements

Back

Section 2

(42 cards)

truncate table (table name);

Front

reset auto_ increment

Back

insert into table name (field name, time, date name)values('content',curtime( ),curdate( ));

Front

insert record in table

Back

update table name set fieldname=data where fieldname =data ;

Front

update a data

Back

.$row['fieldname'].

Front

insert data

Back

show tables;

Front

shows all tables in one database

Back

mysql_select_db("database name",connectvariable);

Front

select a database in mysql using php

Back

describe name of table;

Front

show table structure

Back

Record

Front

a collection of related fields

Back

$_SESSION['name'];

Front

session variable

Back

session_destroy( );

Front

end a session

Back

select * from table name;

Front

show all records from table

Back

mysql_fetch_array( )

Front

to get data

Back

Field

Front

A single piece of data

Back

$_SESSION['name']=$_;

Front

Assign a value to a session variable

Back

alter table table name add fieldname variable type (length of value);

Front

add field

Back

use name of database;

Front

opens or creates database

Back

update table name set fieldname = data ;

Front

update or change value in field

Back

•Array •Stack

Front

2 systematic arrangement

Back

select * from database order by fieldname ;

Front

sort by ascending order

Back

select fieldname from table name;

Front

show all records from field

Back

mysql_connect("localhost","username","password");

Front

connect to mysql using php

Back

Database

Front

An organized collection of data; can be manual or computerized

Back

auto_increment

Front

assign data to a unique number, starts from 1

Back

Array

Front

Systematic Arrangement: first in last out

Back

Stack

Front

Systematic Arrangement: first out last in

Back

select * from tablename limit # ;

Front

how many to display

Back

alter table table name change fieldname new name variable type (#);

Front

modify field

Back

mysql_query(" ");

Front

execute a mysql command in php

Back

database

Front

2 or more tables

Back

alter table table name modify field name definition (#);

Front

change maximum value of a field

Back

die("could not connect:".mysql_error( ))

Front

crash server

Back

alter table table name add primary key fieldname; alter table table name add auto_increment fieldname;

Front

add primary key or auto_increment

Back

alter table table name drop fieldname;

Front

deletes field

Back

select * from database where fieldname RO number;

Front

display all data that is ro number

Back

select * from database order by fieldname desc;

Front

sort by descending order

Back

alter table table name rename to new name;

Front

rename table

Back

Table

Front

2 or more records

Back

select * from database where fieldname;

Front

show all records from field

Back

mysql_num_row( )

Front

count rows on selected table in mysql using php

Back

session_start( );

Front

start a session

Back

create table table name ( fieldname variable type (length of value) ); •primarykey •auto_increment

Front

create table and fields

Back

delete from table name where fieldname= data ;

Front

delete record

Back