n00bie Challenge

Status
Not open for further replies.
transistor said:
I have a noob question that maybe someone can help me out with...

I'm trying to compile lists of information about various thing.. For example, I might make a list of bible verses or something. How can I turn that into a database file to be displayed on my website? Well, actually, I understand that part pretty well, but is there a way to make each entry get it's own page? I'm just looking for an automated way of doing this. Like, is there a way I could just upload the file to Wordpress and let it do all the work or something?

This question was prompted by a post I read here about .sql files: All your database are belong to us - Seocracy.com
Click to expand...

Well just to get you going I will tell you what i do.

Example:
Once you have the database uploaded create a php page that would take a parameter like ?song=TITLE_OF_SONG . then in your php file query the database, grab and display the results for that song.

Next step you need to modify you .htaccess file. If you dont know what this file is, dont worry. Its filename may seem geeky but you can learn its basic functionalities very quickly (took me 3 minutes the very first time). So by modifying the .htaccess file what you want to do is to make a page like this
Code: 
http://www.mysupersongsite.com/Until it sleeps
to actually mean
Code: 
http://www.mysupersongsite.com/index.php?song=Until it sleeps
So this way all your songs in your database will have an nice looking URL

Finally you could index all you songs in your database in a sitemap file pointing to
Code: 
http://www.mysupersongsite.com/SONG_TITLE
I hope this will get you started!
 


And about this thread.

Well I also learned stuff, that I was hesitating to play with before.

To start with I took the autoblog route. I never actually worked with WP (weird isnt? hahaha) but now I make some basic modifications to the themes and most important (for me) on the plugins.

My "mistake" is that I got interested in black hat much more (the force is sooo strong) :). I improved my php a lot and created some quite useful scripts for me to automate account creating to SB and also SB posting. Also learned how to automate blog creation etc. Anyway, I learned A LOT of automation....
I said it was a mistake because all this blackhat thingy (did I mentioned that is addictive?) got me nowhere because I am so bored and unwilling to build any whitehat sites first. So the social bookmarking is useless if you dont have a concrete foundation (SEO Empire :) ).

Money results? Nope. Not good. Not good at all.

Great thread. A big thank you (again?) to Aequitas for the really great and useful information he provides.:thumbsup:
 
So, after reading this discussion I headed over to the Rss scraping and Autoblogging thread. I've dicked around with affiliate marketing for about a month, and never really had any money making experience before that.

Decided to run a few tests with wp-autoblog and adsense, I've made $3 from in two weeks with one autoblog. Crappy amounts (although it's enough to pay for my hosting), but I'm only running one, and plan to run more. At the moment am focusing on tracking and analytics for that, so I can get it right for the other 1000 I'll probably end up making. Definitely need wordpress MU though.

Anyway, thanks for the thread.
 
transistor said:
is there a way to make each entry get it's own page?
Click to expand...

Someone else gave some information on this ... using .htaccess (specifically the mod_rewrite Apache module) you can make url query strings simulate individual pages.

Make one .php page that takes a query string, queries the DB and displays the information. Once you get that down, head over to modrewrite.com and post what you want done. e.g. you'll probably want to rewrite something like yourdomain.com/bible-verses/joshua/2415 to yourdomain.com/?verse=2415. Your .php page will receive the the latter URL but the user will see the full (nice SEO-friendly) URL.

transistor said:
I'm just looking for an automated way of doing this. Like, is there a way I could just upload the file to Wordpress and let it do all the work or something?
Click to expand...

Hmm not that I can think of but since you said you understand the DB/dynamic page part well, just get that done then get someone to help you out with mod_rewrite and you'll be gold.
 
Need help guys I am stuck in the wp mu install. I uploaded the wp mu files to the root made a new mysql data base set the wp-content permission to 777 and deleted the htaccess file. One thing about the htaccess file for some reason it keeps poping back after I x out of the screen. Ok so I refresh and I get the next screen asking for the data base info and user info here is were I am stuck I add all the db info from the mysql db I just created and user info I picked the sub domain option. I then click next and this is the fatal error I get: " Fatal error: Call to undefined function: wp_die() in /home/acl/public_html/wp-includes/wp-db.php on line 475 "

I told the host support and they said to try to install the wp that comes with fantastico. I emailed them that I am trying to install wp mu not the regular wp and waiting for there reply.

Can anyone help?
Thanks.
 
alc said:
I then click next and this is the fatal error I get: " Fatal error: Call to undefined function: wp_die() in /home/acl/public_html/wp-includes/wp-db.php on line 475 "
Click to expand...

I think that error comes up when you insert wrong username and pass (for the database) information. Make sure your username is correct. CPanel inserts a header in front of the username you wanted to create.

Also, make sure you assigned the correct user to the correct database.
 
psychoul said:
I think that error comes up when you insert wrong username and pass (for the database) information. Make sure your username is correct. CPanel inserts a header in front of the username you wanted to create.

Also, make sure you assigned the correct user to the correct database.
Click to expand...

Great I got it fixed thanks I did not add the first part that the cpanel adds to the user and db name.

That fixed now I got another problem I did the fix and got a error something to do with when adding the htaccess file unable to do something about permissions also the htaccess.dist file permissions. So I just deleted the htaccess file again remember it keeps adding itself after I delete it and x out of the screen and I changed the permissions of the htaccess.dist to 777.

Did not work now all I get is another error here it is:
" No WPMU site defined on this host. If you are the owner of this site, please check Debugging WPMU for further assistance. "

Thanks.
 
alc said:
Great I got it fixed thanks I did not add the first part that the cpanel adds to the user and db name.

That fixed now I got another problem I did the fix and got a error something to do with when adding the htaccess file unable to do something about permissions also the htaccess.dist file permissions. So I just deleted the htaccess file again remember it keeps adding itself after I delete it and x out of the screen and I changed the permissions of the htaccess.dist to 777.

Did not work now all I get is another error here it is:
" No WPMU site defined on this host. If you are the owner of this site, please check Debugging WPMU for further assistance. "

Thanks.
Click to expand...

Check to see if you have a file called wp-config.php and if you do then delete that file and keep a file called wp-config-sample.php if you have a wp-config file in your domain then your site will toss this message.
 
Aequitas said:
Check to see if you have a file called wp-config.php and if you do then delete that file and keep a file called wp-config-sample.php if you have a wp-config file in your domain then your site will toss this message.
Click to expand...



:D Shit yea I finally got this mother installed and working thanks to aequitas and psycoul :bowdown:

:eek: Now I will read some more of the tutorials to see what I got to do next.

Thanks for all the help will most likely have a few more questions soon.
 
cr4zyguy said:
I've a VPS running on CPanel. Having attempted to configure WP-MU properly to use subdomains, I've discovered that you cannot edit httpd.conf directly to add in your settings or your conf will break. Good thing is I managed to find a tutorial on how to properly edit httpd.conf. Some of you may find this useful :) CPanel EasyApache and Customizing httpd.conf | Jangro.com
Click to expand...

Thanks I got the host admin to do it for me and got everything up and running now. I loaded all my templates and plugins now am setting up the main blog portal page doing its seo and looking for content and to modify the middle post area. Will start to add many blogs as sub's.
 
Since it looks like everyone interested is mentioning that "they're in" via thread reply I'll follow and do the same: I'm down for the challenge!
 
Running in last place

Hello all

I realized when I started this thread that I was behind but I had no idea how frickin' behind I was - I had no paypal account, no adsense account, no idea how a blog was any different from a regular website, no marketing knowledge, and no idea what seo or web 2.0 even was.

I couldn't even understand what SEOmike was talking about. I had nothing except years of technical and dbms programming experience, courage, and some time since I no longer have a real job.

What I have learned and done after I put a coffee pot next to my computer and kissed my wife goodby for a few months -

I investigated some keywords at wordtracker.com and I started a half dozen free blogs on blogger.com and wordpress.com, set up a adsense and an affiliate account for them, bought three related domain names with free hosting at godaddy.com and made some five page websites for them using a free html editor from Mozilla and went to some jv sites to load up on some free resale rights articles and ebooks. I edited the articles so they are unique and posted them on blogger just to get my adsense account approved - which worked btw.

I haven't spent (or made) a dime yet. But I'm not complaining - the tuition is free at wicked fire so far, and now that I know how to build a site and how ridiciously easy a blog is to build, I need to buy some hosting and move on.

I heard that dreamhost and hostgator are both pretty good hosting for wordpress blogs and I think one of you should get the affiliate comission when I sign up for cheap paid hosting, Fair is fair, right?

I read about Bam-Bams experience with changing hosts and don't want to go through that, so can anyone tell me where you would start hosting ?

Thanks in advance.
 
I had an awful experience with HostGator recently when I got my 1st dedicated. Switched to SoftLayer and I'm very happy. I have 2 DreamHost accounts and I like them very much for certain things. Their MySQL performance is horrid though so I wouldn't say they're good for WordPress unless you're not concerned about snappiness. I keep hearing good things about Slicehost - VPS Hosting.

Oh and if you're concerned about switching hosts (you should be) go with someone who uses cPanel (that'd be HostGator, NOT DreamHost) which makes moving hosts a BREEZE.
 
YAY

okay, i'm so not gonna read and think abot things anymore.

ima go fucking do something,

and stop wasting my times.

YAY!!
 
For those who don't know, socialmarker.com is a cool way to easily submit to 45 sites to update some of your more unique content. You have to go through the process of registering at each of the damn sites, but once you do that, it creates boxes at the bottom that you can copy and paste from for the sites that it doesn't autopopulate your information about your post into. I have gotten some decent results from it on a small blog I started to get my feet wet. Got some good results in linkbuilding with it, squidoo, and mybloglog.

Thus far, stumbleupon has been my highest traffic source. I've also been manually submitting to blog directories. I started in the worst niche possible to start with - making money blogging, but I will be rethinking this strategy now that I've learned a 1/100th of what's been said in this thread to reapply my newfound knowledge.

Site income to date: 2 weeks, .97 cents. My first blog.

Hope it helps someone and thank you all for providing this information and this board. Happy to be learning here.
 
Status
Not open for further replies.
Top Bottom