Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Aug 2010
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Help me to develop php mysql website

    1) Project Details: (be as specific as possible): My sit www.safetytestingonline.com is under development by me. Sometimes I need some help coding difficult scripts, for example, today I cannot post data from a variable length array and update the associated table. I am self taught, and quite new to php. Example of this problem. Can you see my problem?
    PHP Code:
    <?php
    session_start
    (); 
    // Place Session variable 'recid' into local variable
        
    $recid          $_SESSION['recid'];
        
    $username    $_SESSION['name'];
        
    $school    $_SESSION['college'];
    //Connect to the database
    include_once "demo_conn.php";
    // Query members data from the database and organise it for display
    $sql mysql_query("SELECT group1, group2, group3, group4, group5, group6 FROM members WHERE recid='$recid' LIMIT 1");
    while(
    $row mysql_fetch_array($sql)){
    $group1 $row['group1'];
    $group2 $row['group2'];
    $group3 $row['group3'];
    $group4 $row['group4'];
    $group5 $row['group5'];
    $group6 $row['group6'];
    }
    ////////////////////////////////////
    // Process the form 
    if ($_POST['group1']) {
        
    $snames $_POST['snames[]'];
        
    $userGroup $_POST['group1'];
        
    $userGroup $_POST['group2'];
        
    $userGroup $_POST['group3'];
        
    $userGroup $_POST['group4'];
        
    $userGroup $_POST['group5'];
        
    $userGroup $_POST['group6'];
        
    $userGroup $_POST['group7'];
        
    $sql mysql_query("UPDATE users SET userGroup='userGroup' WHERE recid='$recid' AND userId='$snames'"); 
        echo 
    'Your group names have been updated.<br /><br />
    To return to your editing page, <a href="member_account.php">click here</a>'
    ;
    exit();
    // close if posted
    ////////////////////////////////////
    ?>




    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <head>
    <title>Edit Your User Group Names</title>
    <link rel="stylesheet" href="style.css" type="text/css" media="screen" />
    </head>
    <body>
    <table align="center" cellpadding="8" cellspacing="8">
      <tr>
        <td width="100"></td>
        <td width="160"><div align="left"> <font size="-1">Select <?php echo "$group1"?> students.</font></div></td>
        <td width="10"></td>
        <td width="150"><font size="-1">Send students to ....&nbsp;&nbsp;</font><font color="#CC0000">&nbsp;</font></td>
        <td width="30"></td>
        <td width="190"><div align="left"><font size="-1"></font></div></td>
      </tr>
    <?php
    // Query member data from the database
    $query1 mysql_query("SELECT userId FROM users WHERE managerId='".$recid."' AND userGroup='".$group1."' ORDER BY userId ASC");
    while(
    $row1 mysql_fetch_array($query1))
    {
    $firstGroup .=$row1['userId']. ' <input type="checkbox" name="snames[]" value="1" /> ' "&nbsp;&nbsp;&nbsp;&nbsp;<br /><br>";
    }
    ?>
      <form method="post" enctype="multipart/form-data" action="send_stud_gp_test.php">
        <tr>
          <td>&nbsp;<br /></td>
        </tr>
        <tr>
          <td width="100"></td>
          <td width="160" style="text-align:right;"><?php echo $firstGroup;?></td>
          <td width="10"></td>
          <td width="150" style="text-align:left;">
              <input type="radio" name="group2" value="1" />
              &nbsp;&nbsp;&nbsp;<?php echo $group2?>
            <p>
              <input type="radio" name="group3" value="1" />
              &nbsp;&nbsp;&nbsp;<?php echo $group3?>
            <p>
              <input type="radio" name="group4" value="1" />
              &nbsp;&nbsp;&nbsp;<?php echo $group4?>
            <p>
              <input type="radio" name="group5" value="1" />
              &nbsp;&nbsp;&nbsp;<?php echo $group5?>
            <p>
              <input type="radio" name="group6" value="1" />
              &nbsp;&nbsp;&nbsp;<?php echo $group6?>
            <p>
              <input type="radio" name="group7" value="1" />
              &nbsp;&nbsp;&nbsp;Deactivate student.
            <p>
              <input type="submit" value="submit" name="Send Data">
      </form>
            </td>  
        </tr>  
    </table>
    </body>
    </html>
    2) Payment Amount: Negotiable, and realistic.

    3) Payment method/ details (Paypal, check? Timeline?): Bank transfer or PayPay on satisfactory completion of each piece of work.

    4) Additional Info (about project or potential bidders): Ask me. Contact details on website.

  • #2
    New Coder
    Join Date
    Mar 2009
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Are you looking for someone to fix the problem in the code you posted alone or is the problem throughout the script?

  • #3
    New Coder
    Join Date
    Aug 2010
    Location
    India
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Send me more details about your project at info[at]addonsolutions[dot]com.

  • #4
    New Coder
    Join Date
    Aug 2009
    Location
    Cochin,India
    Posts
    39
    Thanks
    2
    Thanked 1 Time in 1 Post
    I can help you with this work


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •