PHP - Moved: Insert Checkbox Value To Database

Hello again,

I have a form that has several options to select features of a computer (vga, dvi, ethernet, modem, zip, etc.) through checkboxes. In the database, it is stored as a 0/1 (false/true). What I am working on is an edit form to make changes if necessary, but I am having trouble populating the checkboxes that are marked as true already.

Code: [Select]
while($cmp = $_SESSION['DB']->fetch_array($cmpQ)){
$chkbxs = array('vga', 'ps2', 'usb', 'firewire', 'ethernet', 'cddvd', 'fdd', 'zip', 'dvi', 'serial', 'sound', 'wireless', 'modem', 'smartm');
foreach ($chkbxs as $value) {
$check="";
if ($cmp[$value] == 1) {
$check = "checked";
echo ''.$value.' <br/>';
}
...more code, form below
This does it it should. I have an entry with vga, firewire, smartm, and zip selected, and $value returns that properly.

In the form, this is how I have it set up.
Code: [Select]
echo '<input type="checkbox" name="hardware[]" value="vga" '.$check.'>';
Right now, every checkbox is selected, meaning that for some reason, $cmp[$value] == 1 is affecting all checkboxes in the form, even though it is only returning the 4 that are marked as selected when I echo $value.

Am I missing something minor or am I going about this the wrong way?

Hi I wondering what i did wrong he
I wont to register 1 or 0 into database. 


Checkbox file:
  <?php 

hi all

I have 3 checkboxes whose values are getting stored in the database with a comma separator.

Code: [Select]
<input name="color[]" type="checkbox" value="red" id="red" />red 
<input name="color[]" type="checkbox" value="blue" id="blue" />blue
<input name="color[]" type="checkbox" value="green" id="green" />green

values getting stored with comma separator

Code: [Select]
red, blue, green

now i want to show the checkboxes as "checked" to show the customer as which colors they chose lasttime when they submitted the form.

How can i make it possible ?

If it is possible without the comma separator then i can remove the comma.

vineet

Trying to get a form to display checked and unchecked values based on what is in the database.

Hard coded form works fine. I implode the array and it goes into the database as a comma delimited string.

But I need to let users edit the checkbox values, so I need to create the form by exploding the string, iterating through the array, and outputting the checkbox form elements.

Here's what I have...

Code: [Select]
<p>Specialization:
<p>
<?php

//echo $session->userinfo['specialization']; THIS DISPLAYS THE STRING CORRECTLY
 
$aSpecialization = array('Automotive', 'Aerospace', 'Biotech/Life Sciences', 'Chemicals', 'Damages Analysis', 'Electronics', 'Litigation', 'Manufacturing ', 'Materials', 'Medical Devices', 'Mobile Applications', 'Patent Prosecution', 'Physics', 'Renewable Energy', 'Semiconductors', 'Software', 'Telecommunications', 'Utilities');
 
//converting comma separated into array using explode function

  $dbspecialization= explode(',',$session->userinfo['specialization']);
  
  // echo $dbspecialization; THIS IS CONFIRMED AS AN array
 
  foreach ($aSpecialization as $specialization) {
 
     if(in_array($specialization,$dbspecialization)) {
      echo '<input name="specialization[]" type="checkbox" value="$specialization" CHECKED> $aSpecialization[] <br />';
          } else {
      echo '<input name="specialization[]" type="checkbox" value="$specialization"> $aSpecialization[] <br />';
          }
    }
?>

But the output I get is...

Code: [Select]
<input name="specialization[]" type="checkbox" value="$specialization" CHECKED> $aSpecialization[] <br />

<input name="specialization[]" type="checkbox" value="$specialization"> $aSpecialization[] <br />

<input name="specialization[]" type="checkbox" value="$specialization"> $aSpecialization[] <br />

etc...


What am I missing?

 

Basically i made a form with checkbox using post.. here's the form

Code: [Select]
<?php echo '<form name="formupload" method="post" action="val3.php">';
echo '<input type="image" src="images/reject.png" name="test" width="170" height="35" border="0" value="reject">';
echo "<table border=\"5\" >";
echo "<tr><th>List of Instructor</th>";
    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
echo "<tr><td>";
    echo "<input type='checkbox' name='list[]' value='".$row['fullname']."'>" .$row['fullname']."<br/></td>"; 
    echo "</tr>";
   } 

}
    else {
    echo "<tr><td>No one to Approve</td></tr>";  
    } 
echo '</form>'; ?>

Then my val3.php will output the values of the checked checkbox.

here's the code.
Code: [Select]
<?php

foreach ($_REQUEST['list'] as $checkbox)
{
echo $checkbox;
echo "<br/>";
}


?>




Now i don't know how to insert those values to my database.. help pls.

Hi. I want to put data from these checkboxes (example):
Jan (value = jan)
Chris (value = chris)
Tom (value = 50)
Jon (unchecked)
Put janchris50 to the database after finding correct row with user ID, which is user_id for this example.

Then, the user goes to another page and he should see this:
Jan (checked)
Chris (checked)
Tom (checked)
Jon (unchecked)
In other words - page should get the information from the database and check the checkboxes that appears to be checked in the database.

By the way, it should rewrite the row each time, as the user can modify it.

Thanks.

Hi Everyone,

Im trying to add a delete button to the message inbox page of my website, where when delete is clicked, the checked messages get deleted from the database.
After a bit of research on google i have come up with the code below however i cant get it to work. I have replaced the mysql delete query with echo "checked"; just for debugging.


$query = mysql_query("SELECT * FROM users WHERE id='$id'");
$row = mysql_fetch_assoc($query);

$submit = $_POST['submit'];
$username = $row['username'];
$checked = $_POST['message'];

$messages_query = mysql_query("SELECT * FROM messages WHERE recipient='$username'");
if (mysql_num_rows($messages_query) > 0)
{
   while ($messages_row = mysql_fetch_array($messages_query))
   {

   

if ($messages_row['message_read'] == 0) { echo "<div style='background-color:#FFCCCC;'>"; }

$message_id = $messages_row['id'];
   

echo "<a href='message.php?id=$message_id'>";

echo "From: " . $messages_row['sender'];

echo "Subject: " . $messages_row['subject'] . "<br />";

echo "</a>";

echo "<form method='POST'><input type='checkbox' name='message[]' value='1' /></form>";

if ($messages_row['message_read'] == 0) { echo "</div>"; }
   }
}
else
{
   echo "No messages";
}

if ($submit)
{

if ($checked == "1")

{

echo "checked";

}
}
?>
<html>
<form method="POST">
<input type="submit" name="submit" value="Delete" />
</form>
</html>


I have also tried the following but i still cant get it to work:

if (isset($checked))

{

echo "checked";

}


Can anybody see where iv gone wrong?

Thanks

well i got a few checbox (look below for code)
i want to make it so that if i click the checkbox's it sends all the check box value to one column with "," in between them
Code: [Select]
     
 <input type="checkbox" name="genre" value="fighting" id="genre"/>fighting
 <input type="checkbox" name="genre" value="school life" id="genre" />school life
<input name="genre" type="checkbox" id="genre" value="king" id="genre" />king
<input name="genre" type="checkbox" id="genre" value="him" />him

helo

does anyone know how to display data from db in checkbox form? i have been searching for days and still cannot find answer that i can understand. i hope someone can help me. i really am lost. any help is much appreciated

Hi,

I need to make it so the items on my page are only displayed if the value in their database column is set to 1 (and 0 for no display). And I should be able to change those values with a checkbox toggle on my admin panel.

Ideally I wouldn't have to click submit either.

Table:

<table id="datatables" class="table table-striped table-no-bordered table-hover" cellspacing="0" width="100%" style="width:100%">
                      <thead>
                        <tr>
                          <th>ID</th>
                          <th>Item name</th>
                          <th>Item group</th>
                          <th>Actions</th>
                          <th>Display</th>
                        </tr>
                      </thead>
                      <tbody>
                        <?php
                        if($result -> num_rows > 0){
                          while($row = $result-> fetch_assoc()){
                            echo "<tr>";
                            echo "<td>" . $row["id"] ."</td>";
                            echo "<td>" . $row["item_name"]. "</td>";
                            echo "<td>" . $row["group_name"] ."</td>";
                            ?>
                            <?php
                            require_once "deleteitem.php";
                            ?>
                            <td>
                              <a href="edititem.php?edit=<?php echo $row['id']; ?>" name="edit"><i class="material-icons">edit</i></a>
                              <a href="?delete=<?php echo $row['id']; ?>" name="delete"><i class="material-icons">delete</i></a>
                            </td>
                            <td>
                            <form action="displayitem.php" method="POST">
                              <div class="togglebutton">
                                <label>
                                  <input type="checkbox" name="display">
                                  <span class="toggle"></span>
                                </label> 
                              </div>
                              </form>
                            </td>
                            <?php
                            echo "</tr>";
                        }
                          }
                        ?>
                      </tbody>
                    </table>

https://i.imgur.com/Qyz6s8v.png

In displayitem.php

<?php
if(isset($_POST['display'])){
    echo '<p>'.$_POST['display'].'</p>';
	// queries etc here
}
?> 

I'm not getting the value here unless I add a submit button.

Guessing jQuery / AJAX is the way to go but can't seem to find any good tutorials on it, are there any other suitable approaches to this?

 

 

 

 

I have an audio mix submitting form on my website. The first part of the form takes the details from the user and inserts a new row in the first table 'mix', auto incrementing to generate a mix_id primary key.

The second part then uses a series of check boxes  to select which genres the mix contains and a foreach for the resulting array to insert, into the 2nd table 'genres_for_mix', a new row for each genre id (foreign key for the genres table) that is selected and the mix_id that it concerns.

Now I'm starting to think this is a bad way to do this because:

1. I don't know how to echo this out when a user edit's the mix to make all the relevant checkboxes selected.
2. When a user deselects a choice, it would be quite long winded to delete the nessesary row.


So instead I'm thinking that it would be much wiser to user the serialise functions to put the array into the database


However, I still don't know how to make the right checkboxes selected when I echo out the edit form. Do I use something like inarray()? If so how?

Also, it's really important that I can query the database for mixes that are associated with a specific genre. Without unserialising the array and therefore echo'ing out all the results, I don't know how to query this. Would I just use a 'WHERE genre_field LIKE 'genre_id'?

Can anyone help me with this please?

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:

Code: [Select]
<!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 &copy; 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: [code] . . . [/code] BBCode tags added.

Hi,

I have this form which will create a checkbox list using data from my database and also determin if a checkbox had been checked before and check if it had.

<form style="text-align:center" name="PrefRestaurant" id="PrefRestaurant" action="preferances_check.php" method="post"><table align="center"> <?php checkbox(id, name, restaurants, id); ?></table>
<input type="submit" name="Prefer" id="Prefer" value="Επιλογή"/></form>
   
function checkbox($intIdField, $strNameField, $strTableName, $strOrderField, $strMethod="asc") {
$strQuery = "select $intIdField, $strNameField
               from $strTableName
               order by $strOrderField $strMethod";
    $rsrcResult = mysql_query($strQuery);


while ($arrayRow = mysql_fetch_assoc($rsrcResult)) {
$testqry = "SELECT * FROM user_restaurant WHERE user_id = $_SESSION[UserId] AND restaurant_id = $arrayRow[id]";
$rsltestqry = mysql_query($testqry);
$numrows = mysql_num_rows($rsltestqry);
if ($numrows == 1) {
echo "<tr align=\"left\"><td><input type=\"checkbox\" name=\"restaurant[]\" value=\"$arrayRow[id]\" checked/>$arrayRow[name]</td></tr>";
}
else{
echo "<tr align=\"left\"><td><input type=\"checkbox\" name=\"restaurant[]\" value=\"$arrayRow[id]\" />$arrayRow[name]</td></tr>";
}
}

}      


Now the part which I can't get to work is when I'm trying to store the new values in my database. When I click the submit button I clear my database of any row that is related to the currently loggedin user and I want to store his new preferences (checked cheboxes). I've read that only the cheked checkboxes' values are POSTed so I did this (preferances_check.php)

foreach($_POST['restaurant']  as  $value)  {
 
 $query="INSERT INTO user_restaurant VALUES ('$_SESSION[UserId]','$value')";
 
} 

But it is not working, nothing gets written in my table Could someone please enlighten me on this? Thnks!

So I've spent 2 days now searching the web on how to make my checkbox array on my form insert the value selected by the user into my database. Here is the code that I've written. All fields except for the checkbox array works fine.

<?php virtual('/budgets/Connections/connAdmin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
 
  if (isset($_POST['submit'])) {
    $workStyle = $_POST['art_photos'];

    // Setting up a blank variable to be used in the coming loop.
    $allStyles = "";

    // For every checkbox value sent to the form.
    foreach ($workStyle as $style) {
      // Append a string called $allStyles with the current array element, and then add a comma and a space at the end.
      $allStyles .= $style . ", ";
    }

    // Delete the last two characters from the string.
    $allStyles = substr($allStyles, 0, -2);

    echo "<p>The resulting string is: <strong>$allStyles</strong></p>\r\n";

  }



if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO daily_budget (rundate, slug, reporter, budgetInfo, notes, `section`, deadline, art_photos sidebar, sBudget) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['rundate'], "text"),
                       GetSQLValueString($_POST['slug'], "text"),
                       GetSQLValueString($_POST['reporter'], "text"),
                       GetSQLValueString($_POST['budgetInfo'], "text"),
                       GetSQLValueString($_POST['notes'], "text"),
                       GetSQLValueString($_POST['section'], "text"),
                       GetSQLValueString($_POST['deadline'], "text"),
                  GetSQLValueString($_POST['art_photos'], "text"),
                       GetSQLValueString($_POST['sidebar'], "text"),
                       GetSQLValueString($_POST['sBudget'], "text"));

  mysql_select_db($database_connAdmin, $connAdmin);
  $Result1 = mysql_query($insertSQL, $connAdmin) or die(mysql_error());
}

?>

<!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>Budget Record</title>

</head>

<body>
<?php
if (isset($error)) {
   echo '<ul>';
   foreach($error as $alert) {
      echo "<li class='warning'>$alert</li>\n";
   }
   echo '</ul>';
}
?>
<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1">
  <table align="center" width="60%" border="2" bgcolor="#FFFFFF">
    <tr valign="baseline">
      <td width="14%" align="right" nowrap="nowrap"><STRONG>Rundate:</STRONG></td>
      <td width="86%">
        <input type="text" name="rundate" size="30" value="" id="jQueryUICalendar2"/>
        <script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar2
jQuery("#jQueryUICalendar2").datepicker();

// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar2
              </script></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><STRONG>Section:</STRONG></td>
      <td>
        <select name="section">
        <option value=""></option>
          <option value="A1">A1</option>
          <option value="Pickup All">Pickup All</option>
          <option value="Region">Region</option>
          <option value="Atlantic">Atlantic</option>
            <option value="Business">Business</option>
          <option value="Features">Features</option>
          <option value="Sports">Sports</option>
        </select>
     </td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Slug:</strong></td>
      <td><span id="sprytextfield2">
      <input type="text" name="slug" value="" size="32" />
      <span class="textfieldRequiredMsg">REQUIRED</span></span><span style="color: #F00; font-weight: bold; font-size: 10px;"></span></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Budget Information:</strong></td>
      <td><span id="sprytextarea1">
        <textarea name="budgetInfo" cols="50" rows="4"></textarea>
<span class="textareaRequiredMsg">Required.</span></span><span style="color: #F00; font-weight: bold; font-size: 11px;"></span></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Notes:</strong></td>
      <td><input type="text" name="notes" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Reporter:</strong></td>
      <td><span id="sprytextfield3">
        <input type="text" name="reporter" value="" size="32" />
      <span class="textfieldRequiredMsg">Required.</span></span><span style="color: #F00; font-weight: bold; font-size: 10px;"></span></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Deadline:</strong></td>
      <td><input type="text" name="deadline" size="30" value="Enter date" id="jQueryUICalendar1"/><script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar2
jQuery("#jQueryUICalendar1").datepicker();

// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar2
              </script> </td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Artwork:</strong></td>
      <td><label>
          <input type="checkbox" name="art_photos[]" value="factbox" id="art_photos_0"  />
          Factbox</label>
       
        <label>
          <input type="checkbox" name="art_photos[]" value="graphic" id="art_photos_1" />
          Graphic</label>
       
        <label>
          <input type="checkbox" name="art_photos[]" value="photo" id="art_photos_2" />
          Photo</label>
       
        <label>
          <input type="checkbox" name="art_photos[]" value="video" id="art_photos_3"  />
          Video</label>
      <br /></td>
    </tr>
        <tr>
       
    </tr>
       <tr valign="baseline">
      <td nowrap="nowrap" align="right">      <strong>Sidebar:</strong></td>
      <td valign="baseline"><span id="spryradio2">
        <label>
          <input type="radio" name="sidebar" value="y" id="sidebar_0" />
          Yes</label>
        <br />
        <label>
          <input type="radio" name="sidebar" value="n" id="sidebar_1" />
          No</label>
        <br />
        <span class="radioRequiredMsg"><strong style="font-size: 11px">REQUIRED.</strong></span></span>
       
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right"><strong>Sidebar Information:</strong></td>
      <td><input type="text" name="sBudget" value="" size="32" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">&nbsp;</td>
      <td><input type="submit" value="Insert record" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_insert" value="form1" />
</form>

<p>&nbsp;</p>
<h3><a href="/new_budget/admin/manage_budgets.php"><strong>View your budget entry, make changes or delete your budget.</strong></a></h3>
<script type="text/javascript">
<!--
jQuery("#jQueryUICalendar1").datepicker();
jQuery("#jQueryUICalendar2").datepicker();
var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "none", {maxChars:15, validateOn:["change"]});
var sprytextarea1 = new Spry.Widget.ValidationTextarea("sprytextarea1", {validateOn:["change"]});
var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3");
var spryradio2 = new Spry.Widget.ValidationRadio("spryradio2");
//-->
</script>
</body>
</html>

Which languages do I need to make this happen? And I am unsure of how to incorporate PHP within a javascript query and what jQuery functions I will need.