Currently viewing the tag: "website"
Question: How to connect my simple website to a mysql database?
I need to connect my site to a mysql database with some php code. Is there any advice out there that could assist me? I have created my database tables but yet to implement, do i need to download mysql and implement the tables in mysql then connect to my site with some php code???
sorry but new to this, thanks in advance.
Answer:
Answer by MsTisay
is your website php base? if so then there should be a config.php on your files open it and enter your mysql database username, password and host.
www.developphp.com In this 8th video we will begin creating the dynamic product display page, and also discuss payment gateway shopping cart options. The E – Commerce Web Site we will be assembling is one in which all of the inventory is in a MySQL database and we offer a custom PHP cart for a unique shopping experience.
www.developphp.com In this 7th video we will dynamically render an always up-to-date “newest items” listing for the online store’s home page. The E – Commerce Web Site we will be assembling is one in which all of the inventory is in a MySQL database and we offer a custom PHP cart for a unique shopping experience.
Learn how to access your mysql database and have php render dynamic XML structure from the results. Script is here: www.developphp.com
Source Files – www.developphp.com Playlist for series – www.youtube.com In part 7 we build the page that is responsible for creating new pages into the PHP MySQL system. The form sends the data using a basic textarea. In a nice robust system you would implement a Javascript WYSIWYG Rich Text Editor in place of my textarea. Learn how to build custom content management systems using PHP and MySQL. Cool dynamic basic sites that anyone can edit.
Source Files – www.developphp.com Playlist for series – www.youtube.com In part 6 we create the administrator directory login form and use session variables to keep the admin logged in. To allow the admin to change their password you may want to consider storing the admin password and username in the mysql database. Learn how to build custom content management systems using PHP and MySQL. Cool dynamic basic sites that anyone can edit.
www.developphp.com In this 2nd video we will create the MySQL database and its tables. We demonstrate a scripted method for database table creation in this example. The E – Commerce Web Site we will be assembling is one in which all of the inventory is in a MySQL database and we offer a custom PHP cart for a unique shopping experience. It is a site that handles sales, customers, and inventory.
Display the data in a MySQL database table in a web page using PHP.
Learn best practices for securing your PHP and MySQL websites and applications. Here are the resources: php.net developer.yahoo.com www.phpfreaks.com phpsec.org
In this part of the lesson we create our MySQL database and quickly set up a default layout in Dreamweaver CS4, and tinker with the looks through CSS. Source Files – www.developphp.com
Question: What is a good application for designing a MySQL-driven website on Mac OS X?
I am developing a web site that allows users to search for information stored in a MySQL database on a Mac.
I am looking for an application to assist in the design of the web site, allowing me to create search forms to retrieve the data from a MySQL database on a Mac OS X computer.
I do not want to outsource this task or to have another company host it.
Any suggestions and/or advice will be appreciated.
Thanks.
Answer:
Answer by Anthony R
Dreamweaver is an application that will allow you to write code for a website that can access a MySQL database. But you will need a server to host the website as well as the database.
Question: How do users get permissions in MySql when they log into my website?
I have a MySql database set up called users. The only things required to register to my website are a username and password. When this is completed, the database populates with the users info as requested. How does MySql make this new users permissions to have it where they can now download files from my website? As of now anyone can download and take my sites files without logging in. How do I stop that also?
Thanks in advance for any help.
Answer:
Answer by rbjolly
Essentially what happens is you need to connect to the database through a scripting language to authenticate users. Once a user has logged in, you create a token, usually by creating a session, and then the user will have access to your file downloads.
The basic process is:
1. User logs in.
2. After login, a home page with links will load.
3. When user clicks on the download page, the download page will check to see if the user has a valid session, or token. If so, the user is granted access.
4. On the download page, file names will appear as links, but they should not link directly to the file. There should be an intermediate page that will take the file name and process the download (similar to the source link for Smart File Downloader).
I’ve included two links that show how a basic login script is done plus one to demo how to hide your download files so users can’t access them without logging in.