Need Help With Designing A Website With Database - We need some help!! :)
free web hosting
Free Web Hosting > Computers & Tech > Databases

Need Help With Designing A Website With Database - We need some help!! :)

MarkBla
Dec 15 2005, 04:46 PM
Me and my friend are building a website for friends, were they can login with their own username and password.
On the site our friends can react on polls, and that kind of stuff. We want to get this in a database, wich only we 2 can see.
Can someone tell us how we have to do this?

Greetings, Mark&Guido

Reply

abhiram
Dec 15 2005, 04:58 PM
Use a CMS (Content Management System) like Mambo or PHPNuke. They'll do everything for you with databases, polls and user ids. There are plenty of CMS's available on the net, but these are the ones I know about.

Reply

Houdini
Dec 15 2005, 11:15 PM
You would definately want to use a CMS like abhiram said, and with a hosting account you could choose either Mambo or PHP-Nuke which I am more partial to since I run four PHP-Nuke sites , two running with Invision board forums and two with phpBB2 forums.

You can make them anyway you want (within possibilities of the system) and they are very easy for someone who has never run a site before. Basically all you have to do is create a database populate it then upload the edited config.php file that tells your database about where to find its info and set it up.

Or I think if you use one of the ready to go CMSs from astahost all you do is click the link in the cPanel then set up your Admin information then go to your new site and proceed to set it up the way you like.

Reply

Bio
Dec 30 2005, 07:01 PM
If you want to code it yourself create a table that will consist of 2 columns: user name and password hash. This you will need for your user's data storing. If there is a guest book on your site create a table with may be 4 columns that are: record id, name of a user who posted it, his e-mail address and a text of a message. Something like this smile.gif

Reply

kook
Dec 31 2005, 04:07 AM
make check session for stuff and make table for stuff

make new table by use phpMyAdmin

make check session for stuff
but you must have start session function in process login page same this
CODE
session_start();
          $_SESSION[sess_userid]=session_id();
          $_SESSION[sess_username]=$username;
          header("Location:where");

here is code
CODE

<?
session_start();
$sess_userid=$_SESSION[sess_userid];
$sess_username=$_SESSION[sess_username];
if ($sess_userid<>session_id() or $sess_username=="")
{
header("Location:index.php(or where that you need)");
exit();
}
$host="localhost";
$user="username";
$pass="password";
$dbname="database name";
$connect=mysql_connect($host,$user,$pass);
if(!$connect)
{
echo"Can't connect to sql";
exit();
}
$sql="SELECT * FROM tbname WHERE username(field that is username)='$sess_username' ";
$result=mysql_db_query($dbname,$sql);
$num=mysql_num_rows($result);
mysql_close();
if ($num<=0)
{
header("Location:index.php(or where you need when he or she don't have permission)");
exit();
}else{
}
?>

wink.gif
to use
insert the following code into page that for staff
CODE

<?php
include "name of check session page that you saved";
?>

 

 

 


Reply

Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : designing website database

  1. Some Useful Database Links. - (7)
  2. MySQL Output Database Question - (18)
    I am new to MySql and have just created a database after using a script. My problem is not the
    script, but what it says about putting it into the output file. I cant figure out the right terms
    to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
    'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
    please help me out?...
  3. Any Website Provide Free Host Mysql Host? - (4)
    any website provide free host mysql host? i need it because i am using 000webhost.com now but it
    only provide 2 mysql database... can i know where or how can i get more databases regards...
  4. Accessing Ms Access Database From A Centralized Location? - (5)
    Hi I am a manager at a trading/wholesaling company (and have no programming background). I
    customized the Northwind sample access database to make invoices and keep accounts for my company.
    We now opening another office at a distant location. So, the order entry will be done at two
    points(we plan to use the same Access database). I am not able to figure out how to access the same
    MS Access database from two different location(as LAN can't be used). Moreover, we can't
    afford to pay huge sums to the software developers. Can intranet or uploading the database t...
  5. Space Needed For Database - (10)
    Iam assuming the information in the databases i will create will be stored in the 500 MB space i
    get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
    following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
    present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
    and big int...
  6. Database Access On Remote Server W/jsp - (0)
    Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
    Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
    connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
    not sure exactly what needs to be packaged with my Java application to make it work. Since I
    don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
    JDBC driver would be bundled with my site but not sure. Thanks!...
  7. Mysql Database Entry By Excel Sheets - (2)
    Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
    mysql database. Thanks...
  8. Mysql Database Management - (1)
    Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
    to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
    following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE
    (Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed
    database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.
    Consider that BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20....
  9. Mirror My MySQL Database To Another Mysql Server - (4)
    Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
    server?or create a small php script to do this? The reason is because, we all know that database is
    very improtant if we have dynamic website. I have my forum hosted and i want to automatically
    mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
    that i forgot to backup my database..also i have one central backup database. Thanks for the
    help..Im looking forward for this posibility....
  10. Integrate Access Database Onto Intranet Site - Looking to integrate access database into my intranet site (5)
    Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
    emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access,
    it consists of multiple forms which i plan to host on an intranet website, i need to be able to add
    records directly from the form on the intranet website aswell as being able to edit/review current
    entries on forms in the database. My question is, how would i go about integrating these forms onto
    the intranet website? i plan on keeping the database and the intranet site on the s...
  11. Database - prblem with it (1)
    i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
    edit its config.php right and but my database name and my user name and password every thing right
    and when i try to install it it gives me this error can`t connect to database please choose
    file from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend...
  12. Connecting To A Remote Database - (9)
    I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
    through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
    - Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
    the IP of server C. Though I am having trouble connecting from server C which is with a different
    webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
    only be used to connect a client - e.g. my pc to the remote server A. I do not ha...
  13. Permission Problem With Mysql Database Creation - Please Help! (8)
    I seem to have a problem with accessing my database with proper permissions. I have set the my
    database correctly giving my db username all priviliges yet i seem to be unable to even log on with
    this username with a denied access error. Any ideas on resolving this?...
  14. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database - (4)
    Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
    good practice to directly store images and other binary files in a MySQL database. Any one with
    help? Thanks...
  15. Need Help In Database Auto_increment - (9)
    i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
    be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
    was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx...
  16. Embedded Database - Embedded Data base at client side, (7)
    Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
    db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
    1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
    EDB Cheers Arunkumar.H.G...
  17. Need Advice On Creating Online Music Database - ps - dont know anything about databases! (6)
    I need to create a database of around 1000 music albums that I can put on my site, with the ability
    to search the database according to several different criteria. Being a complete and total NOOB to
    the world of databases, can anyone point me in the direction of some software that will let me
    create a good-looking and functional database, but that isn't too complicated for me to
    use?! Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
    Topic edited to reflect content better. ...
  18. Learning Php/sql Basics - Want to learn CSS, PHP and create a website (17)
    Hello, I've been wanting to learn to create websites for a long time. I'm not sure how hard
    it will be and how long it will take to learn enough to make my own database-driven website. I
    studied SQL, basic programming, worked with databases and am familiar with HTML tags, but this all
    was for work, university and I never paid a lot of attention to details. In the past few days I read
    beginner's tutorials on PHP/SQL, CSS and even HTML. Now I want to create a simple database with
    some tables to practice with PHP scripts for a website, write and read database i...
  19. The Best Database - What do you think is the best database? (48)
    Ive been planning to create a online application which requires tons of stuff from database. Ive
    been using interbase, at first it was good but after a month i find it not user friendly at all...
    Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?...
  20. phpBB Database Transfer - Anyone here knows how to? (10)
    Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
    transfer the datas(users,configs, all of them) contained in my current forum to another one in
    phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
    to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
    in advance, hope anyone here knows how to....
  21. My Sql Database Help? - (3)
    Ok, i am new at web design, i dont know too much about it... I was working on a website for about
    a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
    of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
    acquire the URL of the database or any information i dont know what it means at all.. i just want to
    do a simple login feature, i mean this is my first website and i am learning so I think it would be
    a great feature to add in and learn. i can create data bases from there but do n...
  22. Database Size? - So how big is everybody's MySQL database? (10)
    Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
    databases were? Do you have really big ones, or are they relatively small? Also what do you store in
    them? (just text, or binary data as well)...
  23. How Many Concurrent Users For Oracle Database? - This is to analyse and get perfect result for How many concurrent use (1)
    Hi friends, How many concurrent users can practically access the oracle database?
    they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
    number of concurrent users depend on any other factors as wel? I think depend on parameter
    1.session 2.processes session Specific connection of a user to an Oracle instance through a user
    process. A session lasts from the time the user connects until the time the user disconnects or
    exits the database application. Multiple sessions can be created and exist concurrently for ...
  24. Database Programming In Vba 6.0 - (1)
    hi , i need some sample program in database.thanks...
  25. Need Info On Database Programming Courses - Oracle Database Programming (2)
    I know Database Programming on MS-ACCESS, now i am planning to go for some other Database
    Programming courses, People told me to go for Oracle or VisualAge. Can anyone told me to start with
    which one and how long is the course period and which one is easy and is it similar to ms access or
    somthig different....
  26. Database Program With GUI - (14)
    I am looking for a program to create SQL databases through a GUI to simplify it, the only things i
    can seem to find are command prompt things and i can't work with them. I like MS access and
    would like something similar to that if possible. I am working with windows at the moment can anyone
    recommend a program i can use (preferably free) Many thanks...
  27. What Is Maximum Capacity Of Astahost MySQL Database? - (11)
    I'm sorry about this topic. I'm a new user and my english is not very good. I want to learn
    the max capacity of mysql db....
  28. What Is A Database How Do I Use One? - : Information about Databases and how to get use them efficiently (7)
    Hello All Let's start off by talking about what a database is and how it would be efficient
    in using it. It wasn't until about a year and half ago now that I was first introduced to this
    new age of Database. I discovered a lot of neat things and even learned about databases the very
    long way. A database is exactly how it sounds its data that has a base. The base being the place
    where you store all your data. If you have ever been to a library perhaps you have used the Index to
    search for an author, this is a database of authors. Ever seen a rolodex on someo...
  29. Using pbpBB2 And Mediawiki Common Database - (3)
    I want to host phpbb2 forum and one wiki software (not sure whcih one at this point). Can someone
    help me how to use a common or shared database for both these applications? The user data, login
    could be common on both databases. Any inputs are appreciated. Thanks ...
  30. The Best Database - databases (41)
    te best database for my is sql server yukon for you?...



Looking for designing, website, database

Searching Video's for designing, website, database
Some Useful
Database
Links.
MySQL Output
Database
Question
Any Website
Provide Free
Host Mysql
Host?
Accessing Ms
Access
Database
From A
Centralized
Location?
Space Needed
For Database
Database
Access On
Remote
Server W/jsp
Mysql
Database
Entry By
Excel Sheets
Mysql
Database
Management
Mirror My
MySQL
Database To
Another
Mysql Server
Integrate
Access
Database
Onto
Intranet
Site Looking
to integrate
access
database
into my
intranet
site
Database
prblem with
it
Connecting
To A Remote
Database
Permission
Problem With
Mysql
Database
Creation
Please
Help!
Is It A Good
Practice To
Store Image
Or Other
Binary Files
Directly In
A Mysql
Database
Need Help In
Database
Auto_increme
nt
Embedded
Database
Embedded
Data base
at client
side,
Need Advice
On Creating
Online Music
Database ps
- dont know
anything
about
databases
3;
Learning
Php/sql
Basics Want
to learn
CSS, PHP and
create a
website
The Best
Database
What do you
think is the
best
database?
phpBB
Database
Transfer
Anyone here
knows how
to?
My Sql
Database
Help?
Database
Size? So how
big is
everybody
9;s MySQL
database?
How Many
Concurrent
Users For
Oracle
Database?
This is to
analyse and
get perfect
result for
How many
concurrent
use
Database
Programming
In Vba 6.0
Need Info On
Database
Programming
Courses
Oracle
Database
Programming
Database
Program With
GUI
What Is
Maximum
Capacity Of
Astahost
MySQL
Database?
What Is A
Database How
Do I Use
One? :
Information
about
Databases
and how to
get use them
efficiently
Using pbpBB2
And
Mediawiki
Common
Database
The Best
Database
databases
advertisement




Need Help With Designing A Website With Database - We need some help!! :)



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!" 		Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE