Non programmer needs help with database link, etc.

[Kody]

Downloaded the files, and I'm having no luck figuring out how to link the PixelPost with a database. I'm a graphic designer by trade, and I can't seem to make heads or tales out of the various programming terms used in the set-up. Example, the following makes absolutely no sense to me, and I've got no idea what info goes where, or where to get said info. If anyone has time to make a walkthorugh on setting up PixelPost with the cPanel system, I'd be forever grateful.

$pixelpost_db_host = "replace_me"; // database host, often "localhost"
$pixelpost_db_user = "replace_me"; // database user
$pixelpost_db_pass = "replace_me"; // database user password
$pixelpost_db_pixelpost = "replace_me"; // database

[Kody]

Also wanted to add a little more info about my project. I've got a hardcoded site that functions well for what I need. So I've been searching for a simple BLOG or CMS to help me maintain the site without having to edit pages every time I want a new graphic. PixelPost seems to be the best match.

http://www.kodychamberlain.com

Have a look at my site if you'd like and perhaps someone knows of a template that matches best with the layout. It seems that most Blog galleries create thumbnails in a straight row, so i'm not even sure if I'll be able to alter it enough to plug into my table cells. I've got some javascripting and some graphics padded around each of the images.

I have yet to find a solution that works for the layout, and I'd really rather not have to use a generic look to the site.

I may end up just having to hire a programmer to build a custom package for me.

:(

[Anonymous]

$pixelpost_db_host = "replace_me"; // database host, often "localhost"
$pixelpost_db_user = "replace_me"; // database user
$pixelpost_db_pass = "replace_me"; // database user password
$pixelpost_db_pixelpost = "replace_me"; // database

I suggest you have a mysql database, an example:

$pixelpost_db_host = "my_computer_name"; // database host, often "localhost"
$pixelpost_db_user = "kayjay"; // database user
$pixelpost_db_pass = "kayjay"; // database user password
$pixelpost_db_pixelpost = "pix"; // databasename

Wich means:
the computername is your computers hostname.. like localhost, an external ip or name
db_user.. the user you use to access mysql
db_pass = the users password to access mysql
db_pixelpost = the database name you're going to put the tables in.
in mysql: Create database pix.

[Kody]

$pixelpost_db_host = "replace_me"; // database host, often "localhost"
$pixelpost_db_user = "replace_me"; // database user
$pixelpost_db_pass = "replace_me"; // database user password
$pixelpost_db_pixelpost = "replace_me"; // database

I suggest you have a mysql database, an example:

$pixelpost_db_host = "my_computer_name"; // database host, often "localhost"
$pixelpost_db_user = "kayjay"; // database user
$pixelpost_db_pass = "kayjay"; // database user password
$pixelpost_db_pixelpost = "pix"; // databasename

Wich means:
the computername is your computers hostname.. like localhost, an external ip or name
db_user.. the user you use to access mysql
db_pass = the users password to access mysql
db_pixelpost = the database name you're going to put the tables in.
in mysql: Create database pix.

I really appreciate the feedback, but this is still over my head. Probably gonna have to find something else besides PixelPost. Something with a step by step since I have no PHP or MySQL experience at all.

[Connie]

well, every program which uses a database will need the info to connect to this database

every programm which uses a databases nees the info:

name of the server
name of the database
User-ID
User-Password

this is nothing special PixelPost related
if you have a MYSQL database at your webspace, you must have the information how to use it
if you don't have it, ask the support of your hoster
it is nothing what we can guess, your hoster must tell you
in some panels (I don't know CPANEL that much) you will find the info or at least a link to the support

if you want to use the database, you will need this information
if you don't want to use the database, but want to have a photoblog, you must look for a text-file based script, also called flat-file script

but with them you will never have as much possibilities as with database-driven scripts


and about the layout: this is separated from the script in templates, so you will have to find out which template you like or maybe work on the CSS yourself

what I find frustrating is, that you are a layout person and tell us that you have no knowledge in PHP and MYSQL. Well, for me Layout is difficult, understanding photoshop for example, but why you say you use Javascript and don't understand PHP?

1. Javascript is complicated as well, Photoshop for me is very complicated...
2. You must not know PHP, you must not know MYSQL
3. You just must know how to login. Whenever you bought a train ticket or used an ATM, you have to do some basic steps without understandind the system behind

that's the same with the MYSQL data. You just must know these 4 things and then it will work.

What is so difficult? Your Host-Support will tell you these 4 informations

try it! :D

if it works ok, then you might start to modify some templates etc, for your graphic needs

good luck, Connie

[Kody]

well, every program which uses a database will need the info to connect to this database

every programm which uses a databases nees the info:

name of the server
name of the database
User-ID
User-Password

this is nothing special PixelPost related
if you have a MYSQL database at your webspace, you must have the information how to use it
if you don't have it, ask the support of your hoster
it is nothing what we can guess, your hoster must tell you
in some panels (I don't know CPANEL that much) you will find the info or at least a link to the support

if you want to use the database, you will need this information
if you don't want to use the database, but want to have a photoblog, you must look for a text-file based script, also called flat-file script

but with them you will never have as much possibilities as with database-driven scripts


and about the layout: this is separated from the script in templates, so you will have to find out which template you like or maybe work on the CSS yourself

what I find frustrating is, that you are a layout person and tell us that you have no knowledge in PHP and MYSQL. Well, for me Layout is difficult, understanding photoshop for example, but why you say you use Javascript and don't understand PHP?

1. Javascript is complicated as well, Photoshop for me is very complicated...
2. You must not know PHP, you must not know MYSQL
3. You just must know how to login. Whenever you bought a train ticket or used an ATM, you have to do some basic steps without understandind the system behind

that's the same with the MYSQL data. You just must know these 4 things and then it will work.

What is so difficult? Your Host-Support will tell you these 4 informations

try it! :D

if it works ok, then you might start to modify some templates etc, for your graphic needs

good luck, Connie

That's a lot of good info. I don't really have any fear of learning PHP or MySQL, the real problem is I can't afford the time to learn it. I do a comic book full time and also run a graphic design studio where most of my work is print design.

My free time is usually spent eating or sleeping.:D

It's really the reason I was looking for something opensource that I could figure out without much studying. I may pick up a book on this stuff and try to work some of the problems, but as of now I'll probably have to stick with editing the site via HTML until I can.

[Connie]

It's really the reason I was looking for something opensource that I could figure out without much studying. I may pick up a book on this stuff and try to work some of the problems, but as of now I'll probably have to stick with editing the site via HTML until I can.

if you think of OpenSource, some are small, clear and transparent like PixelPost, some other programs are quite heavy lile Nuke or others, but all are Open Source...

well Kody, PixelPost is OpenSource and when you once have edited the database information and installed the program, you will only have to edit the stylesheets or the templates

that's why I don't understand your fear. So many people confirm that it is really easy to install and to use...

if you need some help, I can assist you, you could send me email with the data and I could help you to install it

good luck,
Connie