Using A DB In A Website
I want to create a website where users can select (from a dropdown box) and then view various PDF files. I also need the capability to upload and store these PDF's.
What's the best way to accomplish this?
View Complete Forum Thread with Replies
Related Forum Messages:
Creating A Website Forum: Use Existing Website MySQL Db Or Create A Second Db?
I am getting ready to start coding my own forum.... to seemlessly integrate it into my existing website. My question is this; should I: a) create the new forum tables in my existing database (used for the website user accounts etc.), OR b) create the new forum tables in a separate new database (it would be on the same server with same u/n p/w) Which one is the better option? I've been banging my head over trying to decide which way to go...
View Replies !
MySQL On A Website
I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL.
View Replies !
Website Error
I have image hosting website. When I type in the the website name in the address bar of the browser, I get the following error: Couldn't connect to database server: Access denied for user: 'imgbiz@linhost120.prod.mesa1.secureserver.net' (Using password: YES) I am not very familiar with PHP or MySQL. Could someone let me know if it makes any sense or what I should be doing to correct this error? (it would help if someone might have had this error and resolved it, could help me out here) I have changed the username, because it was much more easier to remember. Does this cause any problems in the website being displayed? I have changed it going through phpMyAdmin/admin. Is there any other file that I need to change this information so that it works?
View Replies !
HOW DO I USE MYSQL WITH MY WEBSITE?
I have an existing website with Netfirms and it comes with "mysql" "php" etc. It is active and have been able to confirm that with tech support. I purchased two books regarding "php & mysql for dummies" and "biginning php5,Apache, mysql Web development" and still I donot have a clear understanding of how to write a script that will allow a website user to interact and or collect information and display information on the website page. I mean this is what it is all about right? Can someone please just give me an example that I can follow on how to actually creat a script to allow mysql to interact with a webpage. And while your add it. whats a good learning tool, book etc to have?
View Replies !
How Do I Set The Tables For My Website
I have usually done my websites with Access and all I had to do was transfer a MDB file, and put the path in the data connection and it was working. How do I do this with mySQL? Do I upload a file(s) and change the datapath or??? I am using ASP (not .NET) and the server is hosted elsewhere by a local company.
View Replies !
Website & Intranet - 1 DB Or 2?
I've been working on our company intranet for some time now and it's finally (more or less) been completed. The next phase is working on our internet website. The website will offer merged functionality (ie online quoting that is available to employees on the intranet, etc) and I was wondering the best way to tackle this project. My first thought is that the databases should be separate. That is, one for the intranet, one for the website. If at such time I need to gather data from both I can run a query and simply select the database to use. My question is: is there a reason that I should use two separate databases instead of just using separate tables - besides perhaps the fact it might be easier to manage? If anyone out there has done similar in the past, what did you find out/learn? As mentioned, some of the functionality will cross. For example, when a potential client enters information to be provided a quote, that information, based on certain characteristics (name, etc) will be made available to certain employees for the purposes of quoting and providing that quote to the applicant. I can see where I would need to be able to use information from both databases to run a query for this, so it might be easier if it's all in one table. However, there will be personal information so security is of concern also. Does using two separate dbs help in this regard? Either way, there are security measures in place to protect the integrity of the data but I'm curious if this "extra" layer is necessary. (This is a php/mysql integration btw which may have been obvious.)
View Replies !
Database Driven Website
We want to develop database driven website. because of enormous amount of data (300GB) customers's tech advisors are insisting on using SAN instead of any direct attached storage method. I want to know what issues need to be considered while using SAN in web solutions.? Which database server/ product is best suited for such kind of job ? Can anyone suggests good informative articles on this subject , available on web?
View Replies !
Double Quotes Appear As ? On Website
I have an Excel file (which is converted to csv by a tool and then uploaded to a MySQL database) and then php is used to display the data on the website. In the Excel file i have text fields which has data containing double quotes. They end up appearing at ? question mark on the website. Any idea how to dispaly the quotes Should i be carefull of any other invisible characters in Excel which can mess up the data.
View Replies !
Website Suddenly Freezes
mysql> show processlist; +------+--------------+-----------+--------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------------+-----------+--------------+---------+------+-------+------------------+ | 1851 | root | localhost | admin_soccer | Query | 0 | NULL | show processlist | | 2538 | admin_soccer | localhost | admin_soccer | Sleep | 8 | | NULL | +------+--------------+-----------+--------------+---------+------+-------+------------------+ 2 rows in set (0.00 sec)
View Replies !
Website Freezes Due To Locks
I have used this command for database back up mysqldump -u USER -pPASSWORD --skip-extended-insert --lock tables DATABASE | gzip dump.sql or mysqldump -u USER -pPASSWORD --skip-extended-insert DATABASE | gzip dump.sql But even though i use lock tables or not , my website freezes for that period of time untill backup is finished. Is there anyway that users should be able to use website during backup
View Replies !
MySQL Driven Website
I would like to do is create a website that is driven by a MySQL database. The question is, does MySQL have to be installed on the web server by my isp or is there another option. I have read some posts about a MySQL DLL that can be placed on the server instead of a full install, but have not found enough relevent info.
View Replies !
Moving DB/website To Another Server
I exported my database so that I can move my website to another server PC. Upon importing into the new MySQL server I get this error messsage. I had a look at MySQL website but to no avail I still did not know what it means or how to solve it. Code:
View Replies !
User Interactive Website
I want to make an interactive website where people have to register to interact. (like fill out a form giving loging information and stuff). I want to do this using PHP/MySQL. Would anyone please show me how to do this, or give me a link to a website/tutorial that will?
View Replies !
Creating Website Search
I am attempting to create a search engine for my website. I have found a php script that should help me accomplish what I am trying to do, but I cannot get any search results to appear which means I have one or several or all of my parameters incorrect. Right now, I have the search included on a separate page, and while I have connected the script to the database so that it no longer says 'Could not connect to database' or 'Access denied,' I cannot get any search results to display. Code:
View Replies !
Connect To Mysql From A Different Website?
I have 2 websites that sometimes I want to transfer products from one website to the other. An easy way for me to do this would be site-a connect to site-b DB, select the data, and then reconnect to own site-a DB and save. I dont think security risks would be a big issue because the only thing I would be transfering would be products which dont have any sensitive info connected to them. but is there a way? if not I will just have to do it manually...Im just trying to be sufficient.
View Replies !
How To Use The Store Procedures For My Website?
As we all know that mysql is available with store procedures. But i dont know how to use the store procedures for my website. as i heard that we cannot use the store procedures for live site. we can only use store procedures for desktop application.
View Replies !
How Do I Post My Tables For Viewing Via My Website?
I can view all my tables on my server/host site, but can't figure out how to post the table I want to be able to view and enter data into via my website. My website under "my admin" feature was set up to let me enter a persons username, password and email address. However, I can only view "username" on my website under admin. I want to be able to add new data, like the date to my website so that I can enter the date and view it on my website. Do I need to add php or html code to my existing webpage that lets me view my database?
View Replies !
Displaying MySQL Data On Website
Currently, our neighborhood directory is in Microsoft Access, and every few years we would have it printed professionally and bound. I have Reports which formats the data for the printed directory. I would like to add the directory to the website, to replace printing it. I can easily create the tables and insert the data. I'm not sure how to go about displaying the directory data. Is there is a way to create a report and display that? Each entry represents a family in the neighborhood, but the fields that contain data may vary from family to family, such as the kids field. Also, I want multiple entries on a page - like a phone book.
View Replies !
Sql Error - Shuts Down The Website In 5 Seconds
There is a program called as D4 and it sends a huge data to the sql database and it slows down the website in the first 2-3 seconds and then in a few seconds it shuts down the website until s/he stops using the program. We made a huge research over the internet, but we couldn't find any solutions for this. It can shut down any website, that's having a sql based database. I hope you can help us with this problem. Thank you for your attention and time. if the site admins want to get the program, they can contact us. However, they should be aware that this is a dangerous program so it shoudn't be distrubuted.
View Replies !
Trying To Make Website Ping Inventory
the website is not locally hosted we have a hosting company but we have our own database inside our stores that keep track of things like our inventory, I need to make the site able to access our database to check if a product is in stock or not. another problem is that our server in our store is behind a cisco pix that makes it so you have to use a VPN to connect to our server from an outside address. does anyone know how or have any ideas on how i can make the site connect to our local DB?
View Replies !
Setting Up A Database And Linking It To A Website ?
Does anyone know how to setup a database linked to a website please ? I would like to setup a database so that when someone fills in their first name and email address to receive newsletters, it can automatically go into a database to be used later to email them their newsletters. The (mysql ?), database in my cpanel is phpmyadmin version 2.8.0.2
View Replies !
Creating A User Generated Content Website
I'm planning to create a community site (in PHP and MySQL) where people can post some sort of helpful information. I want to include features that would allow people to rate this information and post comments about it. I would also like to make this information searchable, so I want to include tags. To help you understand it better, the website is sort of like digg.com or engadget.com or any other website that have content and comments on it. Sort of like a blog site. I already finished creating the login system. Now I need to work on the content posting system. I already thought about the SQL table to store this content. Here's what I have so far: ContentID, User, Title, ContentText, DatePosted, NumOfComments, Rating, Tags For the comments, I would assume the SQL table would look like this: ContentID, User, CommentNumber, CommentText Now, am I on the right track here? This is my first time creating something like this. I'm also new to PHP and MySQL. Are there free scripts out there that does the same thing?.
View Replies !
Root User And Developing PHP/MySql WebSite
my webhosting company defaulted a root user with no password. I created a user for myself with a password, but wondering if having the root user without a password will leave the database open to intrusion. What's it there for, anyways? On another note, what is a good IDE for developing a PHP/MySQL website that will be served from a UNIX server, but developed on a windows PC?
View Replies !
Using MySQL For Website Database Backup / Restor
so apparently MySQL is widely used for web site backup's of databases.....however i cant seem to figure out how that is supposed to work. i am using joomla, and i have a couple ways of makeing .sql backups, but im not sure how i am to put the database on again, or if need be, on a second website. am i making sence? i need a way to "import" my database to a website incase it gets 'nuked' or something. is MySQL the right program for this, or not?
View Replies !
Command Line Client On Hosted Website
My organization's website is hosted by web.com. I am trying to use MySQL to create databases and use them for our website but when I open up MySQL's command line client, it prompts me for the password that I chose when I configured everything and then the prompt is "mysql>" instead of "shell>" and when I type in "mysql -h <ip address> -u <username> -p" it gives me "ERROR 1074 <42000>" How do I use MySQL Command Line Client for a server located elsewhere instead of it just going to the server on my computer? How do I connect to a webhost's server?
View Replies !
Renaming Database, Website Link Problems
I just created a website on a new domain, and created a new database for it. Although I will be modifying the tables, I'm starting off with the same structure and data from the old website, just copied the tables across (export/import). I changed all the references to the old on all the web pages and scripts with the new Username, Password and Database info, but nothing the database info is not coming up, when I run the pages.
View Replies !
How Do You Connect A Phpmyadmin Database To A Website Page
I've worked with websites for a few years, but have never been involved with databases. I've managed to create a database in my phpMyAdmin - the versions are below: phpMyAdmin - 2.8.0.2 * MySQL client version: 4.1.10 * Used PHP extensions: mysql After I created the database, it gave me some code below, but am not sure what the next few steps are: PHP $dbh=mysql_connect ("localhost", "practice_saz", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("practice_test");
View Replies !
MySQL Versioning Of PHP Data-driven Website
I have a website that I am designing that uses a bunch of PHP scripts to generate pages for a website from data stored in an underlying MySQL database. I have the PHP scripts under CVS, and using Apache and mod_rewrite I am able to access different versions of the website from the CVS project - each with their own set of PHP scripts. The problem is this: I would like to version the MySQL database as well. This means that there would be multiple MySQL databases, with slightly varying schemas on the server. Each PHP version of the website would point to a corresponding MySQL database for its data. Multiple PHP versions could point to the same DB, as long as each PHP version has SQL statements matching the schema of the correspoinding DB. One version of the DB would be a live version of the site (v1 for example, above). Users accessing the site would causes changes to the data in the DB (not the schema, of course). The second version of the DB (v2) would need to basically be a slave replication server, using DB v1 as the master. This will allow DB v2 to be up-to-date with all of the user updates that appear in DV v1. DB v2 is the development copy. As the design matures, schema changes will be made to DB v2. At some point, DB v2 will be made the "live" server, essentially taking the role of DB v1. As long as fields are only added to tables in DB v2 to modify the schema, the developer can easily just feed the updates from DB v1 to v2, to keep the user data current. The complicated part is when schema changes need to be made to v2 where fields are deleted, renamed, moved, etc. What is needed, basically, is a system that can track the ALTER TABLE statements, and appropriately translate the UPDATE statements from DB v1 to the new schema of DB v2. The developer could specify non-obvious and more complicated changes in some sort of syntax in order to clarify the changes to the underlying schema - thus allowing the generation of the proper relational algebraic (SQL) statements from the original UPDATE statements. Does anyone know of an existing system or set of scripts that accomplishes this, or can offer an alternative solution for DB versioning?
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
Install Using Book :: Database Driven Website Using PHP And MySql
I've just purchased copy of "Database Driven Website Using PHP and MySql" and have a few problems getting started. I had tried to install apache via the manual install but could'nt make any sence of it. I them found a program called Xampp. I installed it becuase it included PHP, MySQL and would get apache working as well. Having read the first part of the book I did'nt think I needed to install any programs and tried to start on Ch 2. I can't open the msql.exe file or even find it??
View Replies !
|
TRACKER
