Jump to content

john010117

Members
 View Profile  See their activity

  • Posts

    492

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by john010117

    Quick PHP Question

    in PHP Coding Help

    Posted

    Oh shoot. I forgot to change some variables. Sorry.

     

    <?php
$tbl_name2="members";
$myusername=$_SESSION['myusername'];
$mydn="SELECT displayname FROM $tbl_name2 WHERE username = '$myusername'";
$mydisplayname=mysql_query($mydn);
if (mysql_num_rows($mydisplayname)>0) {
   while ($row = mysql_fetch_assoc($mydisplayname)) {
      extract($row);
      if(session_is_registered(myusername)){
         echo "Welcome ".$mydisplayname." | <a href='logout.php'>Logout</a>";
      }
      else
      {
         echo "<a href='login.php'>Login</a> | <a href='register.php'>Register</a>";
      }
   }
}
?>

    Quick PHP Question

    in PHP Coding Help

    Posted

    Try this:

     

    <?php
$tbl_name2="members";
$myusername=$_SESSION['myusername'];
$mydn="SELECT displayname FROM $tbl_name2 WHERE username = '$myusername'";
$mydisplayname=mysql_query($mydn);
if (mysql_num_rows($mydisplayname)>0) {
   while ($row = mysql_fetch_assoc($result)) {
      extract($row);
      if(session_is_registered(myusername)){
         echo "Welcome ".$mydisplayname." | <a href='logout.php'>Logout</a>";
      }
      else
      {
         echo "<a href='login.php'>Login</a> | <a href='register.php'>Register</a>";
      }
   }
}
?>

    Mysql Query.

    in PHP Coding Help

    Posted 

    <?php
$host = "localhost";
$user = "user";
$pass = "pass";
$dbname = "user";

$con = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);

$query = "SELECT SUM(1) AS clicks, SUM(`clcpc`), SUM(`chcpc`) FROM `nuke_pnAffiliate_clicktracking` WHERE `pl` = 'rpu' AND  `date` > '20070228'AND `cl` IN (SELECT DISTINCT(cl) FROM rpu_sales WHERE salesman = 'ryan')";
echo $query;

$result= mysql_query($query);
$num_results = mysql_num_rows($result);
    
$row= mysql_fetch_assoc($result);

mysql_free_result($result);

echo $result

?>

    Can this be done with tables?

    in HTML Help

    Posted

    GGGGGGGGGGGRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR

     

    another rant on the way!!!!

     

    Sorry Andy but I have had no where near enough coffee today............

     

    Tables are for eating you dinner off (and displaying tabular data). Divs and CSS are what you need for layout...

     

    I need a hug.....................

     

    We should make a sticky describing the differences between tables and CSS, so that next time a person asks, you could just post a link to the sticky. That'll save you a lot of trouble.

    infinite php input=bad

    in PHP Coding Help

    Posted 

    <?php

if (!isset($_COOKIE['***'])) {
die("Do you belong here? I do not recognize you! I want cookies! Make sure your browser accepts cookies!<br><a href='../home.php'>Away From Here!</a>");
}
$conn = mysql_connect("localhost", "***", "***") OR DIE (mysql_error());
@mysql_select_db ("databox", $conn) OR DIE (mysql_error());

if ($_POST) {

   $location = $_POST["location"];
   $date = $_POST["date"];
   $venue = $_POST["venue"];

   $sql = "INSERT INTO `schedule` (location, date, venue) VALUES ('{$location}', '{$date}', '{$venue}')";
   @mysql_query ($sql, $conn);
   Header("Location:".$_SERVER["PHP_SELF"]);
}

// Do this process of user has click a file name to view or remove
if ($_GET) {
  
   $iid = $_GET["iid"];
   $act = $_GET["act"];
   switch ($act) {
      case rem:
      $sql = "DELETE FROM schedule WHERE id='$iid'";
      @mysql_query ($sql, $conn);
      Header("Location:./sched_index.php");
  exit();
      break;

      default:
      break;
   }
}?>
<html>

<body>
<a href='../maintaindir.php'>Return to Maintain Headquarters</a><br>
<a href='../home.php'>Return Home</a>

<FORM name="formcheck" method="post" enctype="multipart/form-data" onsubmit="return formCheck(this);">

<center><font size=6>Schedule Update</font><hr><br>
<table>
    <P>
<tr><td>
<LABEL for="name">Location (ex. Omaha, NE): </LABEL></td>
	<td><INPUT type="text" name="location" size="20"></td>
</tr>
<tr>
<td>
<LABEL for="name">Date (ex. April 26): </LABEL></td><td>
	<INPUT type="text" name="date" size="20"></td>
</tr>
<tr><td><LABEL for="name">Venue (ex. Downtown Boxing): </LABEL></td><td><INPUT type="text" name="venue" size="30"></td>
</tr>
<tr><td></td><td>

<input type="submit" value="submit"></td></tr>
</form></table>
<?php
echo "<br><br>These is the current schedule<br><hr><br>";
   
$sql3 = "SELECT * FROM schedule ORDER BY id asc";
$result3 = mysql_query ($sql3, $conn);
if (mysql_num_rows($result3)>0) {
   while ($row = mysql_fetch_array($result3, MYSQL_ASSOC)) {
      $ic++;
      $str3 .= $ic.". ";
      $str3 .= "<a href=\"sched_index.php?iid=".$row["id"]."&tbl=schedule\">".$row["location"]."</a> ";
      $str3 .= "[".$row["date"]."] ";
      $str3 .= "[".$row["venue"]."]<br> ";
      $str3 .= "[<a href=\"sched_index.php?act=rem&iid=".$row["id"]."&tbl=schedule\">REMOVE</a>]<br><br>";
   }
   print $str3;
}
mysql_free_result ($result3);?></body>
</html>

     

    I cleaned up some mistakes. Also, try not to use short-hand tags.

    Help with a php Admin CP with various access levels

    in PHP Coding Help

    Posted

    I don't know if it's a coincidence or not, but right now, I'm designing an Admin CP for my website too.  :o

     

    Anyways, to store a password that has been hashed (md5):

    $password = $_POST['password'];
$password = md5($password);

    ... and just use the $password variable when inserting it into a database.

     

    Same thing goes with checking to see if a password a user entered matches the hashed version of the password stored in the database, except you'll need one more variable.

     

    md5 is just another function. Read more about it here

     

    Sessions

    Help with tables

    in HTML Help

    Posted

    Mind if I join the "discussion"?

     

    I agree with both of you that CSS should be used on a normal page. I also agree that tables are for tabular data ONLY. That being said, the diagram shown to us looks like a profile of some sort (like MySpace). When I viewed the source of a random MySpace page, it showed that they primarily used divs. Now, I'm not saying MySpace is the only example of profiles. But logically thinking, the world's most-visited profile site uses CSS.

     

    So, in my opinion, a profile should be considered as a "normal page". But let me emphasize that there is no right solution. Feel free to use tables or CSS. But please post this in the freelancing section if you want somebody else to do it for you.

    html question

    in HTML Help

    Posted

    I don't really get what you're saying...

     

    So for your first question, you want the "Thank You message" in a textarea? Why did you mark it as "hidden" in the first place?

    <textarea name="item_number">Thank you for your generous donation. Your donation will be used to pay for  our ever increasing bandwidth costs, our hosting Se</textarea>

     

    But your second question makes no sense to me. Care to elaborate?

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.