Need to create site from a business listing database

Status
Not open for further replies.
crossfittn

crossfittn

Afro Blue
Feb 4, 2007
1,135
8
0
TN
topyc.io
Ok guys I'm new to scripts. I don't really know php at all, but I want to try because my developer can only do so much at a time, and I need this done.

I have a database of weight loss clinics and I want to make a site out of it. Can you point me in the direction of any resources that would help a noob like me build this? I've built plenty of sites based on wordpress as a cms (not just blog stuff), and I've edited a bit of php stuff and I'm good with css and html, and that's it.
 


well, thanks captain kirk but it would be better if I could actually use that script, I think. It's not downloadable and I can't use it for anything except the jobs database they have.
 
It will be on sale sometime soon. Seo_mike made a thread about it earlier today.

Btw, the name is Denny Crane. Watch season premiere tomorrow.
 
I got a php script from a guy on digital point for free, and it works well. I'm thinking about doing the site in wordpress like all my others, and having it display the correct query using conditionals in the templates.

THanks for your help guys. I"ll check out more about webmerge though.
 
crossfittn said:
I got a php script from a guy on digital point for free, and it works well. I'm thinking about doing the site in wordpress like all my others, and having it display the correct query using conditionals in the templates.
Click to expand...

I have been struggling with building good sites using DBs for about a week now. I've learned a lot but I'm still not at the level I want to be.

What does this script you got from the guy on digital point do? Would you mind sharing it?
 
you will NOT be able to use your own database with seocracy's post to wordpress database tool. you will only have access to use this tool with his personal collection of databases - which is pretty huge - but the point is you cannot have custom work done. Maybe you can pay him to give you access on a per case scenario.

you could use phpmydirectory.com - it costs $100 but it's pretty sweet once you get all the bells and whistles working. There is a database import feature and Google Maps is automatically integrated which is a nice touch. Not to mention you can manage invoices and memberships/payment from the admin cp.

you could also have a script/macro written that simply emulates mouse movements and copies/pastes posts into wordpress. i have no clue how to do stuff like this so you're on your own as far as gittin her done

hope this helps
 
plepco said:
What does this script you got from the guy on digital point do? Would you mind sharing it?
Click to expand...

Here you go:

PHP: 
<?php
$db = mysql_connect("localhost", "youruser", "yourpass");
mysql_select_db("YourDBName",$db);
$result17 = mysql_query("SELECT * FROM YourTableName WHERE City = '$city' AND State = '$state' ");
$num_rows = mysql_num_rows($result17);
while ($row = mysql_fetch_array($result17)) {
$field1 = $row["Id"];
$field2 = $row["Keywords1"];
$field3 = $row["Keywords2"];
$field4 = $row["Name"];
$field5 = $row["Address"];
$field6 = $row["City"];
$field7 = $row["State"];
$field8 = $row["Zip"];
$field9 = $row["Telephone"];
$field10 = $row["Fax"];
$field11 = $row["Description"];
$field12 = $row["Contact"];
$field13 = $row["Web"];
$field14 = $row["Email"];
echo "<tr><td><font face=tahoma color=black size=1><b>$field4</b></td><td align=right><font face=tahoma color=#0000aa size=1><i>$field2</i></td></tr><tr><td><font face=tahoma color=black size=1> $field5  $field6, $field7  $field8</td><td align=right><font face=tahoma color=black size=1><b> $field9 </b></td></tr>\n";
}
mysql_close();
?>
 
trigatch4 said:
you will NOT be able to use your own database with seocracy's post to wordpress database tool. you will only have access to use this tool with his personal collection of databases - which is pretty huge - but the point is you cannot have custom work done. Maybe you can pay him to give you access on a per case scenario.

you could use phpmydirectory.com - it costs $100 but it's pretty sweet once you get all the bells and whistles working. There is a database import feature and Google Maps is automatically integrated which is a nice touch. Not to mention you can manage invoices and memberships/payment from the admin cp.

you could also have a script/macro written that simply emulates mouse movements and copies/pastes posts into wordpress. i have no clue how to do stuff like this so you're on your own as far as gittin her done

hope this helps
Click to expand...

Thanks for the info, sir!
 
trigatch4 said:
you will NOT be able to use your own database with seocracy's post to wordpress database tool. you will only have access to use this tool with his personal collection of databases - which is pretty huge - but the point is you cannot have custom work done. Maybe you can pay him to give you access on a per case scenario.

you could use phpmydirectory.com - it costs $100 but it's pretty sweet once you get all the bells and whistles working. There is a database import feature and Google Maps is automatically integrated which is a nice touch. Not to mention you can manage invoices and memberships/payment from the admin cp.

you could also have a script/macro written that simply emulates mouse movements and copies/pastes posts into wordpress. i have no clue how to do stuff like this so you're on your own as far as gittin her done

hope this helps
Click to expand...

I'm building several DB sites based on Eli's "SEO Empire" post. I've got the hang of it enough (first time working with PHP/MySQL on a large scale) to see about incorporating with WP. I'll see about putting progress and examples up on a blog. It won't be a full solution but someone with programming skills shoud be able to follow along.

Really it's just about modifying the WP posts DB with perl or even PHP, feeding it a CSV or reading from another DB. Should be fairly simple now that I think about it.
 
Thanks for the info illkity.

DomainRealty, I haven't heard from you. I tried to send you this PM:
Hi,

I don't recall hearing back from you about the database sites job. I just needed a site created from a simple template off of open source templates, and it must pull data from a mysql database of weight loss clinics.

Homepage: states of US
Click on a state: displays all cities in that state
Click on a city: displays all weight loss clinics in that state.

Let me know....
Thanks
 
You havent heard from me because I have been computerless (only reason I am on now is thanks to a friend) for the past few days and will probably be so til the 15th. ;)

I'm not blowing you off. Just can't get on til then. Gotta run now; shoot me an email (I get it on my PDA): jason AT jasonberlinsky DOT com.

Jason
 
Status
Not open for further replies.
Top Bottom