HELP - How to add multiple rows selected by a checkbox to the database

benardik · April 24, 2011

Hi,

I am new to php and need help.

I am building a library system for an assignment.

I want to provide a functionality that registers (adds) all transactions to defferent databases.

I am stuck on how to add a selected row (selected by a checkbox) to the database and make sure that 2 users cannot update the same record at the same time.

Thanks for your help.

bellow is my code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title>Web Works DD - Web Development & Software Solutions</title>
         <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
      <link rel="stylesheet" type="text/css" href="css/style.css" /> 
  
  </head>
  <body>
  <!--<div class="utilities">
         <!-- UTILITIES MENU --
      <a href="index.php" style=text-decoration:none;><img src="images/home.png" border="0" alt="Home Page"/> Home Page</a>    <a href="sitemap.php" style=text-decoration:none;><img src="images/sitemap.png" border="0" alt="Sitemap"/> Sitemap</a>
        </div><!-- END UTILITIES -->

  <div id="right_bar">   <!-- right bar starts here -->
  </div> <!-- end of right bar -->

  <div id="top_bar">   <!-- top bar starts here -->
  <a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/mainLib.jpg" border=0 style=height:180;/> </a>
  <img src="images/topText.jpg" border=0 style=height:180;/>
  </div> <!-- end of top bar -->
        
<div id="container">
<div id="top-logo"> 
  <!--<a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/Main_logo.jpg" border=0 /> </a> -->
  </div>   
         
     <ul class="dropdown dav">
     <li><a href="index1.php">HOME</a></li>
     <li><a href="#" class="dir">VIEW RWSOURCES</a>
      <ul>
         <li><a href="books.php">BOOKS</a></li>
         <li><a href="dvds.php">DVDS</a></li>
         <li><a href="journals.php">JOURNALS</a></li>
    </ul>
   </li>
   <li><a href="staffLogin.php">STAFF ZONE</a></li>
    <li><a href="studentsLogin.php">STUDENT ZONE</a></li>
   
</ul>

<table>
<!--This defines a new form -->
<form action="" method="post"> 
<!--This creates the dropdown in html-->
<select name="fields"> 
<option value="1">Please select...</option>
<option value="isbnno">isbnno</option>
<option value="title">title</option> 
<option value="description">description</option>
<option value="author">author</option>   
</select> 
</td>
</tr>
<tr>
<td>
<input type="text" name="value" size="40">
</td>
</tr>
<tr>
<td>
<!-- Create a button -->
<input type="submit" value="Select" name="select"> 
</td>
</tr>
</form> 
</table>

<?php
session_start();
include("secure/db_open.php");
       /* $myusername=$_SESSION['myusername']; 
        echo $myusername;
        $insert = $checkbox[$i];
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = '$myusername'";  
        $uido = mysql_query($userid); 
        $row = mysql_fetch_array($uido);
        echo $row['id'];    */
        
        
  
// get variable after selecting something from the dropdown with name 'fields'

$select = $_POST['select']; 
$valu = $_POST['value'];
// if something has been chosen
if (!empty($select)) 
{ 

$fields = $_POST['fields'];  //get the chosen value
$allbooks="SELECT * FROM books WHERE {$fields} = '$valu'";
//select books that are available - driven by the user's input
$copas="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies > 0";
$copy = mysql_query($copas); 
//count the number of rows resulting from the query
$count=mysql_num_rows($copy);
//$copse = mysql_fetch_array($copy);

//select books that are not available
$notavailable="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies = 0";
$shownotavailable=mysql_query($notavailable);
$count1=mysql_num_rows($shownotavailable);

//display a form 
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($copy)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value=".$row['bookid']."></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='loan' type='submit' id='loan' value='Loan Book'></td>";
echo "</tr>";
echo "</table>"; 

if (isset($_POST))
{
      session_start();
        $myusername=$_SESSION['myusername'];     
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = $myusername";  
        $uido = mysql_query($userid); 
        $row1 = mysql_fetch_array($uido);
        $sid = $row1['id']; 
        
    for ($i=0;$i<$count;$i++)
    {   
        $insert = $checkbox[$i];
       //echo "Welcome, ".$row['id'];
        $insertloaned="INSERT INTO studentloanedbooks(studentid, bookid, noofcopies) VALUES ($sid, $insert, $cops)";
        $loaned = mysql_query($insertloaned);
            
    }   
     
}  
    
if($count1>0)
{
    //display the books details
    //display a form 
echo "<br>";
echo "<br>";  
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($shownotavailable)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value='.$row[bookid]'></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='reserve' type='submit' id='reserve' value='Reserve Book'></td>";
echo "</tr>";
echo "</table>"; 

    
}



}
// include("secure/db_close.php");   


//include("secure/db_close.php");  
?>
   


<!--if($cop>0){  -->



<!-- this is my footer div -->
<div id="footer">
Copyright © 2010 | <a href="privacy.php">Privacy Policy</a> | <a href="terms.php">Terms of Service</a>
<img src="images/mini_logo1.png" align="right" style="margin-right:5" />
</div>   <!-- End footer div -->

    </div>
    </div>
  </body>
</html>

MOD EDIT:

 . . .

BBCode tags added.

Pikachu2000 · April 24, 2011

When posting code,please enclose it within the forum's

 . . .

BBCode tags.

Sign In

HELP - How to add multiple rows selected by a checkbox to the database

Recommended Posts

benardik

Link to comment

Share on other sites

Pikachu2000

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information