Web Analytics Made Easy -
StatCounter Displaying the results - CodingForum

Announcement

Collapse
No announcement yet.

Displaying the results

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Displaying the results

    okay, now that i have my upload form, and my user database done,

    is it possible for me to have the two of them display after i click the submit button.

    ex: select user name > find the file you want to upload, then click submit

    result: LOSER <username> selected and file.

    Here are my code for it, i just need it to show as i describe, thanks!

    Process_upload
    PHP Code:
    <?php

    $db 
    mysql_connect('localhost''dangmnne_dangmnx''xxxx'); //fill in host, hostname, hostpass with your own

    if (!$db)
      {
      die(
    'Could not connect: ' mysql_error());
      }


    $db_selected mysql_select_db('dangmnne_test'$db); //fill in DBname with your own

    if (!db_selected)
    {

    die(
    "cant connect");

    }

        if (
    $_FILES["file"]["error"] > 0)
        {
        echo 
    "Return Code: " $_FILES["file"]["error"] . "<br />";
        }
      else
        {
            
    move_uploaded_file($_FILES["file"]["tmp_name"], "/home/dangmnne/public_html/hp/upload/" $_FILES["file"]["name"]);

            
    $replay "" $_FILES["file"]["name"];
            
    $replay2 "<a href=\"http://www.dangmn.net/hp/upload/" .$replay"\"><img src = \"http://www.dangmn.net/hp/image.jpg\" style=\"border-style: none\"/></a>"//replace "yoursite" with your own site

            
    $query "INSERT INTO test (replay)
    VALUES ('"
    .$replay2."')";

    $result mysql_query($query) or die(mysql_error());

    mysql_close($db);
            


    ?>

    <p>upload was sucessful click<a href="report.php"> here </a>to return</p>

    upload.php
    PHP Code:
    <html>
    <body>
    <link rel="stylesheet" type="text/css" href="main.css" />

    <?php

    $host
    ="localhost"// Host name
    $username="dangmnne_dangmnx"// Mysql username
    $password="xxxx"// Mysql password
    $db_name="dangmnne_test"// Database name

    // Connect to server and select databse.
    mysql_connect("$host""$username""$password")or die("cannot connect");
    mysql_select_db("$db_name")or die("cannot select DB");

    ?>

    <div style="width:450px; height:15px; border:1px solid black; background-color: #535353; color: white; padding: 2px;">
    <strong>Loser</strong></div>

    <div style="width:444px; height:55px; border-left:1px solid black; border-right:1px solid black; border-bottom:1px solid black; background-color: #C0C0C0; color: #000; padding: 5px;">

    <p>Please select the correct opponent.</p><br />

    <form>
    <select name="members">

    <?php
    $query 
    mysql_query("SELECT username FROM members");
    while(
    $row mysql_fetch_array($query))
    {
    echo 
    "<option>".$row['username']."</option>";
    }
    ?>

    </select>
    </form>
    </div>

    <br />

    <div style="width:221px; height:15px; border:1px solid black; background-color: #535353; color: white; padding: 2px;">
    <strong>Replay</strong></div>

    <div style="width:215px; height:85px; border-left:1px solid black; border-right:1px solid black; border-bottom:1px solid black; background-color: #C0C0C0; color: #000; padding: 5px;">
    <p>Please select the correct replay.</p><br />

    <form action="process_upload.php" method="post" enctype="multipart/form-data">
    <input type="file" name="file" id="file" />
    <br />
    <input type="submit" name="Upload" value="Submit" />
    </form>
    </div>

    </body>
    </html>
    Display_reps this is where i want it to be displayed,
    PHP Code:
    <?php

    $db 
    mysql_connect('localhost''dangmnne_dangmnx''xxxx'); //fill in host, hostname, hostpass with your own

    if (!$db)
      {
      die(
    'Could not connect: ' mysql_error());
      }


    $db_selected mysql_select_db('dangmnne_test'$db); //fill in DBname with your own

    if (!db_selected)
    {

    die(
    "cant connect");

    }

    $result mysql_query("SELECT replay FROM test");

    echo 
    "<table ALIGN='center' border='1'>
    <tr>
    <th><FONT COLOR='#000'>Replay</th>
    </tr>"
    ;


    while(
    $row mysql_fetch_array($result))
      {
      
      echo 
    "<tr>";
      echo 
    "<td ALIGN='CENTER'><FONT COLOR='#000'>" $row['replay'] . "</td>";
      echo 
    "</tr>";
       }
      
    echo 
    "</table>";

    mysql_close($db);

    ?>
Working...
X