In Feburary 2016 26,
Open MySQL monitor and log in with your username and password.
Select the database you wish to update. For example, to use the database named TARDIS, type in the following at the command prompt:use TARDIS;
Type in the SQL statement to update your column. To update the Date column of a table named 'Destination' where the Location is equal to 'Gallifrey' you can use the following SQL statement:UPDATE DestinationSET Date='2011-11-11'WHERE Location='Gallifrey';If updating more than one column, for example 'Date' and 'Time,' you can use the following statement:UPDATE DestinationSET Date='2011-11-11', Time='11:11:11'WHERE Location='Gallifrey';
Press Enter to submit the changes.
Update Columns Using phpMyAdmin
Open phpMyAdmin and log in.
Click the name of the database you wish to update columns for.
Find the table you'd like to change, and click on the 'Browse' icon next to it.
Put a check mark on all the records that need to be updated and click on the pencil icon or the 'Change' icon.
Edit the text on all the columns you wish to update and click on 'Go.'
In Feburary 2016 26,
Showing posts with label update. Show all posts
Showing posts with label update. Show all posts
Friday, 26 February 2016
Thursday, 25 February 2016
How to Edit a Live PHP Site via FTPIn Feburary 2016 25,
In Feburary 2016 25,
Open File Explorer or Internet Explorer: both programs access the built-in FTP client.
Type the site's host server FTP url into the address bar and press 'Enter.' The FTP address starts with 'FTP://' instead of 'HTTP://" like a website. ExampleSite.com might have its FTP server located at a URL like 'FTP://adminFTP.ExampleSite.com.'
Enter your client account user name and password then press 'OK' to log in to the FTP.
Locate the PHP files you want to update in the FTP browser window. The FTP browser window displays the files on the FTP server like File Explorer displays local files on your computer or home network.
Copy the PHP files you want to update to your computer by highlighting them in the browser window, pressing 'Ctrl+C,' opening a local folder Window in File Explorer and pressing 'Ctrl+V.' You can edit the copy of the file stored on your computer, but you can't edit the one stored on the FTP site.
Open the PHP files you want to edit with Notepad or a code editing program, make the changes you want to make in the code and save the updated file.
Highlight the updated versions of the files you want to update on the PHP site in the File Explorer window and press 'Ctrl+C' to copy them.
Open the FTP window, locate the folder hosting the files you want to update and press 'Ctrl+V' to upload the files to the FTP. If Windows asks, choose the option that overwrites and replaces the files. The new versions of the files will immediately display on the site when refreshing the page.
In Feburary 2016 25,
Open File Explorer or Internet Explorer: both programs access the built-in FTP client.
Type the site's host server FTP url into the address bar and press 'Enter.' The FTP address starts with 'FTP://' instead of 'HTTP://" like a website. ExampleSite.com might have its FTP server located at a URL like 'FTP://adminFTP.ExampleSite.com.'
Enter your client account user name and password then press 'OK' to log in to the FTP.
Locate the PHP files you want to update in the FTP browser window. The FTP browser window displays the files on the FTP server like File Explorer displays local files on your computer or home network.
Copy the PHP files you want to update to your computer by highlighting them in the browser window, pressing 'Ctrl+C,' opening a local folder Window in File Explorer and pressing 'Ctrl+V.' You can edit the copy of the file stored on your computer, but you can't edit the one stored on the FTP site.
Open the PHP files you want to edit with Notepad or a code editing program, make the changes you want to make in the code and save the updated file.
Highlight the updated versions of the files you want to update on the PHP site in the File Explorer window and press 'Ctrl+C' to copy them.
Open the FTP window, locate the folder hosting the files you want to update and press 'Ctrl+V' to upload the files to the FTP. If Windows asks, choose the option that overwrites and replaces the files. The new versions of the files will immediately display on the site when refreshing the page.
In Feburary 2016 25,
Monday, 1 February 2016
How to Set Permissions in Go DaddyIn Feburary 2016 01,
In Feburary 2016 01,
Open a Web browser window, navigate to the GoDaddy.com home page, log into your account and then click the 'My Account' link.
Click the 'Web Hosting' link within the 'Products' section and then click the 'Launch' link adjacent to the name of the hosting account you want to update.
Click the 'File Manager' link within the 'Content' section.
Select one or more directories, click the 'Permissions' icon and then click 'Advanced.'
Uncheck the 'Read' box to prevent public access to the directory, or check the box to re-enable public access if you disabled it previously.
Uncheck the 'Write' box to prevent users from writing to files in the directory, or check the box to re-enable writing access if you disabled it previously.
Uncheck the 'Execute (Directory)' box to prevent users from executing scripts within the directory, or check the box to re-enable script access if you disabled it previously.
Click 'OK' to confirm your choices.
Set Permissions on a Windows Server
Open a Web browser window, navigate to the GoDaddy.com home page, log into your account and then click the 'My Account' link.
Click the 'Web Hosting' link within the 'Products' section and then click the 'Launch' link adjacent to the name of the hosting account you want to update.
Click the 'IIS Settings' link within the 'Content' section.
Select one or more directories and then click 'Edit.'
Uncheck the 'Anonymous Access' box to prevent public access to the selected directories, or check the box to re-enable public access if you disabled it previously. In either case, click 'OK' to confirm your choice.
In Feburary 2016 01,
Open a Web browser window, navigate to the GoDaddy.com home page, log into your account and then click the 'My Account' link.
Click the 'Web Hosting' link within the 'Products' section and then click the 'Launch' link adjacent to the name of the hosting account you want to update.
Click the 'File Manager' link within the 'Content' section.
Select one or more directories, click the 'Permissions' icon and then click 'Advanced.'
Uncheck the 'Read' box to prevent public access to the directory, or check the box to re-enable public access if you disabled it previously.
Uncheck the 'Write' box to prevent users from writing to files in the directory, or check the box to re-enable writing access if you disabled it previously.
Uncheck the 'Execute (Directory)' box to prevent users from executing scripts within the directory, or check the box to re-enable script access if you disabled it previously.
Click 'OK' to confirm your choices.
Set Permissions on a Windows Server
Open a Web browser window, navigate to the GoDaddy.com home page, log into your account and then click the 'My Account' link.
Click the 'Web Hosting' link within the 'Products' section and then click the 'Launch' link adjacent to the name of the hosting account you want to update.
Click the 'IIS Settings' link within the 'Content' section.
Select one or more directories and then click 'Edit.'
Uncheck the 'Anonymous Access' box to prevent public access to the selected directories, or check the box to re-enable public access if you disabled it previously. In either case, click 'OK' to confirm your choice.
In Feburary 2016 01,
Subscribe to:
Comments (Atom)