ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Creating A Server Database

Updated on June 29, 2020
A server can help you navigate a maze of information on your computer website or database.
A server can help you navigate a maze of information on your computer website or database.

Setting Up A Server

If you wish to line up your local testing server and are new server-side programming start with AMP which stands for Apache mySQL Server and PHP this is often the foremost common trio of web server database server application server you will find amp at the majority hosting companies and it's great it is a great foundation for server-side programming even better it is simple to line abreast of both Windows and Mac PC's.

For Windows WAMP may be a simpler installer that puts Apache mySQL Server and PHP on your computer it's free and works with Windows 7, 8, 10, Vista, and XP and you'll be able to find it at wampserver.com/EN. Because they alter somewhat frequently you will find instructions that match the changes to the WAMP installer at www.uptospeedguides.com/mamp.

For Macs, MAMP provides a straightforward thanks to getting Apache mySQL Server and PHP up and running MAMP is free and available from www.mamp.info the MAMP software changes as does its website frequently so ensure to urge the foremost up-to-date directions at up to speedguides.com/mamp. If you propose to follow together with the tutorials during this section download install WAMP or Mamp now. If you follow the previous instructions installed a testing center on your computer you've already visited a web page at either HTTP:/ Localhost or HTTP:/ /localhost slash MAMP the house pages for WAMP & MAMP respectively. You'll be wondering what's this local hosting? For computer localhost is simply otherwise of claiming to quote me.” after you instruct a browser to travel to HTTP simple:/ /localhost, you're merely telling it to appear for an internet server that's running on the identical computer because it is. Normally, once you visit a website, you'll see web an address like HTTP://www.google.com which sends you your browser out over the net searching for an online page located on some computer identified as www.google.com. After you created an online server on your computer, and you would like to look at the net pages you created there your browser needs look no further than your system, and its web server a period K. A period that testing server you founded earlier.

But once the browser asks your local testing server for an online page, where does the server find that page on your computer? Once you work with static web content just like the one you built earlier during this book, you'll keep your website files just about anywhere you want: on your desktop, in your documents folder, on an external drive, and so on.

Dynamic pages, on the opposite hand, work only with the assistance of an online server and its companions, the appliance in database servers. Because it's to coordinate the work of those machines, the web server expects files for a website to reside in an exceedingly particular location on your computer. That folder is named the positioning root folder you'll also hear it stated because of the document root folder. The precise name and placement of the positioning folder may vary from web hosting company to web hosting company which could name the folder htdocs, web docs, or public underscore HTML. WAMP uses a folder named www.asthesiteroot C: slash WAMP slash WWW as an example while MAMP uses a folder called htdocs; Head over to applications so MAMP so htdocs.

In the case of WAMP, if you would like to type HTTP: slash slash localhost slash my name underscore page dot HTML into your browser the browser requests a file named my underscore page dot HTML from the net page running on your computer. The server then looks inside C: backslash program files backslash WAMP backslash www.fourafilenamedmyunderscorepage.html; If it finds,s it, the server sends the file back to the browser. On a Mac running Mamp, the net server looks in an application, and so MAMP and so htdocs for the file my underscore page dot HTML.

Getting Started

server diagram
server diagram

MySQL

Creating A Server and Database and UI/UX Design

Creating a server creates a database that can store all your files code images and other data like usernames passwords comments and everything else associated with your website. Adobe Dreamweaver allows you to easily connect to the apache server which is php and other web stuff (web server), and MySQL server which is your actual database server for the website and will create a local database for the website, and after connecting Dreamweaver to the servers one can access your php files and use MySQL connection.

Once you have your database up and running you can allow for people to sign in to your account and be able to keep their information private and secure. And storing all this on a database will allow you to access someone’s password if they forgot and send them an email to change it or ask them a security question and send them a link to view their password if they don’t want to change it and to make it more secure make the link expire after a day or so it can’t be access by a malicious third party. You can also interact with your users and find out what they like and dislike through a survey or feedback on a service and find out what is working and what is not working with the user base or audience for your website which will help you to make your website more user friendly thus improving the UI/UX design.

What the #$%@ is UX Design?

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://corp.maven.io/privacy-policy

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)