abrahamgarcia27
-
Posts
131 -
Joined
-
Last visited
Everything posted by abrahamgarcia27
-
i got it to work with this code, but its repeating the heading. How could i do it so it doesn't repeat it? $sql = mysql_query("SELECT * FROM newUsers2 ORDER BY member_id ASC"); $id = 'member_id'; $fname = 'firstname'; $lname = 'lastname'; $login = 'login'; $password = 'passwd'; while ($rows = mysql_fetch_assoc($sql)){ echo '<ul class="list">' ; echo '<li class="heading">'; echo '<span class="id">ID </span>' ; echo '<span class="firstname">FIRST NAME </span>' ; echo '<span class="lastname">LAST NAME </span>' ; echo '<span class="login">LOGIN </span>' ; echo '<span class="password">PASSWORD </span>'; echo '</li>' ; echo '<li class="entries">' ; echo '<span class="id">' .$rows[$id]. '</span>' ; echo '<span class="firstname">' .$rows[$fname]. '</span>' ; echo '<span class="lastname">' .$rows[$lname]. '</span>' ; echo '<span class= "login">' .$rows[$login]. '</span>'; echo '<span class="password">' .$rows[$password]. '</span>' ; echo '</li>' ; echo '</ul>' ; } ?> </body> </html> [attachment deleted by admin]
-
i am still having some trouble. The example you sent me was great, but when i try to insert the classes inside php i get errors. I am sorry i am trying to learn to code. This is what i have without getting errors <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>View Users</title> <link href="loginmodule.css" rel="stylesheet" type="text/css" /> <style type="text/css"> body { font: 11px Verdana, Arial, Helvetica, sans-serif; color: #666666; margin: 0px; padding: 20px 10px 0px; } /* general style */ .list{ margin:0; padding:0; width:840px; } .list li{ list-style: none; margin:2px 0; overflow:hidden; border-bottom:1px solid #eee; } .entries span, .heading span{ display:block; width:155px; /* (~width of list) / 5 keep in mind the boxmodel*/ float:left; padding-left:12px; border-right:1px solid #eee; line-height: 30px; height:30px; } .heading span{ background: #CAE8EA; } /* entries */ </style> </head> <body> <ul class="list"> <li class="heading"> <span class="id">ID</span> <span class="firstname">FIRST NAME</span> <span class="lastname">LAST NAME</span> <span class="login">LOGIN</span> <span class="password">PASSWORD</span> </li> </ul> <?php mysql_connect("xxxx", "xxx", "xxxx"); mysql_select_db("pacificbasintest"); $sql = mysql_query("SELECT * FROM newUsers2 ORDER BY member_id ASC"); $id = 'member_id'; $fname = 'firstname'; $lname = 'lastname'; $login = 'login'; $password = 'passwd'; while ($rows = mysql_fetch_assoc($sql)){ echo '<span class="id">' .$rows[$id]. '</span>' ; echo '<span class="firstname">' .$rows[$fname]. '</span>' ; echo '<span class="lastname">' .$rows[$lname]. '</span>' ; echo '<span class="login">' .$rows[$login]. '</span>'; echo '<span class="password">' .$rows[$password]. '</span>' ; } ?> </body> </html>
-
This query is basically for the admin control panel in order for him to see all the users that are enrolled and there he can click a link to edit the user which i haven't gotten to that part. The password is hashed, but i also wanted to pull the password as normal text. The query that i am doing show as the picture attached below. I want it to after every user it skips a line. [attachment deleted by admin]
-
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>View Users</title> <link href="loginmodule.css" rel="stylesheet" type="text/css" /> </head> <body> <table id="mytable" cellspacing="0" summary="User Table"> <caption>Pacific Basin Users </caption> <tr> <th width="150" class="nobg" scope="col" abbr="Configurations">User ID</th> <th width="150" scope="col" abbr="fname">First Name</th> <th width="150" scope="col" abbr="lname">Last Name</th> <th width="150" scope="col" abbr="login">Login</th> <th width="150" scope="col" abbr="passwd">Password</th> </tr> <tr> </table> <?php mysql_connect("xxxx", "xxxx", "xxxx"); mysql_select_db("pacificbasintest"); $sql = mysql_query("SELECT * FROM newUsers2 ORDER BY member_id ASC"); $id = 'member_id'; $fname = 'firstname'; $lname = 'lastname'; $login = 'login'; $password = 'passwd'; while ($rows = mysql_fetch_assoc($sql)){ echo '<div id="positionid">' .$rows[$id]. '</div>' ; echo '<div id="positionfname">' .$rows[$fname]. '</div>' ; echo '<div id="positionlname">' .$rows[$lname]. '</div>' ; echo '<div id="positionlogin">' .$rows[$login]. '</div>'; echo '<div id="positionpassword">' .$rows[$password]. '</div>' ; } ?> </body> </html> body { font: 11px Verdana, Arial, Helvetica, sans-serif; color: #666666; margin: 0px; padding: 20px 10px 0px; } .textfield { font-size: 11px; color: #333333; background: #F7F7F7; border: 1px solid #CCCCCC; padding-left: 1px; } h1 { color: #99CC00; margin: 0px 0px 5px; padding: 0px 0px 3px; font: bold 18px Verdana, Arial, Helvetica, sans-serif; border-bottom: 1px dashed #E6E8ED; } a { color: #2D3954; font-size: 11px; } a:hover { color: #99CC00; } .err { color: #FF9900; } th { font-weight: bold; text-align: left; } #navigation {font-size:0.75em; width:150px;} #navigation ul {margin:0; padding:0;} #navigation li {list-style: none;} caption { padding: 0 0 5px 0; width: 700px; font: italic 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; text-align: right; } th { font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; color: #4f6b72; border-right: 1px solid #C1DAD7; border-bottom: 1px solid #C1DAD7; border-top: 1px solid #C1DAD7; letter-spacing: 2px; text-transform: uppercase; text-align: left; padding: 6px 6px 6px 12px; background: #CAE8EA url(pacificbasintest/images/bg_header.jpg) no-repeat; } th.nobg { border-top: 0; border-left: 0; border-right: 1px solid #C1DAD7; background: none; } td { border-right: 1px solid #C1DAD7; border-bottom: 1px solid #C1DAD7; background: #fff; padding: 6px 6px 6px 12px; color: #4f6b72; } td.alt { background: #F5FAFA; color: #797268; } th.spec { border-left: 1px solid #C1DAD7; border-top: 0; background: #fff url(pacificbasintest/images/bullet1.gif) no-repeat; font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; } th.specalt { border-left: 1px solid #C1DAD7; border-top: 0; background: #f5fafa url(pacificbasintest/images/bullet2.gif) no-repeat; font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; color: #797268; } #positionid { position:absolute; left:40px; top:75px; } #positionfname { position:absolute; left:200px; top:75px; } #positionlname { position:absolute; left:375px; top:75px; } #positionlogin { position:absolute; left:550px; top:75px; } #positionpassword { position:absolute; left:700px; top:75px; }
-
I am creating an application that query all my users information such as: member id, first name, last name, login, and password from mysql table. The problem that i encountered is when running the query the data is displayed in one single line. I am using css to position my data. I don't know if there is a better way to position data on a table. I want the application to look as nice as it can. [attachment deleted by admin]
