Suggestions On DB Setup For A Photo Album
At the moment the site is just used by me, in time I might open it up to friends to use too. So I want to develop a DB that works now and doesn't need to be modified for the future upgrade if it happens. I'd like to have it so when when you go to the photo sections it shows the albums, represented by a single picture from that album. When you click that picture it goes to a new page that shows the pictures for the album. Should I make two tables, albums and images or just one images and have a way to find out which ones are the main image for albums and which pics belong to them?
View Complete Forum Thread with Replies
Related Forum Messages:
Hosting Photo Album
I am writing a database for an online photo album website which will allow people to sign in, upload photos, and have an online photo album. I am trying to figure out the best design for this type of application, and I am not sure how to best set up each persons picture database. I suppose there can be a table with a list of all of the people, and then a table with all of their information that is linked to the list of people..does that sound right? Also, does a primary key need to be the same for each table that is related to each other? (Silly question, I know.)
View Replies !
Only Display One Photo Instead Of All Photo Upload By User... How?
I have a tableA storing user id and password, another tableB storing user id and the image file name. User can upload 5 photo to the site. Now, I wish to display a photo in the search result (when people search for user with name starts with 'A') I have no idea how to only display one photo for the searched user in the result. Do you know any solution?
View Replies !
Xxx Photos In Album..
making a photo album (dreamweaver8 - PHP & MySQL) On the page (with repeated region) that's displaying all the available albums (gallery.php), I would like to include the amount of photos each album contains.. however, it doesn't seem to work out.. I have 1 recordset/query for the albums-info (id, album, summary, date-added, and display-thumb), and I tried creating another query for the photos: selecting the photo-id, photo, and album-id (filtering on album-id)... but nothing... I get either "5" photos for each album (which is actually the amount of albums), or "0"... Thanks for any info on how to construct my query in order to display the amount of photos belonging to that certain album (album-id)..
View Replies !
Schema Suggestions
I've managed to create some fairly simple databases up to now, but need some suggestions on the best schema for this. I want to store some product details (inkjet cartridges) with the following data: Printer Manufacturer Printer Model Cartridge Ref No Cartridge Description Compatible Price OEM Price Reman Price I need some ideas for how best to go about doing this - what's confusing me is the how to cater for the fact that the Cartridge Ref No can apply to many Printer Models.
View Replies !
Book Suggestions
I have a couple questions about books. First, let me explain my situation. I have a CS degree, with some basic courses in DB design. I have been a programmer for many years, the last few years in maintaining legacy Clipper applications and CF web programming. We are moving forward, and have chosen mySql as our DB platform. I will most likely become our DBA. What books would you recommend, and in what order? I understand basic SQL, but haven't done anything with triggers, stored procedures, T-SQL, anything like that. Probably the "recipe site" level of design and querying. I think I used an INNER JOIN once
View Replies !
How To Delete The Uploaded File(photo)
i have made a e-pal section where the members can upload the photos....now i m making a edit portion for the e-pals where the e-pals can edit their profile n change their photos......i have used mysql to store the datas of e-pals n the path of uploaded images(note it:mysql stores not the images only the path)...
View Replies !
Query For Member Information And Photo
member member_photo The member_photo has a record for each photo they upload. They can then choose which photo is their primary photo, which is flagged with a field called photomain. Im trying to get the list of all members along with their primary photo but Im using 2 queries which I feel is slowing down the page. Is there a subquery I should be using? PHP $query1 = $db->Execute("SELECT id,firstname,lastname FROM members ORDER BY lastname ASC"); //loop through the recordswhile(!query1->EOF){$memberid = $query1->fields['id'];$firstname = $query1->fields['firstname'];$lastname = $query1->fields['lastnamename'];$query2 = $db->Execute("SELECT photothumb FROM member_photo WHERE memberid = $memberid AND photomain = 1 LIMIT 1"); $memberphoto = $query2->fields['photothumb']; $query1->MoveNext();
View Replies !
Any Suggestions For Storing Tags?
I'm making a simple image hosting script like imageshack, but in order to make it web2.0 compliant I have to add tags. I'm no DBA, and I'm not sure of the best way to store data with many-to-many relationships, and I was hoping to solicit some ideas. I thought about just giving the image table a fulltext space delimited tag field, which would be really easy to query, but not at all normalized and probably quite slow under strain. How can I set up my db to scale more gracefully?
View Replies !
Need Suggestions For Database Structure
I have been developing a new website and i need help in deciding the best database structure for it. The site is basically a dating website with various modules like blogs, videos, comments, friends, photos etc. I have created a member table that stores all the basic profile info and created separate tables for friends, photos, messages, blogs etc and MemberID as foreign key. Now on profile page, i want to display all info related to member like his profile info, his photos, friend list, messages etc and i have to execute 7-10 short queries on profile page for this. Also, i think Joins will not be much helpful as there is one to many relationship e.g there can be more than 1 photo for a member and i am saving each photo in a seperate record. Similar is the case for other tables?? So can you please suggest that is it a correct structure or can there be other better alternatives through which i can fetch all information using less queries. I am using mysql 5 database.
View Replies !
Suggestions For Lyrics Database
i am creating a small lyrics site and am wondering about some things. Here is the current structure. MySQL Code: CREATE TABLE artists ( Â Â artist_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, Â Â artist_name VARCHAR(255) NOT NULL, Â Â artist_url_name VARCHAR(255) NOT NULL, Â Â PRIMARY KEY (artist_id) ); CREATE TABLE albums ( Â Â album_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, Â Â artist_id SMALLINT UNSIGNED NOT NULL, Â Â album_title VARCHAR(255) NOT NULL, Â Â album_date DATE NOT NULL, Â Â album_url_name VARCHAR(255) NOT NULL, Â Â PRIMARY KEY (album_id) ); CREATE TABLE tracks ( Â Â track_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, Â Â album_id SMALLINT UNSIGNED NOT NULL, Â Â track_title VARCHAR(255) NOT NULL, Â Â track_number TINYINT UNSIGNED NOT NULL, Â Â track_lyrics TEXT NOT NULL, Â Â track_url_name VARCHAR(255) NOT NULL, Â Â user_id SMALLINT UNSIGNED NOT NULL, Â Â publish_date DATETIME NOT NULL, Â Â PRIMARY KEY (track_id) ); CREATE TABLE users ( Â Â user_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, Â Â username VARCHAR(255) NOT NULL, Â Â password VARCHAR(255) NOT NULL, Â Â email VARCHAR(255) NOT NULL, Â Â registration_date DATETIME NOT NULL, Â Â PRIMARY KEY (user_id) );...............................
View Replies !
New Db Setup
Does anyone know of a good web site that I can look at that will show me how to set up a MySQL instance?
View Replies !
DB Setup
I'm trying to figure out how I should layout a database table(s). What I would like to do is be able to keep track of how many times several pages are viewed each day. For example, I'd like to know how many times the index.php was hit on Sept 8. and how times on Sept 9. How many times article.php was hit on the 8th and on the the 9th etc.
View Replies !
Setup.exe Xp Pro
how to sort this out everytime i try to uninstall a progarm it comes up with setup.exe has a problem and as to close,it is just on 1 program it is a ebay toolbar im trying to get rid off any help might help.
View Replies !
Setup With PHP
I've downloaded the mySQL files from the http://www.mysql.com website, and have unzipped them into my c: drive, although, i wish to be able to use this in addition in my PHP programming with my Apache Server. How would I do somthing like this?
View Replies !
Setup Under Windows Xp Sp1
I need to upgrade my current mysql installation . But now there is a problem to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The program hung after few seconds. In the memory remain active woexec, ntvdm and setup, but the process is freezed. It is possibile to convert the current setup mode of mysql4.014 in other install system, as for in mysqlcc092 ?
View Replies !
Db Password Setup
I use phpMyAdmin to change db password, but failed. It says: SQL-query : SET PASSWORD = PASSWORD( '*******' ) MySQL said: You must have privileges to update tables in the mysql database to be able to change passwords for others
View Replies !
Setup Database
Wanting to set up where users can set up a buddy list where they click on a username and send a request to said user to place them on their buddy list. Also want to have a list of users that are on this buddy list. Currently have but a single table with this structure id SMALLINT(6) username VARCHAR(40) password VARCHAR(40) user_invite VARCHAR(40) grant_request ENUM ("yes","no") friends VARCHAR (40) I am by no means any good with setting up a table or table that would work properly with MySQL, so any suggestion as to how to set up a workable table structure that would easily be updated when users request from other users to allow them to be added to their buddy list.
View Replies !
Setup Password
I have been trying to set up mysql on os x 10.4 tiger. Everything went well. I had a test php page. When I completed the setup of mysql I ran the test page and everything worked a treat . I had been following a tutorial, a wee bit out of date, but all good. It recommended that I give mysql a password like the root on the apple. So, I did: mysqladmin -u root password new_password_here It seemed to take it ok, i.e. didn't print an error message or anything. So, I thought all was well , but when I went back to the test page (after editing it and providing the new password details), I got an error : Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /Library/WebServer/Documents/test.php on line 5 Warning: mysql_select_db(): Access denied for user 'root'@'localhost' (using password: NO) in /Library/WebServer/Documents/test.php on line 9 Warning mysql_select_db(): A link to the server could not be established in /Library/WebServer/Documents/test.php on line 9 Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
Setup Table
I'm working on this script where users can add another users to their friends list. Basically, user add another user as friend and must be approved by another user in order to be called friend. The problem is I don't know how to setup a table for this.
View Replies !
Table / DB Setup
I will potentially have 1-3 tables that may be written too 1,000's of times per second. Eventually becoming very very large tables. What methods and suggestions would you make on how to properly handle a task of this nature? I need to be conscerned about performance on pulling many records back as well for statistics.
View Replies !
Password:: Setup
I have screwed up my password somehow. I have just started using MySQL and downloaded the Administrator. Also trying to use Dreamweaver and following their instructions tried to use the Administrator to set up a user with no name. NOw when I try to set mySQL it asks for my password which apparently is invalid (computer beeps). Now I cannot use mySQL. How do I recover from this?
View Replies !
Database Setup
I would like to get some suggestions on how to setup my database. I am reading thousands of different tags from a field device. I am reading each tag values at different intervels. I will have a column for each Tag name containing the read value and a column for the date/time stamp. If I put all these tags in the same table I will have rows with one value and the rest null values time stamp | test1 | test2 | test3 | ------------------------------------------ 02/16/05 9:44:44 | 2.45 | null | null | 02/16/05 9:44:45 | null | 3.22 | null | 02/16/05 9:44:46 | null | null | 212 | 02/16/05 9:44:44 | 3234 | null | null | 02/16/05 9:44:45 | null | 3434| null | 02/16/05 9:44:46 | null | null | 2333 | 02/16/05 9:44:44 | 2 | null | null | 02/16/05 9:44:45 | null | 4444 | null | 02/16/05 9:44:46 | null | null | 2121 | But if I make one table per tag I will have thousands of tables. Does anyone have a sugestion?
View Replies !
MAC OS X Setup With PhpMyAdmin
I am having a problem setting up the config.inc.php file in phpMyAdmin. I have amended the mysql user account in Mac OSX in NetInfo and given it a password. I have amended the config.inc.php file control user to the same settings, but I keep getting the messsage 'Access denied for user mysql@localhost using Password: Yes) I have tried all sorts of combinations of user names and passwords for control user and user and the only one I can get to work is user = root with a blank password and controluser name and password of blank, which gives me a warning that MySQL is running with the default privileged account which is a security risk.
View Replies !
Verifying Setup
I am new to mysql as of yesterday, however i have a fair amount of sql server experience. I have configurable webservices(written by a coworker) that should be able to connect to sql server or mysql. I can configure and test on sql server no problem, however when connecting to our mysql server it is failing to connect to the database. Is there a simple way to test my database connectivity to ensure my passsword and UN and connection string are appropriate?
View Replies !
ODBC Setup
I have a Windows 2000 Server preinstalled with mySql, and have tried to run a basic connection test though the ODBC manager for the mySql Server Driver, and it continues to say it can not find mySQL. When setting up a standard database through the ODBC Manager, here is the basic info it provides. Code:
View Replies !
My.ini File Setup
I want to make sure my ini file is set up right. I have now" #This File was made using the WinMySQLAdmin 1.4 Tool #1/14/2004 11:13:21 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/APPS/MySQL #bind-address=192.168.0.100 datadir=C:/APPS/MySQL/data #language=C:/APPS/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/APPS/MySQL/bin/mysqld-nt.exe user=X3Graphics password=xtreme" What I want to be able to do is update my database locally and on my hosting server. Is this possible.
View Replies !
How To Setup A Rolodex?
If im creating a rolodex to contain unique id#, names(first, last), adresses(street1, Street2,city,state,zip), phone numbers(home, work, cell) e-mail adresses(home, work), Comments How would this be organized? Would i only use one table or multiple tables? How would i set up each column. (Name, Type, Null,Key, Default,Extra)? Could someone organize this for me. I am trying to learn PHP and MySQL but i just havent figured out the database design part yet and i want to create a rolodex for my site.
View Replies !
MySQL Setup Error
While installing mysql server on a windows 2000 machine without a firewall, I get an error numbered 1045. Access is denied for user 'root'@'localhost' (using password: NO).
View Replies !
ODBC Driver Setup
I have setup an ODBC driver for my MySQL database and use a 3rd party program to connect to it. Everytime the software connects, the ODBC driver setup screen pops up. I have to click OK on it to continue. I set the parameter "Dont prompt on connect" in the options but this has not solved the issue. The system setup is Win2K SP2, MySQL 4.0.15, MySQL ODBC driver 3.51.
View Replies !
Inital Setup Of Mysql
I'm trying to get mysql working on redhat 9.0, Origionaly I got "can't connect to local mysql server through socket /var/lib/mysql/mysql.sock" I ran /usr/bin/mysql_install_db which corrected this! Then it started and immediatly stopped using the command /usr/bin/safe_mysqld. I looked at the error log in /var/log/mysqld.log which said can't initialize innodb_data_file. No idea what that meant so I put:- [mysqld] skip-innodb in the file /etc/my.cnf Now the only error says /usr/libexec/mysql: can't find file ./mysql/host.frm I've created a file called /usr/bin/host.frm and set the permission the same as the other files in there, but it still cant find it? The name of the machine which is just localhost is in there, anyone know what needs doing next?
View Replies !
Error With Mysql Setup
After an installation of Namo WebBoard messed up my MySQL installation - I have been unable to get it fully working again. My setup is as follows: Apache 1.3 / MySQL 4 / PHP 4 When I use phpmyadmin I get the following error: #1045 - Access denied for user: root@localhost' (Using password: YES)
View Replies !
MySQL Setup On XP Localhost
I have got the server working on Win XP Pro according to Winmysqladmin.exe. I have a password in my.ini but when I go to CMD to login to root, it gives me: "ERROR 1045: Access denied for user: 'root@localhost' <Using password: YES>" I am the system admin. I am however not using 'localhost' as such since I am behind a router that has assigned this workstation: 192.168.0.3. The USER and HOST are clearly shown in winmysqladmin.exe, like it knows about it, but the mySQL.user database shows only root USERS on "Build & Localhost" and two blanks also...the only way I can currently log on. Is this a no Win situation? I've been at this for 3 days going in circles and I suspect UNIX developers are exceeding happy to hear this. Yeah, I'm using IIS 5.1 instead of Apache too.
View Replies !
MySql User Setup
I have mysql working, and i have a user set up (i did this ages ago). How do i create a new user in mysql?. Can i create a new user for a specific database? or will each user have access to all databases?
View Replies !
A Scrimmage Setup With MySQL
I have only dealt with MySQL databases in the past, so I'm not sure if this is the best way to go about this or not, but feel free to inform me otherwise. What my plans are is to create a web-based form (I assume using AJAX) that will allow you to enter multiple fields of data, which will then go into the database, and when another person submits data that compliments yours (i.e. they match up to create a scrimmage,) then both parties will be notified and the data will be deleted from the table. Is it possible to do with PHP and MySQL
View Replies !
Database Setup And PhpBB
I have Installed MySQL on my server. I am trying to install a forum. I have no idea where I can find the Database NAME. that I type in the PHPBB installation script. can anyone tell me how I set a database name?
View Replies !
MySQL Relication Setup
I have 3 servers each of them have MySQL DB- Primary, secondary and tertiary. There is another application that will access the database. It will always try to connect to the primary, if primary is down it will try to access the secondary, if secondary is down then the third one. I'm planning to set this up in this way. Say the servers are S1, S2 and S3. There will be 3 real time sync links S1 ---> S2 Master-Slave Setup S2 ---> S3 Master Slave Setup S1 --->S3 Master Slave setup (This link will be active only if S2-->S3 link is down. Any thoughts on this. Would this suffice? Any possibility of data corruption and are there better ways of doing this?
View Replies !
MySQL Cluster Setup
I have a MySQL CLuster setup like 2 SQL Data Nodes , 2 Load balancer & 1 Management Node. [ All have Individual IP Address] Using Virtual IP [For my 2 Load balancers ] my Front End WEB Application accesses data from the Cluster. My Doubt is say transaction 1 -- started accessing data from [SQL Data node A] and transaction 2 -- started accessing data from [SQL Data node B] Say suddenly [SQL Data Node A] goes down. Now what happens with the transaction 1?
View Replies !
Database Setup / Schema
I am new to the forums but have used the site for reference many times in the past. I am currently taking a directed project course at my university and my project is to develop a PHP/MySQL based statistical tracking program for a basketball team or teams. I have worked with both PHP and MySQL a little before and am hoping to become more proficient in both as I tackle this project. I'm trying to setup the database schema with DBDesigner. Here is a link to the BMP file and a DOC file with some needed fields and a sample txt file which the online app is supposed to handle: URL URL I have not yet setup the relations and need to make sure that my database is efficient and normalized. I also think that I may be missing a few needed tables and/or fields
View Replies !
Tables Setup For 'classifieds'
I've recently been enlisted to build a classifieds-style site for an online magazine. There are about a dozen categories, with anywhere from 1 to 10 subcategories.would you suggest creating a table for each category, or just doing them all in one? And if I create a table for each, would I use a 'join' to display all results on the main page?
View Replies !
Standalone Server Setup
I have a question about my config. Ok here is what i have for a setup. 1 Computer running mySQL located in my home with a dedicated IP address. My webhost: I have a website hosting outside of my network. I would like my db to stay at my house, so the program i have running on my web host wants the mysql address.... (eg localhost) I assume i can change it to my IP address right? My my mysql server I set it up as a server with allowed remote connections.... My my website, i am guessing i change localhost to my IP, when i do this i get this error: Client does not support authentication protocol requested by server; consider upgrading MySQL clientPHP Warning: Unknown(): Unable to load dynamic library 'D:HSphere.NET3rdpartyPHP4.4.7extensionsphp_curl.dll' - The specified module could not be found. in Unknown on line 0 I know my host is windows, does this mean my web hosting provider has to install the missing dll in order for this to work?
View Replies !
Database Correct Setup
I'm trying to install a PHP and MYSQL web app which needs me to setup the correct fields. Server Name localhost Database Name mysql Database User Nameroot Database Password MyRootPassword I enter all of this information and I get an error back that says: 'unable to connect to the database server - verify settings and ensure database is running.' Does anyone know what I'm doing wrong??
View Replies !
Download.php Setup With Mysql
I am trying to make a download.php which would let users to download files after 5 seconds. The only problem is that my /download directory has many sub directory. For example if someone wants to download FireFox, then firefox.exe is located in /download/FireFox/firefox.exe and I want somewhat like this www.domain.com/download.php?fi... as an output URL to download. I know that I can use MySQL and setup a nice database to do something like this as long as fileid is unique. Any ideas on how to setup the MySQL database so that I can easily add multiple files from different sub directory at the same time.
View Replies !
Question About MySQL Setup On A Mac
I'm a fairly experienced web designer, but a newbie to PHP/MySQL. I have the Sitepoint book by Kevin Yank called "Build Your Own Database Driven Website Using PHP and MySQL" and I'm ready to start learning! I already have a mySQL db setup through my web host and I can access it using PHPMyAdmin via the web. However, the book recommends (and gives instructions for) setting up Apache, PHP, and MySQL locally and says that for learning purposes it is better NOT to use PHPMyAdmin. I hear that, but at the same time, for security reasons, I'm not all that hip on turning on Personal Web Sharing and making my computer into a server. It seems to allow access to my Sites folder which is where I have my local copies of sites I'm working on and I don't really want anyone else to access those... I'm hoping someone here can tell me which way to go... is using PHPMyAdmin really going to hamper my learning experience, or should I just use it (and feel safer)? Or are my security concerns really not that much of an issue? If anyone can give me any guidance on this, much appreciated.
View Replies !
Is This An Efficient MySQL Setup?
I would like to offload the MySQL server from my dedicated box in order to speed up page loads. I don't have an additional dedicated server so my only option is to get a VPS. But is offloading the MySQL server to a VPS, albeit a modest one, even worthwhile? I understand this is a very broad question because I am not providing any details but that being the case I am expecting a broad answer
View Replies !
|
TRACKER
