https://wiki.gotopinion.info/wiki/api.php?action=feedcontributions&feedformat=atom&user=Ptaylor 2026-04-21T07:01:04Z User contributions MediaWiki 1.43.1 https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=95 2007-07-23T04:55:47Z

<p>Ptaylor: /* Basic Syntax &amp; Commands */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text (&lt;nowiki&gt;' '&lt;/nowiki&gt;)<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | '''&lt;code&gt;mysql_affected_rows ( );&lt;/code&gt;'''<br /> | Returns number of rows affected for DELETE, INSERT, and UPDATE queries. MySQL tracks the number of rows that were affected.<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | '''&lt;code&gt;CURDATE()&lt;/code&gt;'''<br /> | returns current date<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> * Returns true (success) or false (failure) for most SQL queries. SELECT queries view data in db so it requires more than true or false.<br /> * With SELECT query mysql_query returns a number that identifies a '''result set''' which contains a list of all the rows (entries) returned from the query.<br /> * False is always returned if query fails.<br /> <br /> More example code:<br /> &lt;pre&gt;<br /> <br /> $result = @mysql_query ('SELECT column_name0, column_name1, ... FROM table_name');<br /> <br /> if ( !$result ) {<br /> <br /> die ('&lt;p&gt;Error performing query: ' . mysql_error() .<br /> <br /> '&lt;/p&gt;');<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=94 2007-07-23T04:55:31Z

<p>Ptaylor: /* Basic Syntax &amp; Commands */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text (&lt;nowiki&gt;''&lt;/nowiki&gt;)<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | '''&lt;code&gt;mysql_affected_rows ( );&lt;/code&gt;'''<br /> | Returns number of rows affected for DELETE, INSERT, and UPDATE queries. MySQL tracks the number of rows that were affected.<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | '''&lt;code&gt;CURDATE()&lt;/code&gt;'''<br /> | returns current date<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> * Returns true (success) or false (failure) for most SQL queries. SELECT queries view data in db so it requires more than true or false.<br /> * With SELECT query mysql_query returns a number that identifies a '''result set''' which contains a list of all the rows (entries) returned from the query.<br /> * False is always returned if query fails.<br /> <br /> More example code:<br /> &lt;pre&gt;<br /> <br /> $result = @mysql_query ('SELECT column_name0, column_name1, ... FROM table_name');<br /> <br /> if ( !$result ) {<br /> <br /> die ('&lt;p&gt;Error performing query: ' . mysql_error() .<br /> <br /> '&lt;/p&gt;');<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=93 2007-07-23T04:43:56Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | '''&lt;code&gt;mysql_affected_rows ( );&lt;/code&gt;'''<br /> | Returns number of rows affected for DELETE, INSERT, and UPDATE queries. MySQL tracks the number of rows that were affected.<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | '''&lt;code&gt;CURDATE()&lt;/code&gt;'''<br /> | returns current date<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> * Returns true (success) or false (failure) for most SQL queries. SELECT queries view data in db so it requires more than true or false.<br /> * With SELECT query mysql_query returns a number that identifies a '''result set''' which contains a list of all the rows (entries) returned from the query.<br /> * False is always returned if query fails.<br /> <br /> More example code:<br /> &lt;pre&gt;<br /> <br /> $result = @mysql_query ('SELECT column_name0, column_name1, ... FROM table_name');<br /> <br /> if ( !$result ) {<br /> <br /> die ('&lt;p&gt;Error performing query: ' . mysql_error() .<br /> <br /> '&lt;/p&gt;');<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=92 2007-07-22T21:36:11Z

<p>Ptaylor: /* mysql_query example */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | '''&lt;code&gt;mysql_affected_rows ( );&lt;/code&gt;'''<br /> | Returns number of rows affected for DELETE, INSERT, and UPDATE queries. MySQL tracks the number of rows that were affected.<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> * Returns true (success) or false (failure) for most SQL queries. SELECT queries view data in db so it requires more than true or false.<br /> * With SELECT query mysql_query returns a number that identifies a '''result set''' which contains a list of all the rows (entries) returned from the query.<br /> * False is always returned if query fails.<br /> <br /> More example code:<br /> &lt;pre&gt;<br /> <br /> $result = @mysql_query ('SELECT column_name0, column_name1, ... FROM table_name');<br /> <br /> if ( !$result ) {<br /> <br /> die ('&lt;p&gt;Error performing query: ' . mysql_error() .<br /> <br /> '&lt;/p&gt;');<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=91 2007-07-22T21:06:21Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | '''&lt;code&gt;mysql_affected_rows ( );&lt;/code&gt;'''<br /> | Returns number of rows affected for DELETE, INSERT, and UPDATE queries. MySQL tracks the number of rows that were affected.<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=90 2007-07-22T21:00:25Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=89 2007-07-22T20:59:55Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect(address, username, password);&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;mysql_query'''&lt;/code&gt;'''<br /> | Enables PHP to send MySQL queries to MySQL db<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> === mysql_query example ===<br /> <br /> Example code:<br /> &lt;pre&gt;<br /> <br /> mysql_query ( query, connection_id ) ;<br /> <br /> &lt;/pre&gt;<br /> <br /> * &lt;code&gt;query&lt;/code&gt; is a string that contains the SQL command we want to execute<br /> * &lt;code&gt;connection_id&lt;/code&gt; is optional parameter<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=88 2007-07-22T20:53:43Z

<p>Ptaylor: /* mysql_select_db example */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect(address, username, password);&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example basic code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> <br /> * The function contains the db identifier $dbcnx. This parameter is optional but I will use it for completeness. The function will default to the last connection opened.<br /> * Function returns true when it's successful and false if an error occurs.<br /> <br /> Example basic code with error handling:<br /> <br /> &lt;pre&gt;<br /> <br /> if (! @mysql_select_db('db_name', $dbcnx) ) {<br /> die ( '&lt;p&gt;Unable to locate the db_name ' .<br /> 'database at this time.&lt;/p&gt;' );<br /> }<br /> <br /> &lt;/pre&gt;<br /> <br /> * '''&lt;code&gt;die&lt;/code&gt;''' function works like '''&lt;code&gt;echo&lt;/code&gt;''' except the script exits after<br /> * Executing '''&lt;code&gt;die&lt;/code&gt;''' is equivalent to '''&lt;code&gt;echo&lt;/code&gt;''' followed by '''&lt;code&gt;exit&lt;/code&gt;'''<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=87 2007-07-22T20:34:17Z

<p>Ptaylor: </p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect(address, username, password);&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;mysql_select_db&lt;/code&gt;'''<br /> | Selects database table that PHP will use.<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> === mysql_select_db example ===<br /> <br /> After your code successfully connets to the MySQL db you must tell PHP which db table to use.<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> <br /> mysql_select_db ('db_name', $dbcnx );<br /> <br /> &lt;/pre&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=86 2007-07-22T20:28:53Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect(address, username, password);&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | '''&lt;code&gt;exit( );&lt;/code&gt;<br /> | Commands PHP to stop reading page.<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=85 2007-07-22T20:27:35Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | '''&lt;code&gt;mysql_connect(address, username, password);&lt;/code&gt;'''<br /> | Enables connection to MySQL database, returns a number that identifies the connection that has been established<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> <br /> === mysql_connect example ===<br /> <br /> Example code:<br /> <br /> &lt;pre&gt;<br /> $dbcnx = @mysql_connect ('db_hostname', 'db_user_name', 'db_user_password');<br /> <br /> if (!$dbcnx) {<br /> <br /> echo ( '&lt;p&gt;Unable to connect to the ' .<br /> <br /> 'database server at this time.&lt;/p&gt;' );<br /> <br /> exit ();<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> * The '@' symbol tells the function to fail silently which enables the coder to display your own message.<br /> * The '!' symbol flips the $dbcnx value. A returned number for $dbcnx is true (your code successfully connected to MySQL db. !$dbcnx means a successful db connection results in false and the &lt;code&gt;if&lt;/code&gt; statement would not execute. !$dbcnx means a failed db connection results in true and the &lt;code&gt;if&lt;/code&gt; statement would execute (print the custom error message).<br /> <br /> * exit() function causes php to stop reading the page<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=84 2007-07-22T19:44:53Z

<p>Ptaylor: </p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Array Variables ==<br /> <br /> Array variables useful to HTML<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! Array variable<br /> ! comment<br /> |-<br /> | $_GET<br /> | <br /> |-<br /> | $_POST<br /> |<br /> |-<br /> | $_REQUEST<br /> | <br /> |-<br /> | $_SERVER<br /> |<br /> |}<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=83 2007-07-22T19:41:14Z

<p>Ptaylor: /* Operators */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | !<br /> | negation operator or not operator, reverses a returned value from true to false or vice versa<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=82 2007-07-22T19:39:42Z

<p>Ptaylor: /* Functions */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | '''&lt;code&gt;echo&lt;/code&gt;'''<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | '''&lt;code&gt;isset&lt;/code&gt;'''<br /> | returns a value of true if the identified variable has a value<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=81 2007-07-22T19:25:17Z

<p>Ptaylor: /* User Interaction &amp; Forms */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | &lt;code&gt;echo&lt;/code&gt;<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Formats, tips, and suggestions for user interaction &amp; forms.<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> Web pages that can decide whether to display more than one pages is a '''multipurpose page'''.<br /> <br /> Sample multipurpose page in the HTML body tags:<br /> &lt;pre&gt;<br /> <br /> &lt;?php if ( condition ) { ?&gt;<br /> <br /> HTML content to display if condition is true<br /> <br /> &lt;?php } else { ?&gt;<br /> <br /> HTML content to display if condition is false<br /> <br /> &lt;?php } ?&gt;<br /> <br /> &lt;/pre&gt;<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=80 2007-07-22T19:06:11Z

<p>Ptaylor: </p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == Functions ==<br /> <br /> Functions are good for your health.<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! function syntax<br /> ! description<br /> |- <br /> | &lt;code&gt;echo&lt;/code&gt;<br /> | outputs data to browser<br /> |-<br /> | '''&lt;code&gt;urlencode&lt;/code&gt;'''<br /> | takes any special characters in a string (like spaces) &amp; converts them into special codes to appear in php query strings<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | blah<br /> | blah<br /> |-<br /> | <br /> | <br /> |-<br /> | blah<br /> | blah<br /> |}<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=79 2007-07-22T18:38:57Z

<p>Ptaylor: /* Control Structures */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> for loop<br /> &lt;pre&gt;<br /> <br /> for ( initialize; condition; update ) {<br /> <br /> statement(s) to execute repeatedly while condition is true<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=78 2007-07-22T18:36:00Z

<p>Ptaylor: /* Operators */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;<br /> <br /> == User Interaction &amp; Forms ==<br /> <br /> Variables can be separated in s query string by an ampersand (&amp;). You may use the ampersand multiple times.<br /> <br /> == Control Structures ==<br /> <br /> if-else statement<br /> <br /> &lt;pre&gt;<br /> if ( condition ) {<br /> <br /> executed if condition is true<br /> <br /> } else {<br /> <br /> executed if condition false<br /> &lt;/pre&gt;<br /> <br /> while loop<br /> <br /> &lt;pre&gt;<br /> while ( conditions ) {<br /> <br /> statements execute if true, then repeat, until false<br /> <br /> }<br /> &lt;/pre&gt;<br /> <br /> == Operators ==<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! operator<br /> ! meaning<br /> |-<br /> | and or &amp;&amp;<br /> | compares two conditions both must be true<br /> |-<br /> | or or &lt;nowiki&gt;||&lt;/nowiki&gt;<br /> | compares two and either must be true<br /> |-<br /> | ==<br /> | equal-to operator<br /> |-<br /> | !=<br /> | not equal<br /> |-<br /> | &lt;<br /> | less than<br /> |-<br /> | &gt;<br /> | greater than<br /> |-<br /> | &lt;=<br /> | less than or equal<br /> |-<br /> | &gt;=<br /> | greater than or equal<br /> <br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=73 2007-07-17T05:31:52Z

<p>Ptaylor: /* Arrays */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> <br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=72 2007-07-17T05:31:35Z

<p>Ptaylor: /* Arrays */</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |-<br /> | $array_name[1] = 'wiki1';<br /> | Assign a new value<br /> |-<br /> | $array_name[3] = 'wiki2';<br /> | Create a new element<br /> |-<br /> | $array_name[] = 'transformers';<br /> | Add element to end of array.<br /> |-<br /> | echo($array_name[4]);<br /> | Outputs &quot;transformers&quot;<br /> |}<br /> <br /> Arrays can use strings for indices. This is called an associative array because we can associate values with meaningful indices.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$weight['robert'] = 225;&lt;/code&gt;<br /> &lt;code&gt;$weight['gene'] = 180;&lt;/code&gt;<br /> &lt;code&gt;$weight['julie'] = 103;&lt;/code&gt;</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=71 2007-07-17T05:21:33Z

<p>Ptaylor: </p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation'''. Single quotes will not interpolate the variable name.<br /> <br /> == Arrays ==<br /> <br /> A special variable that contains multiple values.<br /> <br /> Simple format:<br /> <br /> &lt;code&gt;$array_name = array('test1', 'test2', 69);&lt;/code&gt;<br /> <br /> To retrieve a value stored in an array you need the '''index'''.<br /> <br /> Generally, arrays use incrementing integers that start with zero as their indices. Indices act as pointers to precisely locate a value in an array.<br /> <br /> Expanding on simple format:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! code<br /> ! comment<br /> |-<br /> | echo($array_name[0]);<br /> | Outputs 'test1'<br /> |-<br /> | echo($array_name[1]);<br /> | Outputs 'test2'<br /> |-<br /> | echo($array_name[2]);<br /> | Outputs 69<br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=70 2007-07-17T05:01:55Z

<p>Ptaylor: </p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}<br /> <br /> NOTE: Double quotes around text enables the variable name to be inserted &amp; value is displayed. This is called '''variable interpolation''' Single quotes will not interpolate the variable name.</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=PHP&diff=69 2007-07-17T04:53:40Z

<p>Ptaylor: New page: PHP is a server side scripting language. == Basic Syntax &amp; Commands == PHP statements are always terminated with semicolon (;). Single quotes are used to mark start and end of text (&#039;&#039;)...</p> <hr /> <div>PHP is a server side scripting language.<br /> <br /> == Basic Syntax &amp; Commands ==<br /> <br /> PHP statements are always terminated with semicolon (;).<br /> <br /> Single quotes are used to mark start and end of text ('')<br /> <br /> All variable names in PHP start with dollar sign ($).<br /> <br /> PHP is a loosely typed language. Variables may contain any type of data.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Semper Fidelis&quot;;&lt;/code&gt;<br /> <br /> Equal sign is called the '''assignment operator''' since it assigns values to variables.<br /> <br /> Comments begin with &lt;code&gt;//&lt;/code&gt; or &lt;code&gt;/* */&lt;/code&gt;<br /> <br /> arithmetic operators enable you to add, subtract, multiply, &amp; divide.<br /> <br /> concatenation operator allows you to add strings of text.<br /> <br /> Example:<br /> <br /> &lt;code&gt;$variable_name = &quot;Hello&quot; . &quot; there&quot; . &quot; world!&quot;;&lt;/code&gt;<br /> <br /> Assigns value of &quot;Hello there world!&quot; without quotes.<br /> <br /> Examples:<br /> <br /> {| border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;5&quot; align=&quot;center&quot;<br /> ! variable<br /> ! comment<br /> |- <br /> | $var1 = 'PHP';<br /> | Assigns value of &quot;PHP&quot; to var1<br /> |-<br /> | $var2 = 5;<br /> | Assigns value of 5 to $var2<br /> |-<br /> | $var3 = $var2 + 1;<br /> | Assigns value of 6 to $var3<br /> |-<br /> | $var2 = $var1;<br /> | Assigns value of &quot;PHP&quot; to $var2<br /> |-<br /> | echo($var1);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var2);<br /> | Outputs &quot;PHP&quot;<br /> |-<br /> | echo($var3);<br /> | Outputs 6<br /> |-<br /> | echo($var1 . ' rules!');<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo(&quot;var1 rules!&quot;);<br /> | Outputs &quot;PHP rules!&quot;<br /> |-<br /> | echo('var1 rules!');<br /> | Outputs '$var1 rules!'<br /> |}</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=Software&diff=68 2007-07-17T03:39:56Z

<p>Ptaylor: </p> <hr /> <div>[[Filezilla]] section<br /> <br /> [[MySQL]] section<br /> <br /> [[PHP]] section<br /> <br /> [[Vi]] section<br /> <br /> [[BASH shell]] section</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=MySQL_basics&diff=67 2007-07-17T03:39:25Z

<p>Ptaylor: </p> <hr /> <div>== Getting Started with MySQL ==<br /> <br /> === Connecting to MySQL ===<br /> To access a MySQL db you need:&lt;br&gt;<br /> - user name and password&lt;br&gt;<br /> - host name or IP&lt;br&gt;<br /> - name of db<br /> <br /> === Two ways to access MySQL directl ===<br /> <br /> * command line:<br /> ** telnet<br /> ** SSH (recommended due to enhanced security)<br /> * MySQL client programs [&lt;code&gt;mysql, mysqladmin, mysqldump&lt;/code&gt;]<br /> <br /> === To access a database from the command line ===<br /> <br /> &lt;code&gt;mysql -u username -ppassword -h hostname databasename&lt;/code&gt;<br /> <br /> Note: There is no space between the -p and the password. Password after -p is optional here. If left blank, you will be prompted to enter your password.<br /> <br /> === Using MySQL Client Programs ===<br /> <br /> Install the client programs<br /> <br /> == Basic Commands ==<br /> <br /> Virtually all commands are terminated with a semicolon.<br /> The prompt '-&gt;' means MySQL is waiting for more instructions or the semicolon is missing.&lt;br&gt;<br /> <br /> Cancel current command &lt;code&gt;\c&lt;/code&gt; and press Enter.&lt;br&gt;<br /> <br /> MySQL will ignore anything in a command that ends with &lt;code&gt;\c&lt;/code&gt; and go back to beginning.<br /> <br /> Type &lt;code&gt;exit&lt;/code&gt; or &lt;code&gt;quit&lt;/code&gt; and press Enter anytime you want to exit. These commands do not require a semicolon.<br /> <br /> &lt;code&gt;show databases;&lt;/code&gt;<br /> <br /> &lt;code&gt;drop database &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;create database &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;use &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;show &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;describe &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;drop table &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> == Inserting data into a table ==<br /> <br /> &lt;code&gt;INSERT&lt;/code&gt; : used to set column values<br /> <br /> Two formats:<br /> <br /> <br /> INSERT INTO table_name SET<br /> <br /> -&gt; columnName1 = value1,<br /> <br /> -&gt; columnName2 = value2,<br /> <br /> -&gt; etc...<br /> <br /> -&gt;;<br /> <br /> OR<br /> <br /> INSERT INTO table_name<br /> -&gt; (columnName1, columnName2, etc...)<br /> -&gt; VALUES (value1, value2, etc...);<br /> <br /> == Viewing stored data ==<br /> <br /> &lt;code&gt;SELECT&lt;/code&gt; : used to view column data<br /> <br /> mysql&gt;SELECT * FROM table_name;<br /> <br /> mysql&gt;SELECT columnName1, columnName2, ... FROM table_name;<br /> <br /> == Modify Columns with Functions ==<br /> <br /> Functions:<br /> <br /> LEFT : displays maximum number of characters per column<br /> <br /> COUNT : count the number of results returned<br /> <br /> WHERE Clause<br /> <br /> LIKE : named column must contain the given pattern match<br /> <br /> == Modify Stored Data ==<br /> <br /> &lt;code&gt;UPDATE&lt;/code&gt; command : modifies and views data <br /> <br /> general format:<br /> <br /> mysql&gt; UPDATE table_name SET<br /> -&gt; column_name = new_value, ...<br /> -&gt; WHERE conditions;<br /> <br /> == Delete Stored Data ==<br /> <br /> WARNING: Deleting data is easy.<br /> <br /> &lt;code&gt;DELETE&lt;/code&gt; : Deletes stored data<br /> <br /> general format:<br /> <br /> mysql&gt; DELETE FROM table_name WHERE conditions;<br /> <br /> NOTE: You more than likely want to a WHERE condition in all situations. If you use &quot;DELETE FROM table_name&quot; without conditions your table will be empty in one command.</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=MySQL_basics&diff=66 2007-07-17T03:22:31Z

<p>Ptaylor: /* Inserting data into a table */</p> <hr /> <div>== Getting Started with MySQL ==<br /> <br /> === Connecting to MySQL ===<br /> To access a MySQL db you need:&lt;br&gt;<br /> - user name and password&lt;br&gt;<br /> - host name or IP&lt;br&gt;<br /> - name of db<br /> <br /> === Two ways to access MySQL directl ===<br /> <br /> * command line:<br /> ** telnet<br /> ** SSH (recommended due to enhanced security)<br /> * MySQL client programs [&lt;code&gt;mysql, mysqladmin, mysqldump&lt;/code&gt;]<br /> <br /> === To access a database from the command line ===<br /> <br /> &lt;code&gt;mysql -u username -ppassword -h hostname databasename&lt;/code&gt;<br /> <br /> Note: There is no space between the -p and the password. Password after -p is optional here. If left blank, you will be prompted to enter your password.<br /> <br /> === Using MySQL Client Programs ===<br /> <br /> Install the client programs<br /> <br /> == Basic Commands ==<br /> <br /> Virtually all commands are terminated with a semicolon.<br /> The prompt '-&gt;' means MySQL is waiting for more instructions or the semicolon is missing.&lt;br&gt;<br /> <br /> Cancel current command &lt;code&gt;\c&lt;/code&gt; and press Enter.&lt;br&gt;<br /> <br /> MySQL will ignore anything in a command that ends with &lt;code&gt;\c&lt;/code&gt; and go back to beginning.<br /> <br /> Type &lt;code&gt;exit&lt;/code&gt; or &lt;code&gt;quit&lt;/code&gt; and press Enter anytime you want to exit. These commands do not require a semicolon.<br /> <br /> &lt;code&gt;show databases;&lt;/code&gt;<br /> <br /> &lt;code&gt;drop database &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;create database &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;use &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;show &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;describe &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;drop table &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> == Inserting data into a table ==<br /> <br /> Two formats:<br /> <br /> <br /> INSERT INTO table_name SET<br /> <br /> -&gt; columnName1 = value1,<br /> <br /> -&gt; columnName2 = value2,<br /> <br /> -&gt; etc...<br /> <br /> -&gt;;<br /> <br /> OR<br /> <br /> INSERT INTO table_name<br /> -&gt; (columnName1, columnName2, etc...)<br /> -&gt; VALUES (value1, value2, etc...);<br /> <br /> <br /> mysql&gt;SELECT * FROM table_name;<br /> <br /> mysql&gt;SELECT columnName1, columnName2, ... FROM table_name;<br /> <br /> == Modify Columns with Functions ==</div>

Ptaylor https://wiki.gotopinion.info/wiki/index.php?title=MySQL_basics&diff=65 2007-07-17T02:53:50Z

<p>Ptaylor: </p> <hr /> <div>== Getting Started with MySQL ==<br /> <br /> === Connecting to MySQL ===<br /> To access a MySQL db you need:&lt;br&gt;<br /> - user name and password&lt;br&gt;<br /> - host name or IP&lt;br&gt;<br /> - name of db<br /> <br /> === Two ways to access MySQL directl ===<br /> <br /> * command line:<br /> ** telnet<br /> ** SSH (recommended due to enhanced security)<br /> * MySQL client programs [&lt;code&gt;mysql, mysqladmin, mysqldump&lt;/code&gt;]<br /> <br /> === To access a database from the command line ===<br /> <br /> &lt;code&gt;mysql -u username -ppassword -h hostname databasename&lt;/code&gt;<br /> <br /> Note: There is no space between the -p and the password. Password after -p is optional here. If left blank, you will be prompted to enter your password.<br /> <br /> === Using MySQL Client Programs ===<br /> <br /> Install the client programs<br /> <br /> == Basic Commands ==<br /> <br /> Virtually all commands are terminated with a semicolon.<br /> The prompt '-&gt;' means MySQL is waiting for more instructions or the semicolon is missing.&lt;br&gt;<br /> <br /> Cancel current command &lt;code&gt;\c&lt;/code&gt; and press Enter.&lt;br&gt;<br /> <br /> MySQL will ignore anything in a command that ends with &lt;code&gt;\c&lt;/code&gt; and go back to beginning.<br /> <br /> Type &lt;code&gt;exit&lt;/code&gt; or &lt;code&gt;quit&lt;/code&gt; and press Enter anytime you want to exit. These commands do not require a semicolon.<br /> <br /> &lt;code&gt;show databases;&lt;/code&gt;<br /> <br /> &lt;code&gt;drop database &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;create database &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;use &lt;db_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;show &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;describe &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> &lt;code&gt;drop table &lt;table_name&gt;;&lt;/code&gt;<br /> <br /> == Inserting data into a table ==<br /> <br /> INSERT INTO table_name SET<br /> <br /> -&gt; columnName1 = value1,<br /> <br /> -&gt; columnName2 = value2,<br /> <br /> -&gt; etc...<br /> <br /> -&gt;;</div>

Ptaylor