Can you help me build my homepage?
By beauty_ph
@beauty_ph (2749)
Philippines
May 25, 2007 8:16am CST
I am about to finish my webpage design programming subject in my masteral class. I'd like to ask if you can help me with my homepage. I want to create a database in mysql where I can output in my main page the exact date and time transactions were done by the user. How can I possibly normalize my tables and database?
1 person likes this
5 responses
@tested0002 (60)
• South Korea
27 May 07
Hi beauty ph. Una sa lahat magandang umaga sayo.
I recommend you to visit www.joomla.org and download the award winning Content Management System (CMS) that will help you built websites ang other powerful online applications, Best of all, Joomla is an open source solution that is freely available to everybody.
1 person likes this
@beauty_ph (2749)
• Philippines
27 May 07
Thanks for the link you gave. I'll try Joomla, welcome to mylot too. God bless!
@beauty_ph (2749)
• Philippines
31 May 07
I mean user transaction like changing its own password in the web, or changing nickname of users. Also I want to know how can I record time and date with each transactions done like purchasing or donations.
@monkeykingaround (896)
• United States
3 Jun 07
It's hard to help, if you don't show in detail what you have so far. Assuming that you have mysql and php in your hosting service, have you create a database yet? You need to write a sql script for creating a database and tables. Search online for the appropriate SQL queries. You write all those sql queries in a file and if you have access to phpmyadmin you can upload that file and the database and tables will be create.
Is this like an auction site or something?
1 person likes this
@cobrastrike (6)
• United States
11 Jun 07
How much do you know about PHP, and MySQL? I am guessing that you are new to the block. As so, the date and time functions are really quite simple in PHP. They are as follows
time();
date();
You can customise what each one show exactly, but if you start with those, that is good. To store those values to a database is really quite simple also. I would suggest storing those with an IP Address so you can better set apart users. IP addresses are easy to as well.
$_SERVER['REMOTE_ADDR'];
To store this to the database you will need a table already setup in your database. Or alternatively you have have it create the table first time. If you need more help, feel free to message me here on MyLot.
1 person likes this
@beauty_ph (2749)
• Philippines
3 Jun 07
I want to add in my page a link where memebers can make donations and can track it too. It will be a proposed site for the church. I wanted to apply my online/programming knowledge for me to work as volunteer in a church organization in our city.
@beauty_ph (2749)
• Philippines
12 Jun 07
You are a great helper for me. Yes am new user of mysql and php. I just wanted to make a website for our church and for the community. Please help me because I want to record: example if a user has its own login, and decides to donate for the community, I also want that each of the transactions made are recorded in the database with date and time. I also want to know how to let the user see its own donations when he is online and make transactions like change password/profile/etc. Thanks for helping my friend! God bless you always!
@beauty_ph (2749)
• Philippines
3 Jun 07
I have not published it online. I made one local host for my pc and for mastery only. My friend can you give me some php/mysql tips?
@hendraktp (150)
• Indonesia
22 Jul 07
You can used function in php and than you insert into table...
1 person likes this
@beauty_ph (2749)
• Philippines
22 Jul 07
Thank you my friend for the help. I really appreciate what you suggested here. God bless and have a great day ahead.
@JoyceP2007 (230)
• United States
22 Jul 07
I found it helpful with my website to hire a professional programmer. That way I can have people automatically submit articles and it post immediately. Then I added a discussion forum yesterday. I tried it with the php and mysql but it was giving me a major headache. Plus, I messed up how to code the header.php for the entire site. It wouldn't work in the sub-directories. For fine tuning I think it's best to stick with a programmer.
1 person likes this
@beauty_ph (2749)
• Philippines
22 Jul 07
Yes I am not a programmer. But I am tryng to become one. LOL. It can give headache as a start, but I believe with constant practise I can do it. I am still patient learning things here. God bless!
