7 replies to this topic

[Zero_Cool]

i got some questions about mysql and php
first of all i am new to mysql i used to work with MSSQL its different connection etc
now i got the db and design for my web so my first question is
1.can i add a table named register this table will store every record of the user registration i mean instead of creating a php module for registration i will add a table and than connect to it using php
2.how i connect between my design and my page modules for example i got the ranking module this module display the user ranking status in the game and i want to put inside my module the design of my web site
3. last question if some one can help me create installation files for my web i am new to creating this so i dont know for sure
thanks for the help and sorry for the lenght of the questions :d

[haltox]

For question 1 : Do you mean you want to create a table for each user registered instead of adding rows to tables?
For question 2 : You can include other scripts in your php pages. So basically, you create a basic design for your site in .php file and then include the other .php that will be responsible for querying the statistics and showing them the way you want.

[Alexander]

You've nothing to worry about complexity in terms of a good old MySQL database with PHP, you can create a register table with the appropriate columns, and add a new row per each new user.

Within the same database, you can have other tables as well (i.e. rankings) which can interconnect with other tables (i.e. registeration table.) This is called "joining."

Feel free to browse some from the ground up MySQL and PHP tutorials and spot what is different from your MSSQL experience.

[Zero_Cool]

[ATTACH=CONFIG]4079[/ATTACH]
[ATTACH=CONFIG]4080[/ATTACH]
first photo is design of the web made by someone else
2econd photo is my ranking page i want to put the design on the ranking page how i can do that ?

[Alexander]

Unfortunately your attachments seem to not have been successfully created, try to post them with an image host and I will manually upload them if necessary.

In the mean time, are you referring to a ranking page of which displays user ranking in an automated and graphical fashion?

If you mean so, you can use both your ranking table, and your user register table in an example query:

/* Link uid columns of both tables, to form joined result set */
$query = mysql_query(
  "SELECT *
  FROM   usertable INNER JOIN uid
  ON     usertable.uid = ranking.uid");

/* Retrieve n rows from database that match, displaying each one in defined manner */
while( $user = mysql_fetch_assoc($query) ) {
  print "<span class='somefancycss'>Name: " . $user['name'] . "</span><br/>";
  print "Rank: " . $user['rank'] . "<br/>";
}

You can apply the design, and work your data automation in to it. If you mean there is a specific style they have applied other than web page design, I will have to wait and see.

[Zero_Cool]

this is the design
and this is my page for ranking
the first photo of the design i need to put on the page of rankings

[Alexander]

Can you not create a centred table in the centre of the design where you wish for it to be?

You may have to use CSS to align a div to center if you want for there to be text along with the table.

[Zero_Cool]

Edit: i Fixed Some thing now 2econd picture looks better but still how to put design on it ?

Edited by Zero_Cool, 14 August 2011 - 12:27 PM.