PHP - Moved: Dreamweaver Update Multiple Rows

Only the last row will update when I submit.

I have this form (and one nerve left):


<form action="" method="post" >

echo"
<input style=\"text-align:center\" type=\"text\" name=\"linkorder\" value=\"".$row['order']."\" />
<input type=\"hidden\" name=\"id\" value=\"".$row['id']."\"/>
";
<input type="submit" name="updateorder" value="Save Order" />
</form>


On Submit:


if (isset($_POST['updateorder'])){

connect();
$changeorder = mysql_unbuffered_query("update links set `order` = '".$_POST['linkorder']."' where id = '".$_POST['id']."'") or die(mysql_error());

}



I was going put my fist through the monitor but then I remembered I could get help here.

Thank you!

Hello all, im new to this forum, im a noobie, just started coding about 3 weeks ago, don't be too hard on me.   My question is I wan't to check for challenges a user's team posted that have not been excepted after 1 day, then auto refund the user's team back there credits, and then also delete all the challenges. So far here is my code.

//Delete all matches not accepted after 1 day
$arrayin = array();
$autorefund = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " "
. "AND `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < " . ((int) time()) . ")");
if (mysql_num_rows($autorefund) > 0) {
while ($autorefund = mysql_fetch_assoc($autorefund)) {
$arrayin[] = $autorefund['id'];
mysql_query("UPDATE `teams` SET `balance` = `balance` + " . $autorefund['credits'] . " "
. "WHERE `id` IN (" . mysql_real_escape_string(implode(',', $arrayin)) . ")");
mysql_query("DELETE FROM `challenges` WHERE `a` IN "
. "(" . mysql_real_escape_string(implode(',', $arrayin)) . ") "
. "AND `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 "
. "AND (`expires` < " . ((int) time()) . ")");
}
}

FYI here is the code i had, it works fine, however it will only delete 1 challenge per team, not all of there challenges. 

$autorefund   = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time()).")");
if (mysql_num_rows($autorefund) > 0) {
while ($autorefund  = mysql_fetch_assoc($autorefund)) {
if ($autorefund['accepted'] == 0 and $autorefund['expires'] < time()) {
mysql_query("UPDATE `teams` SET `balance` =  `balance` + " . $autorefund['credits'] . " WHERE `id` = " . $team['id'] . "");
mysql_query("DELETE FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time())."));
}
}
}

I inherited this script, its using deprecated statements, i know im not skilled to rewrite the entire site to use prepared statements.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=351561.0

Hello all,

i have a table that displays data from mysql, now i want to update multiple rows from that table with checkboxes, the value will basically just switch from 'new' to 'done' so far i have this:

Code: [Select]
<tbody>
                                        <tr class="first">
        </tr>
<?php
$ticketde=0;
while ($ticketde < $numpscde) {

$f1pscde=mysql_result($ticketresultde,$ticketde,"id");
$f2pscde=mysql_result($ticketresultde,$ticketde,"ticket");
$f4pscde=mysql_result($ticketresultde,$ticketde,"date");
$f5pscde=mysql_result($ticketresultde,$ticketde,"ip");
$f6pscde=mysql_result($ticketresultde,$ticketde,"done");

$setdone = ($f6pscde["done"] == 'n') ? "<a href=\"donepsc.php?id=".$f1pscde."\"><img src=\"ico_new.gif\" alt=\"new\" /></a>" : $f6pscde["done"];

if(isset($_POST['setdone'])){$checkbox = $_POST['checkbox'];

$id = "('" . implode( "','", $checkbox ) . "');" ;
$sql = "UPDATE ticket
        SET done='done'
        WHERE id='$f1pscde'";
$result = mysql_query($sql) or die(mysql_error());
}

?>

<tr class="first">
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f1pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f2pscde; ?></font></td>

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f5pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $setdone; ?></font></td>
<td class="tc"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $f1pscde['id']; ?>"></td>


</tr>


<?php
$ticketde++;
}
?>
</tbody>
</table>
                                    <center><input type="submit" name="setdone" id="setdone" value="Set selected  to done" class="button"/>   
                                 -     <input type="submit" name="exporttxt" id="exporttxt" value="Export selected to .txt" class="button"/>
                                    </center>
                                   
</fieldset>
</form>
                           
I found that checkbox code sample on some other site and tried to implement it, i don't really know where to go from here, as it's a total mess to me now, any help would be greatly appreciated.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=344772.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=327017.0

Hi, after banging my head against the wall for a while thinking this would be a simple task, I'm discovering that this is more complicated than I thought.

Basically what I have is a link table linking together source_id and subject_id.   For each subject there are multiple sources associated with each.

I had created a basic listing of sources by subject... no problem.   I now need a way of having a form to create an ordered list in a user-specified way.  In other words, I can currently order by id or alphabetically (subject name lives on a different table), but I need the option of choosing the order in which they display.  I added another row to this table called order_by.  No problem again, and I can manage all of this in the database, however I want to create a basic form where I can view sources by subject and then enter a number that I can use for sorting.

I started off looping through each of the entries and the database (with a where), and creating a foreach like so (with the subject_id being grabbed via GET from the URL on a previous script)
Code: [Select]
while($row = mysqli_fetch_array($rs)) {


//update row order
if (isset($_POST['submit']))  {

//get variables, and assign order

$subject_id = $_GET['subject_id'];
$order_by = $_POST['order_by'];
$source_id = $row['source_id'];


//echo 'Order by entered as ' . $order_by . '<br />';

foreach ($_POST['order_by'] as $order_by) {

$qorder = "UPDATE source_subject set order_by = '$order_by'
WHERE source_id = '$source_id'
AND subject_id = '$subject_id'";

mysqli_query($dbc, $qorder)
or die ('could not insert order');

// echo $subject_id . ', ' . $order_by . ', ' . $source_id;
// echo '<br />';
} 
}
else {
$subject_id = $_GET['subject_id'];
$order_by = $row['order_by'];
$source_id = $row['source_id'];

}

And have the line in the form like so:
Code: [Select]
echo '<input type="text" id="order_by" name="order_by[]" size="1" value="'. $order_by .'"/>

(yes I know I didn't escape the input field... it's all stored in an htaccess protected directory;  I will clean it up later once I get it to work)

This, of course, results in every source_id getting the same "order_by" no matter what I put into each field.

I'm thinking that I need to do some sort of foreach where I go through foreach source_id and have it update the "order_by" field for each one, but I must admit I'm not sure how to go about this (the flaws of being self-taught I suppose;  I don't have anyone to go to on this).

I'm hoping someone here can help?

Thanks a ton in advance

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

I want to echo out a few subcategories per main category.
It should be a maximum of 20 entries per column

At this stage I have the following... It echo's the results out in 4 columns and not what I want.
Any suggestions?

$query = "SELECT 
adsubcat.name AS subname, adsubcat.linkname AS sublink, adcat.clinkname AS clink
FROM adsubcat 
JOIN adcat ON adcat.id=adsubcat.catid
WHERE adsubcat.catid='$catid' ORDER BY adsubcat.name ASC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {

$count = 0;

print '<table style="text-align:left;margin-left:0px;width:943px;">'."\n";
while ($row = mysql_fetch_assoc($result)){
$gal = '<a href="'.$root.'/'.$row['clink'].'/'.$row['sublink'].'">'.$row['subname'].'</a>';
if ($count == 0){
print '<tr>';
}
++$count;
print '<td>'.$gal.'</td>';
if ($count == 4){
$count = 0;
print'</tr>'."\n";
}
}
print'</table>'."\n";
}

Hi,

Ok, so I'm making a registration form system, where I can create new registration forms for the users to pick a date etc.

In my form I can add and remove text fields via Javascript - to add additional dates etc. so I don't know if I'll be submitting 3 fields or 15.

The could look like this:
<input type="hidden" name="session_id[]" value="<?php echo $session_id; ?>">
<input type="text" name="picked_date[]">
<input type="text" name="picked_room[]">

They are put in a big array:
De bliver smidt i et stort array:
$n=0;
    foreach ($session_id as $_session_id) {
        $bigar[$n][1] = $_session_id;
        $n++;
        }
        $n=0;
    foreach ($picked_date as $_picked_date) {
        $bigar[$n][2] = $_picked_date;
        $n++;
        }
        $n=0;
    foreach ($picked_room as $_picked_room) {
        $bigar[$n][3] = $_picked_room;
        $n++;
        }
        $n=0;

which is then updated in the database using:
foreach ($bigar as $part)
{
mysql_query("UPDATE...
}

Right - so far so good. The updating works fine with existing fields, but if I remove some of the fields (via JS) it obviously only updates the remaining in the array. The left out will be ignored. On the same note I would like to add fields as well, so - the bottom line - I want to:

- UPDATE rows, where the ID is in the array
- DELETE existing rows, WHERE the ID is NOT in the array
- CREATE new rows for the new fields in the array (not having an ID)

How can this be achieved? Hope someone can help...

Hi there. I have a page that lists the records of a table. On this page I want to be able to edit/update two attributes of these records by a checkbox - e.g., being able to update multiple records at once. I thought the smartest way to achieve this would be by using arrays. I've implemented one checkbox array and have two fields. Currently when I change both fields and hit submit, the height value changes and the name value is changed to the last record displayed in the table.

E.g.

Height - 170 -> 160 -> UPDATED TO 160
Name - Test1 -> Test2 -> UPDATED TO VICTORY (last record listed in table; displayed alphabetically)

My code is as follows:

<?php
include("connection.php");
$conn = oci_connect($UName,$PWord,$DB) or die("Database Error - Contact Admin - sjrei5@student.monash.edu");
if (empty($_POST["check"]))
{
    $query = "SELECT * FROM HORSE ORDER BY HORSE_NAME";
    $stmt = oci_parse($conn,$query);
    oci_execute($stmt);
$Horses = oci_fetch_array ($stmt);
?>
    <form method="post" action="horse_multi.php">
      <table border="1" id="customers">
      <tr>
        <th>ID</th>
        <th>EDIT</th>
        <th>NAME</th>
        <th>HEIGHT</th>
      </tr>
<?php
while ($Horses = oci_fetch_array ($stmt))
{
?>
        <tr>
          <td><?php echo $Horses["HORSE_ID"]; ?></td>
          <td align="center"><input type="checkbox" name="check[]" value="<?php echo $Horses["HORSE_ID"]; ?>"></td>
          <td align="center"><input type="text" size="5" name="<?php echo $Horses["HORSE_ID"]; ?>" value="<?php echo $Horses["HORSE_HEIGHT"]; ?>"></td>
          <td align="center"><input type="text" size="20" name="HORSE_NAME" value="<?php echo $Horses['HORSE_NAME']; ?>"></td>
        </tr>
<?php
}
?>
      </table><p />
        <h4><input type="submit" value="Update Selected Horses"></h4>
    </form>
<?php
oci_free_statement($stmt);
}
else
{

foreach($_POST["check"] as $horse_id)
{
$query = "UPDATE HORSE SET HORSE_NAME= '$_POST[HORSE_NAME]', HORSE_HEIGHT = ".$_POST[$horse_id]." WHERE HORSE_ID ='".$horse_id."'";
$stmt = oci_parse($conn,$query);
oci_execute($stmt);
}
}
?>
</body>
</html>


Any ideas? 

Hey Guys. I have tried looking this up on Google but the only answers I am finding is using there where clause. I wanted to know if I can update or delete a range of rows like from id 100-200. Is there a way to do that? Thanks!

Hi all,
I have a data base with the following table:

---member_data---
id ^ mid ^fieldname^ fieldvalue
1 - 2 - applicant - Seth Smith
2 - 4 - firstname - Chris
3 - 4 - lastname - Cooper
4 - 7 - full_name - Joey Jones
5 - 7 - occupation - Programmer
6 - 7 - phone - 800-555-1212


And below is a snippet that I use to display the selected members data for editing

-------------------------------
<table>
<tr>
<td>Name:</td>
<td>Value:</td>
</tr>
<?php

$query = "SELECT * FROM member_data WHERE mid='$mid'";
$result= mysql_query($query);
  while($row = mysql_fetch_array($result)) {

      $fieldname = $row["fieldname"];
      $fieldvalue = $row["fieldvalue"];

?>
<tr>
<td><input type="text" name="<?php echo $fieldname;?>" value="<?php echo $fieldname;?>"></td>
<td><input type="text" name="<?php echo $fieldvalue;?>" value="<?php echo $fieldvalue;?>"></td>
<?php } ?>
</tr>
</table>
-------------------------------

My question is:

- using the Db example above:
- lets say Ive selected mid#7 (member id 7) to edit which is displayed using the snippet code from above.
- once displayed how do I edit  mid#7  given the fact that  mid#7  is located on 3 seperate rows from the same table?

Thank you,
Dave


*ALSO - I tried the snippet below which did Not work.

foreach($_POST as $key => $val) {
$sql = "UPDATE member_data SET fieldname='$key', fieldvalue='$val' WHERE mid='$mid'";
$result = mysql_query($sql);
}

My site seems to be going well, but on the back end, the users database is going crazy with duplicate entrys. but its not doing it from an INSERT. it seems to be doing it with this code:
Code: [Select]
               $bitquery = $bitcoin->move("bittleship$username", "bittleships", $cost, $minconfirmations);
               if ($bitquery == true){
               $query = mysql_query("INSERT INTO `transactions` ( `id` , `username` , `type` , `amount`, `address`) VALUES ('', '$username', 'buyclicks', '$cost', '')")  or die(mysql_error());
               $query = mysql_query("UPDATE users SET `clicks` = `clicks`+$quantity, `balance`=`balance`-$cost WHERE `username` = '$username' ") or die(mysql_error());
               include('update.php');

Hi,
 
I want to update a txt files 10. row with a form but I could not it how can I do it?