Hi everyone,... I'm not sure that this is in the right area but I'll try it here and see what responses i get.<br /><br />First off i have no idea on how to create a database. I own Excel and Access if i can use either of these.<br /><br />But anyway what i have done so far is i gathered websites that carry the products i wanting to use for a Price Comparison Site.<br />I have 77 Websites which I have added to an Excel Spread Sheet. Lets say 10 of these sites carry the same tires including size, shape, model and make.<br /><br />Is there a way that i can get Excel to determine this so that it lists these tires in order from cheapest to more expensive?<br />I'd also like to add an image of the tire also.<br /><br />I want to do this with Air Intakes, Rims, Accessories and all the parts i can find.<br />Is Excel the best way to do this and how do i get them to see the items, pictures and prices and stuff. Do i have to create a new Spread Sheet for each of the Price then a new one for model and a new one for make, style and so on?<br /><br />Some products will have more features than other products. I also want to have a link to the product that is on the website that is selling the product. Just like pricewatch has.<br /><br />Any help would be very much Appreciated.<br />If there happens to be a Excel Guru out there that could set this up faster than i can I will owe you BIG time.<br /><br />Suggestions, Solutions?<br /><br />Jim.<!--content-->
Hi Jim,<br /><br />you can do it in excel (it's relatively straightforward if you have the data in there), but that would have the information on your computer, rather than on a web page (and excel is not that good at creating html code). <br /><br />There is a database system on the server (MySQL) which you can use, and then get PHP to convert the database into web pages. This is a lot more difficult to create than the excel version though. <br /><br />I'd start of by carefully defining your requirements. What parameters do you want to include ? and when are these the same /different ?<!--content-->
Visit <a href="http://www.websitedatabases.com/" target="_blank">this site</a>. They offer tools to create databases, convert Excel to a database, etc...<br /><br />Also, I recommend picking up a copy of a PHP programming book or start looking for online tutorials to teach you the basics of PHP programming. Once you have done that you will have the fundamentals for producing the kind of site you want to create.<!--content-->
<!--quoteo(post=208266:date=Jun 25 2007, 08:09 AM:name=TCH-Bruce)--><div class='quotetop'>QUOTE(TCH-Bruce @ Jun 25 2007, 08:09 AM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208266"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Visit <a href="http://www.websitedatabases.com/" target="_blank">this site</a>. They offer tools to create databases, convert Excel to a database, etc...<br /><br />Also, I recommend picking up a copy of a PHP programming book or start looking for online tutorials to teach you the basics of PHP programming. Once you have done that you will have the fundamentals for producing the kind of site you want to create.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Hmm,.. Which program, the Php Magic or the Database Generator? or both lol?<br /><br />thank you for your help & suggestions.<br />Jim<!--content-->
How about the <a href="http://www.websitedatabases.com/excel-mysql.html" target="_blank">Excel to MySQL converter</a><!--content-->
<!--quoteo(post=208278:date=Jun 25 2007, 11:04 AM:name=TCH-Bruce)--><div class='quotetop'>QUOTE(TCH-Bruce @ Jun 25 2007, 11:04 AM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208278"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->How about the <a href="http://www.websitedatabases.com/excel-mysql.html" target="_blank">Excel to MySQL converter</a><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />I second that, this program is cheap and works as intended. I use this on occasions to migrate my spread sheets to database for quick projects. The last one I converted had 4 sheets and over 3000 entries, and it treats each sheet as a new table. The only thing it doesn't do is things like autoincrement and primary keys, but that is easily done after the data is imported.<!--content-->
Hmm,... How do i know i have Excel setup ready for the conversion?<br />All i did was in column "A" was to put the url address in it.<br /><br />Should i use another spread sheet page for the other items or just continue to column "B", "C" and so forth?<br /><br />Or is there a template that Excel has maybe that I can use to enter the data into?<br /><br />Jim<!--content-->
What and where are the mysql databases located at?<br />Is there a port # to it also? see pic.<br /><br />I just created a new mysql database named test<br /><img src="http://www.onlineautorama.us/pictures/1.jpg" border="0" class="linked-image" /><br /><br />Jim<br /><br />P.S. i receive this error uploading a JPG file.<br /> Upload failed. Please ask the administrator to ensure the uploads directory is writeable.<br /><br />I had to use the forums insert message. The upload feature isnt working.<!--content-->
Host should be the IP address of your server. Port is 3306. You will need to go the the MySQL section in cPanel and add your public IP address to the Access Hosts list at the bottom to allow remote access. You can find your public IP by visiting <a href="http://whatismyip.com" target="_blank">http://whatismyip.com</a><!--content-->
<!--quoteo(post=208314:date=Jun 25 2007, 07:35 PM:name=heyguy)--><div class='quotetop'>QUOTE(heyguy @ Jun 25 2007, 07:35 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208314"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Host should be the IP address of your server. Port is 3306. You will need to go the the MySQL section in cPanel and add your public IP address to the Access Hosts list at the bottom to allow remote access. You can find your public IP by visiting <a href="http://whatismyip.com" target="_blank">http://whatismyip.com</a><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Where should the Dot be if i want to connect to the one on my server. Remote right?<br /><br />Jim<!--content-->
<!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->I had to use the forums insert message. The upload feature isnt working.<!--QuoteEnd--></div><!--QuoteEEnd--><br />The upload feature of the forums is disabled. You need to remote host any images you want to post.<!--content-->
Wheres the mysql databases located at so i can point this program in the right direction?<br /><br />Jim<!--content-->
<!--quoteo(post=208318:date=Jun 25 2007, 08:23 PM:name=OnlineAutorama)--><div class='quotetop'>QUOTE(OnlineAutorama @ Jun 25 2007, 08:23 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208318"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Wheres the mysql databases located at so i can point this program in the right direction?<br /><br />Jim<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />That would be remotely since the database is on our server and not on your PC.<!--content-->
<!--quoteo(post=208319:date=Jun 25 2007, 09:08 PM:name=TCH-Dick)--><div class='quotetop'>QUOTE(TCH-Dick @ Jun 25 2007, 09:08 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208319"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->That would be remotely since the database is on our server and not on your PC.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br /><br />Yep,.. thats what i thought and as you can see in the picture that is how it's setup but wasnt able to find or see the database i created.<br />There's only a couple options i didnt know for step 1 and i couldnt even get past it. So by going by that image above what is incorrect about it so i can put in the correct info as i asked before?<br /><br />Jim<!--content-->
Nothing that I can see. Have you setup the access hosts in cPanel.<br /><br /><br /><br /><br /><br /><!--content-->
Hi Jim,<br /><br />you can do it in excel (it's relatively straightforward if you have the data in there), but that would have the information on your computer, rather than on a web page (and excel is not that good at creating html code). <br /><br />There is a database system on the server (MySQL) which you can use, and then get PHP to convert the database into web pages. This is a lot more difficult to create than the excel version though. <br /><br />I'd start of by carefully defining your requirements. What parameters do you want to include ? and when are these the same /different ?<!--content-->
Visit <a href="http://www.websitedatabases.com/" target="_blank">this site</a>. They offer tools to create databases, convert Excel to a database, etc...<br /><br />Also, I recommend picking up a copy of a PHP programming book or start looking for online tutorials to teach you the basics of PHP programming. Once you have done that you will have the fundamentals for producing the kind of site you want to create.<!--content-->
<!--quoteo(post=208266:date=Jun 25 2007, 08:09 AM:name=TCH-Bruce)--><div class='quotetop'>QUOTE(TCH-Bruce @ Jun 25 2007, 08:09 AM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208266"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Visit <a href="http://www.websitedatabases.com/" target="_blank">this site</a>. They offer tools to create databases, convert Excel to a database, etc...<br /><br />Also, I recommend picking up a copy of a PHP programming book or start looking for online tutorials to teach you the basics of PHP programming. Once you have done that you will have the fundamentals for producing the kind of site you want to create.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Hmm,.. Which program, the Php Magic or the Database Generator? or both lol?<br /><br />thank you for your help & suggestions.<br />Jim<!--content-->
How about the <a href="http://www.websitedatabases.com/excel-mysql.html" target="_blank">Excel to MySQL converter</a><!--content-->
<!--quoteo(post=208278:date=Jun 25 2007, 11:04 AM:name=TCH-Bruce)--><div class='quotetop'>QUOTE(TCH-Bruce @ Jun 25 2007, 11:04 AM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208278"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->How about the <a href="http://www.websitedatabases.com/excel-mysql.html" target="_blank">Excel to MySQL converter</a><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />I second that, this program is cheap and works as intended. I use this on occasions to migrate my spread sheets to database for quick projects. The last one I converted had 4 sheets and over 3000 entries, and it treats each sheet as a new table. The only thing it doesn't do is things like autoincrement and primary keys, but that is easily done after the data is imported.<!--content-->
Hmm,... How do i know i have Excel setup ready for the conversion?<br />All i did was in column "A" was to put the url address in it.<br /><br />Should i use another spread sheet page for the other items or just continue to column "B", "C" and so forth?<br /><br />Or is there a template that Excel has maybe that I can use to enter the data into?<br /><br />Jim<!--content-->
What and where are the mysql databases located at?<br />Is there a port # to it also? see pic.<br /><br />I just created a new mysql database named test<br /><img src="http://www.onlineautorama.us/pictures/1.jpg" border="0" class="linked-image" /><br /><br />Jim<br /><br />P.S. i receive this error uploading a JPG file.<br /> Upload failed. Please ask the administrator to ensure the uploads directory is writeable.<br /><br />I had to use the forums insert message. The upload feature isnt working.<!--content-->
Host should be the IP address of your server. Port is 3306. You will need to go the the MySQL section in cPanel and add your public IP address to the Access Hosts list at the bottom to allow remote access. You can find your public IP by visiting <a href="http://whatismyip.com" target="_blank">http://whatismyip.com</a><!--content-->
<!--quoteo(post=208314:date=Jun 25 2007, 07:35 PM:name=heyguy)--><div class='quotetop'>QUOTE(heyguy @ Jun 25 2007, 07:35 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208314"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Host should be the IP address of your server. Port is 3306. You will need to go the the MySQL section in cPanel and add your public IP address to the Access Hosts list at the bottom to allow remote access. You can find your public IP by visiting <a href="http://whatismyip.com" target="_blank">http://whatismyip.com</a><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />Where should the Dot be if i want to connect to the one on my server. Remote right?<br /><br />Jim<!--content-->
<!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->I had to use the forums insert message. The upload feature isnt working.<!--QuoteEnd--></div><!--QuoteEEnd--><br />The upload feature of the forums is disabled. You need to remote host any images you want to post.<!--content-->
Wheres the mysql databases located at so i can point this program in the right direction?<br /><br />Jim<!--content-->
<!--quoteo(post=208318:date=Jun 25 2007, 08:23 PM:name=OnlineAutorama)--><div class='quotetop'>QUOTE(OnlineAutorama @ Jun 25 2007, 08:23 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208318"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Wheres the mysql databases located at so i can point this program in the right direction?<br /><br />Jim<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />That would be remotely since the database is on our server and not on your PC.<!--content-->
<!--quoteo(post=208319:date=Jun 25 2007, 09:08 PM:name=TCH-Dick)--><div class='quotetop'>QUOTE(TCH-Dick @ Jun 25 2007, 09:08 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=208319"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->That would be remotely since the database is on our server and not on your PC.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br /><br />Yep,.. thats what i thought and as you can see in the picture that is how it's setup but wasnt able to find or see the database i created.<br />There's only a couple options i didnt know for step 1 and i couldnt even get past it. So by going by that image above what is incorrect about it so i can put in the correct info as i asked before?<br /><br />Jim<!--content-->
Nothing that I can see. Have you setup the access hosts in cPanel.<br /><br /><br /><br /><br /><br /><!--content-->