Showing posts with label Active. Show all posts
Showing posts with label Active. Show all posts

Saturday, 6 February 2016

How to Check MySQL Null on PHPIn Feburary 2016 06,

In Feburary 2016 06,
Open your PHP source file in a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to send a MySQL query to the active database. For example, '$result=mysql_query('Select my_var from my_table');'.
Use the 'mysql_fetch_assoc(result)' function inside a 'while' loop to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($result)) {'.
Use the 'is_null(variable)' function inside the 'while' loop to determine if a field from a returned row has a NULL value. For example, if (is_null($my_values['my_var'])) { echo 'is NULL'; } }' will print 'is NULL' for any values of 'my_var' that are NULL.
Save the PHP file.
In Feburary 2016 06,

How to Set FTP to Active ModeIn Feburary 2016 06,

In Feburary 2016 06,
Open the Filezilla FTP client.
Click 'File' and 'Site Manager.'
Select the FTP server you want to change to Active mode.
Click the 'Advanced' tab.
Change the transfer setting to 'Active Mode.' Click 'OK.' You can change advanced settings of Active mode, such as the port range used.
CuteFTP
Open CuteFTP. Click 'Tools' and 'Global Options.'
Click 'Transfer' in the sidebar option panel.
Change the 'Data Mode' field to 'Port' for active mode.
Click 'Apply' and 'OK.'
SmartFTP
Open SmartFTP.
Click 'Favorites' then 'Edit Favorites.'
Right-click the server that you wish to change to active mode.
Choose 'Properties.' Click 'Connection.'
Switch the mode to 'Port,' which is active mode.
In Feburary 2016 06,

Friday, 5 February 2016

How to Display Text From MySQL in PHPIn Feburary 2016 05,

In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,

Thursday, 4 February 2016

How to Fix the Ran Online Script ErrorIn Feburary 2016 04,

In Feburary 2016 04,
Click the 'Tools' menu in the Internet Explorer window.
Click the 'Internet Options' button.
Click on the 'Advanced' tab.
Click the 'Disable Script Debugging' tab.
Click the 'OK' button.
Unblock Active Scripting
Open Internet Explorer.
Click the 'Tools' button and then click the 'Internet Options' menu.
Click the 'Security' tab.
Click 'Default Level.'
Click the 'OK' button.
Remove Temporary Internet Files
Open Internet Explorer.
Click the 'Tools' button and then click 'Internet Options.'
Click on the 'General' tab. Click the 'Settings' button under the 'Temporary Internet Files' menu.
Click 'Delete' files and click 'OK.' Click the 'Delete Cookies' button and then click the 'OK' button.
Click the 'Clear History' button and then click 'Yes.' Click the 'OK' button.
In Feburary 2016 04,