Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
PHP & mySQL Essentials

PHP & mySQL Essentials

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
45 cards
()
Section 1

Preview this deck

The default delimiter in mySQL that must be changed to bring in Excel CSV information

Front

1 / 45

PHPSQLWeb Dev
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (45)

Section 1

(45 cards)

The default delimiter in mySQL that must be changed to bring in Excel CSV information

Front

;

Back

A variable declared within a PHP function becomes ____ and can only be accessed within that function.

Front

Local

Back

Type this word in the address bar of any browser to get to phpMyAdmin

Front

localhost

Back

True or false: Spaces are acceptable in PHP variables

Front

false

Back

Given: echo strpos("ABCD", "A"); What is the resulting output?

Front

0

Back

loosely-typed

Front

Explicit data types are not required

Back

PHP is _____ source software

Front

open

Back

Command to print information on a web page

Front

echo

Back

______ scope refers to any variable that is defined outside of any function

Front

Global

Back

When a table's structure is being viewed, this shows that a field is a primary key

Front

The name of the field is underscored

Back

PHP is a _________ language

Front

server-side

Back

Single line comment syntax

Front

//blah blah blah

Back

Variables are _____ for storing information

Front

containers

Back

myFlavor is an example of

Front

camel case

Back

Extension for an 2010 Excel file

Front

xlsx

Back

Block comment synax

Front

/* blah blah blah */

Back

PHP concatenation operator

Front

.

Back

URL

Front

Uniform Resource Locator

Back

The _____ of a variable is the portion of the script in which the variable can be referenced

Front

scope

Back

An 'id' should be designated as a ______ ____ with ___________ enabled

Front

primary key ... auto increment

Back

Another name for parameter

Front

argument

Back

Every function must have

Front

a parameter list delimited by parentheses, even if that list is empty

Back

PHP is a ______ typed language

Front

loosely

Back

Typical mySQL datatype for an 'id'

Front

INT

Back

The 4 parameters, in the proper order, needed to connect to a PHP database

Front

host, userName, password, databaseName

Back

True or false: PHP strings may be delimited by either double or single quotes

Front

true

Back

Button you push in mySQL to bring in external data

Front

import

Back

Valuable platform integrating PHP and mySQL

Front

XAMPP

Back

PHP command name to tie in to a database

Front

mysqli_connect

Back

Shorthand delimiter for PHP code segments

Front

<? ?>

Back

What is mySQL?

Front

A database server

Back

PHP

Front

"PHP: Hypertext Preprocessor"

Back

Extension for PHP files

Front

php

Back

Make sure you do this to your Excel information before you convert to CSV file

Front

Make sure there are no commas in the entire sheet; if they are there, use global find/replace to make them something else you can change back to commas later using PHP

Back

To take an Excel file to a mySQL database, you must first convert it to a _____ file

Front

CSV

Back

Built-in function for finding the length of a string

Front

strlen

Back

Columns in Excel are analogous to _____ in mySQL

Front

fields

Back

Delimiter for PHP code segments

Front

<?php ?>

Back

CSV

Front

Comma-Separated Values

Back

True or false: PHP variables are case-sensitive

Front

true

Back

To create a user in PHPmyAdmin, to to this place

Front

PHPmyAdmin Home Page>Privileges

Back

A _______ is a local variable whose value is passed to the function by the calling code

Front

parameter

Back

Write a correct PHP statement that creates a variable called 'myFlavor' with the value of 'vanilla'

Front

$myFlavor = "vanilla";

Back

This is a character you can place before a PHP/mySQL command that will suppress warnings on a user's screen if there are connection problems to a database. It should NOT be used in development (you want to see your warnings!) but it should be used for live sites (so as not to scare your users).

Front

@

Back

True or false: PHP is considered a scripting language

Front

true

Back