php - How to update or insert data into a table using a loop structure -


please assist me on one. have 2 db's, 1 keeps track of user , system activities , other keeps track of user activities. purpose of codes below first of retreive tables second db. these tables have following columns:

(id |date |debit |credit |number |description |accounttype |company_id)

the idea retrieve tables , |debit|credit| columns. these fields (|debit|credit|) have values in them. after retrieval, should able update or if possible new insertion or tables have been retrieved db.

below codes i've written. retrieves alright can't insertion or update. please assist me

the same page calls itself.

//connection , extraction db //db connection exists //sql query $sql = "show tables $companyname"; $results = mysql_query($sql) or die(mysql_error()); $count = 1; while($row = mysql_fetch_array($results)) { $results2 = mysql_query("select * `$row[0]` limit 1") or die('error'.mysql_error()); while($row2 = mysql_fetch_array($results2)) { $debit = $row2['debit']; $credit = $row2['credit']; echo "<tr><td>$count. </td><td width='30%'>".ucwords($row[0])."</td><td width='30%'> <input type='text' name='debit' value='$debit' align='right'></td> <td width='30%'><input type='text' name='credit' value='$credit' align='right'></td></tr>"; } $count++; } //insertion db if(isset($_post['submit'])) { //sql query $sql3 = "show tables $companyname"; $results3 = mysql_query($sql3) or die(mysql_error()); $count = 1; while($row3 = mysql_fetch_array($results3)) { $results4 = mysql_query("select * `$row3[0]` limit 1") or die('error '.mysql_error()); $debit = $_post['debit']; $credit = $_post['credit']; while($row4 = mysql_fetch_array($results4)) { $query = mysql_query("update `$row3[0]` set `debit`= '$row4[debit]' , `credit`= '$row4[credit]' `id`=`$row4[id]`"); echo "update `$row3[0]` set `debit`= '$row4[debit]' , `credit`= '$row4[credit]' `id`=`$row4[id]` <br>"; echo $num; } $count++; } }

  1. your database design bad should have keepd data in 1 schema, keeping seperate auto_increment company using dubbel field primary key

    create table company_transaktions ( company_name varchar(50) not null, id mediumint unsigned not null auto_increment, date date not null, debit float not null, credit float not null, number meniumint not null, description tinytext not null, accounttype tinytext not null, company_id mediumint unsigned not null, primary key (company_name,id) );

    or if company_id think is, should use primary key (company_id,id)

  2. the php problem

    you store 2 postdata in 2 variables

    $debit = $_post['debit']; $credit = $_post['credit'];

    but never use them, going value of last row, have same name.

    so first thing need rename inputs:

    echo "<tr>\n"; echo "<td>$count. </td>\n"; echo "<td width='30%'>".ucwords($row[0])."</td>\n"; echo "<td width='30%'><input type='text' name='{$row[0]}[debit]' value='$debit' align='right'></td>\n"; echo "<td width='30%'><input type='text' name='{$row[0]}[credit]' value='$credit' align='right'>\n"; echo "</td>\n"; echo "</tr>";

    then can fetch right 1 on each loop:

    $debit = mysql_real_escape_string($_post[$row3[0]]['debit']); $credit = mysql_real_escape_string($_post[$row3[0]]['credit']);

    and use them in query

    $result = mysql_query("update `$row3[0]` set `debit`= '$debit' , `credit`= '$credit' `id`=`$row4[id]`");

Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more