|
PHP - Generate Different Colors On Table Rows Using Array
I'm trying to set different colors on rows of a table using an array,
Problem is I cannot get it to work right, i'm not sure where to place my for loop so that it works right and generates a different color for different row. Code: [Select] $color = array(red,green,blue); while ($row = mysql_fetch_assoc($exec)) { echo '<tr>'; echo '<td>'.$row['brand_name'].'</td>'; echo '<td>'.$row['contact_name'].'</td>'; echo '<td>'.$row['contact_info'].'</td>'; echo '<td>'.$row['email'].'</td>'; echo '<td>'.$row['description'].'</td>'; echo '</tr>'; } I tried putting for loop only for tr, but it didnt work. Code: [Select] for ($i=0;$i<=count($color);$i++) { echo "<tr bgcolor=\"".$color[$i]."\">"; } I cannot put it within the while loop, it'll repeat the rows for all the colors. So where exactly do I place the for loop so that it works right? Similar TutorialsHi again all, Why does the foreach loop im doing, put the array values from collection, into seperate table rows rather than 1 row per whole array? <?php class registration{ public $fields = array("username", "email", "password"); public $data = array(); public $table = "users"; public $dateTime = ""; public $datePos = 0; public $dateEntryName = "date"; public $connection; function timeStamp(){ return($this->dateTime = date("Y-m-d H:i:s")); } function insertRow($collection){ //HERE foreach($this->fields as $row => $value){ mysql_query("INSERT INTO $this->table ($value) VALUES ('$collection[$row]')"); } mysql_close($this->connection->connectData); } function validateFields(){ $this->connection = new connection(); $this->connection->connect(); foreach($this->fields as $key => $value){ array_push($this->data, $_POST[$this->fields[$key]]); } $this->dateTime = $this->timeStamp(); array_unshift($this->data, $this->dateTime); array_unshift($this->fields, $this->dateEntryName); foreach($this->data as $value){ echo "$value"; } $this->insertRow($this->data); } } $registration = new registration(); $registration->validateFields(); ?> I end up with 3 rows row 1: username row 2: email row 3 : password rather than row 1:username email password. $bl = array(); $link1 = array_rand($cds); $link2 = array_rand($cds); $link3 = array_rand($cds); $link4 = array_rand($cds); $A = 0; while (!in_array($link1, $bl)){ $link1 = array_rand($cds); $bl[$A] = $link1; $A++; } while (!in_array($link2, $bl)){ $link2 = array_rand($cds); $bl[$A] = $link2; $A++; } while (!in_array($link3, $bl)){ $link3 = array_rand($cds); $bl[$A] = $link3; $A++; } while (!in_array($link4, $cds)){ $link4 = array_rand($cds); $bl[$A] = $link4; $A++; } echo $link1; echo $link2; echo $link3; echo $link4; Pretty much I'm trying to generate 4 number's between the min and max of an array but I don't want any duplicates. So it checks if the number exists in a bl array if it does it generates another number, well thats the theory. Doesn't work like that though. Hi guys, I would like to know on How to alternate table row colors in Php Mysql result? CSS or Html? Thanks Code: [Select] <? $result = mysql_query("SELECT * FROM tbl_sta WHERE fiesta_date > '$now' ORDER BY sta_date LIMIT 5"); echo "<table id='table1' cellspacing='1' cellpadding='3'> <tr> <th>Upcoming Fiesta</th> </tr>"; while($row = mysql_fetch_array($result)){ $date = date("l, F j ",strtotime($row["sta_date"])); echo "<tr>"; echo "<td><a href='fiestasd.php' style='font-size:12px;font-weight:bold;'>" . $row['fiesta_brgy'] . " " . $row['fiesta_town'] . "</a> <br /> $date </td>"; echo "</tr>"; } echo "</table>"; ?> Thank you.. more power phpfreaks! I have 2 queries that I want to join together to make one row
Here is how I get categories for article listing. Article can be written in several categories at once. So I have this code: Code: [Select] $category = '1,5,23,46'; //Category IDs $get_cats = explode("," , $category); $cats = ""; for ($i = 0; $i<count($get_cats); $i++ ) { $cat = trim($get_cats[$i]); $catSlug = get_value_of($cat, "inc/cat_ids.php"); $catName = str_replace("-"," ",$catSlug); $cats .= "<a href=\"index.php?category=$catSlug\">".strtoupper($catName)."</a>, "; } $cats = substr($cats,0,-2); As you can see there's get_value_of function that is used to read the category from the file. File is cat_ids.php and looks like this: Quote 1='category-name-1'; 2='category-name-2'; 3='category name-3'; 4='category-name-4'; 5='category-name-5'; etc. I want to improve this in order not to read the file at each step ("for" loop). Means, one can load the file and then generate a list of (links) category compared to the numbers (Ids). So if $category is "1,3,4" I want to get list like this (by reading cat_ids.php): category-name-1, category name-3, category-name-4 With current function I read value for every ID from file in every step. So if article have 10 or more categories script load file 10 or more times. Looking for a solution to do this from a reading file only once. Thanks. I have this array of items in my php file.
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
Using the above array I am trying to generate a JSON file that will have the following structu
{
"category":[
{
"categoryName":"level1",
"category":[
{
"categoryName":"powders",
"products":[
{
"id":"100",
"path":"level1/powders",
"prodname":"Mens powder"
},
{
"id":"1000",
"path":"level1/powders",
"prodname":"Womens powder"
}
]
},
{
"categoryName":"oils",
"category":[
{
"categoryName":"sunflower",
"products":[
{
"id":"200",
"path":"level1/oils/sunflower",
"prodname":"XYZ oil"
},
{
"id":"400",
"path":"level1/oils/sunflower",
"prodname":"ABC oil"
}
]
},
{
"categoryName":"groundnut",
"products":[
{
"id":"1100",
"path":"level1/oils/groundnut",
"prodname":"GN oil"
}
]
}
]
},
{
"categoryName":"eatable",
"category":[
{
"categoryName":"vegetables",
"products":[
{
"id":"300",
"path":"level1/eatable/vegetables",
"prodname":"carrot"
},
{
"id":"600",
"path":"level1/eatable/vegetables",
"prodname":"spinach"
}
]
},
{
"categoryName":"fruits",
"products":[
{
"id":"500",
"path":"level1/eatable/fruits",
"prodname":"mango"
}
]
}
]
}
},
{
"categoryName":"level2",
"category":[
{
"categoryName":"baby items",
"category":[
{
"categoryName":"toys",
"products":[
{
"id":"700",
"path":"level2/baby items/toys",
"prodname":"puzzle blocks"
},
{
"id":"800",
"path":"level2/baby items/toys",
"prodname":"trucks and cars"
}
]
},
{
"categoryName":"clothes",
"products":[
{
"id":"900",
"path":"level2/baby items/clothes",
"prodname":"shirts"
}
]
}
]
}
]
}
Not being an expert in php, I have somehow managed to reach thus far in my code, but can not quite arrive at the correct logic. Having trouble with handling associative arrays and objects in php. (Javascripting is much easier I feel) So far I have managed to fix all the errors/warning in my code. Here is my full php code:
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
$jsonStruct = array();
function jsonCreateStruct(){
GLOBAL $items;
for($c=0; $c<count($items); $c++){
$categ = $items[$c]["categorypath"];
insertJson($categ, $items[$c]);
}
}
function insertJson($catg, $itm){
GLOBAL $jsonStruct;
$exp = explode("/",$catg);
print_r("\n\n\n $catg \n");
if(count($exp) == 1){
print_r("Level 1 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["products"] = array($itm);
print_r("\nCreated:: $exp[0]");
}else{
$notFound = true;
for($j=0; $j<count($jsonStruct); $j++){
$catgName = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName");
if($catgName == $exp[0]){
$notFound = false;
if($jsonStruct[$j]["products"]){
array_push($jsonStruct[$j]["products"],array($itm));
}else{
$jsonStruct[$j]["products"] = array();
array_push($jsonStruct[$j]["products"],array($itm));
}
}
}
if($notFound){
print_r("\nNotFound\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "products" => array($itm)));
}
}
}
if(count($exp) == 2){
print_r("Level 2 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "products" => array($itm));
print_r("\nCreated:: $exp[0] / $exp[1]");
}else{
$notFound1 = true;
$notFound2 = true;
$indexLevel = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level1 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level1); $m++){
if(isset($level1[$m]["categoryName"])){
$catgName2 = $level1[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
if($level1[$m]["products"]){
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}else{
$jsonStruct[$j]["categorypath"][$m]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
// $jsonStruct[$indexLevel]["categorypath"] = array("categoryName"=> $exp[1], "products" => array($itm));
$jsonStruct[$indexLevel]["categorypath"] = array();
array_push($jsonStruct[$indexLevel]["categorypath"], array("categoryName"=> $exp[1], "products" => array($itm)));
}
}
}
if(count($exp) == 3){
print_r("Level 3 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm)));
print_r("\nCreated:: $exp[0] / $exp[1] / $exp[2]");
}else{
$notFound1 = true;
$notFound2 = true;
$notFound3 = true;
$indexLevel1 = null;
$indexLevel2 = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel1 = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level2 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level2); $m++){
if(isset($level2[$m]["categoryName"])){
$catgName2 = $level2[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
$indexLevel2 = $m;
if(isset($level2[$m]["categorypath"])){
$level3 = $level2[$m]["categorypath"];
for($n=0; $n<count($level3); $n++){
//print_r($level3["categoryName"]);
if(isset($level3["categoryName"])){
$catgName3 = $level3["categoryName"];
print_r("\ncatgName3: ". $catgName3);
if($catgName3 == $exp[2]){
$notFound3 = false;
if($level3["products"]){
print_r("\npushing into array\n");
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}else{
print_r("\ncreate new and pushing into array\n");
$jsonStruct[$j]["categorypath"][$m]["categorypath"][$n]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}
}
}
}
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct, array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
if(!$jsonStruct[$indexLevel1]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"], array("categoryName"=> $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm))));
}else if($notFound3){
print_r("\nNotFound3\n");
//$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array("categoryName"=> $exp[2], "products" => array($itm));
if(!$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"], array("categoryName"=> $exp[2], "products" => array($itm)));
}
}
}
}
jsonCreateStruct();
print_r("----------------------------------------");
print_r($jsonStruct);
// echo json_encode($jsonStruct);
I have now reached a point where I desperately need help from experts.
Been looking to see if anyone has published something like this. I have a number of projects coming up which entail creating input form pages using PHP. Some of these are quite large as to the number of entries, pages etc.. and the worst part is that I know in advance that they most likely will want to change/add to the form after I am done. So rather than coding them physically in the code, I want to define the form elements in an array that I can store in a database/flat file and when the page loads, read from the array to construct the form output. I don't have any issues with dealing with the database or even using arrays, but I have not been able to come up with an array setup that works. Has anyone done this and would care to share the structure they used. Everything that I find on the net is basically sites that want to host the form, but this will be in a non-Internet accessible site so that is not an option. I have a MySQL table with a list of albums and there is a field called "views" with the number of views each album has received. I'm looking to generate an array of all the albums in the table and sort the array by the number of views (descending). I have a list of functions defined in a ContentController.php file. I created a new function called build_albumlist, which I've pasted below. The function "get_ip_log" already exists and works, and I used it as a template to create the "build_albumlist" function: public function build_albumlist(){ return $this->select_raw("SELECT * FROM albums WHERE deleted = '0' ORDER BY views DESC",array(),'all'); } public function get_ip_log(){ return $this->select_raw("SELECT * FROM sessions ORDER BY ID DESC",array(),'all'); } When I use the function, I get this warning: Warning: mysql_real_escape_string() expects parameter 1 to be string, array given inC:\xampp\htdocs\Controllers\DBController.php on line 10 [font=cabin, 'trebuchet ms', helvetica, arial, sans-serif]The "select_raw" function that I used in "build_albumlist" is defined in the DBController.php file, and is defined as below:[/font] private function clean_array($params){ $final=array(); foreach($params as $param){ $final[]=mysql_real_escape_string($param); } return $final; } public function select_raw($query,$params,$type=''){ $query=str_replace("?","'%s'",$query); $final_query= call_user_func_array('sprintf', array_merge((array)$query, $this->clean_array($params))); if($type==''){ $result=mysql_query($final_query) or die(mysql_error()); return mysql_fetch_assoc($result); } elseif($type=='all'){ $result=mysql_query($final_query) or die(mysql_error()); $final=array(); while($row=mysql_fetch_assoc($result)){ $final[]=$row; } return $final; } Does anyone know why the "build_albumlist" function is generating this warning, while the "get_ip_log" is not? Any help would be great, as I am obviously pretty new to this. Hi I'm trying to count XML elements and generate table row and cell as per result. XML entries generated by users what I'm trying to do is auto generate table rows and cols and paging them bec if XML file get heavier its hard to get results it slow down processing that's why i appreciate paging My XML: Code: [Select] <note> <a1>Keep holding On - Avril Lavigne </a1> <a2>Miley Cyrus - Party In The U.S.A </a2> <a3>Swift Taylor - Breath </a3> <a4>Coldplay - The Hardest Part </a4> <a5>P!nk - Who Knew </a5> <a6>Eminem - Love The Way You Lie ft. Rihanna </a6> <a7>Nelly Furtado - Say It Right </a7> <a8>The Black Eyed Peas - Meet Me Halfway </a8> <a9>Justin Bieber - Baby ft. Ludacris </a9> <a10>N.E.R.D. - Hot-n-Fun (Official Version) ft. Nelly Furtado </a10> </note> public function getEventTypes() { return array( 1=>array('Exhibition', 1), 2=>array('Wedding', 1), 3=>array('Business', 1), 4=>array('School Trip', 0), 5=>array('Birthday', 0), 6=>array('Concert', 1), 7=>array('Sporting Event', 1), 8=>array('Training', 0), 9=>array('Conference', 1), 10=>array('Other', 1), ); } I now want to generate a new array from this array as follows: 1) must retain the existing key 2) must be single dimensional and the value of each element will be value[0] 3) must only contain the array elements where value[1] = 1 So for example the generated array should be as follows: public function getActiveEventTypes() { return array( 1=>'Exhibition', 2=>'Wedding', 3=>'Business', 6=>'Concert', 7=>'Sporting Event', 9=>'Conference', 10=>'Other', ); } Hey, my code doesnt work and I dont know why: $update_weed_world_data_sql = "SELECT weed_factor, weed_basis FROM worlds"; $update_weed_world_data_res = mysql_query($update_weed_world_data_sql) OR DIE (mysql_error()); while($update_weed_world_data_while = mysql_fetch_assoc($update_weed_world_data_res)){ $update_weed_world_basis[''.$update_weed_world_data_while['id'].''] = $update_weed_world_data_while['weed_basis']; $update_weed_world_factor[''.$update_weed_world_data_while['id'].''] = $update_weed_world_data_while['weed_factor']; } I want to save some rows in variables identifiable by the value in the array. As example. When I want to echo $update_weed_world_factor['1'] - I want to get the row with ID 1 and the column "world_factor". I've used this code long time ago - but know something was going wrong. Thanks for helping :-) 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... i was wonderin if there is a function where you can get a column in an array format... if there is none, how could I put a row of names inside an array. Code: [Select] @include ("../session.php"); include ("../addons/functions/general.php"); mysql_connect("localhost", "", "") or die(mysql_error()); mysql_select_db("") or die(mysql_error()); $result = mysql_query("SELECT friendname FROM friends where username='$session->username'"); while ($row = mysql_fetch_assoc($result)) { } $response = array(); $names = array('ROW of NAMES in HERE); i need $names = array('ROW of Names in Here); to be like this Code: [Select] $names = array('Abraham Lincoln', 'Adolf Hitler', 'Agent Smith', 'Agnus', 'AIAI', 'Akira Shoji', 'Akuma', 'Alex', 'Antoinetta Marie', 'Baal', 'Baby Luigi', 'Backpack', 'Baralai', 'Bardock', 'Baron Mordo', 'Barthello', 'Blanka', 'Bloody Brad', 'Cagnazo', 'Calonord', 'Calypso', 'Cao Cao', 'Captain America', 'Chang', 'Cheato', 'Cheshire Cat', 'Daegon', 'Dampe', 'Daniel Carrington', 'Daniel Lang', 'Dan Severn', 'Darkman', 'Darth Vader', 'Dingodile', 'Dmitri Petrovic', 'Ebonroc', 'Ecco the Dolphin', 'Echidna', 'Edea Kramer', 'Edward van Helgen', 'Elena', 'Eulogy Jones', 'Excella Gionne', 'Ezekial Freeman', 'Fakeman', 'Fasha', 'Fawful', 'Fergie', 'Firebrand', 'Fresh Prince', 'Frylock', 'Fyrus', 'Lamarr', 'Lazarus', 'Lebron James', 'Lee Hong', 'Lemmy Koopa', 'Leon Belmont', 'Lewton', 'Lex Luthor', 'Lighter', 'Lulu'); On my site, I currently have a page that lists my team's fixtures: http://www.cfrclunj.co.uk/fixtures.php As can be seen, in between each separate month there is a row of blank, grey cells. I am now updating the site so that it takes all information from a database (for easier update). On my test page (at bottom) I have recreated the fixtures table using my db: http://www.cfrclunj.co.uk/db_test.php What I am wondering is if there is any way to get the grey monthly separater row into my table. Could this be done by inserting a row of data into the db table that uses an if statement to change it's appearance? Or could I somehow use MYSQL/PHP to make it put a row in for each separate month? I have to admit my PHP and MYSQL skills are still at a very basic level, and so any help would be great! 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? I have a simple foreach loop. The array has four rows in it. Really simple. I have confirmed the data in the array with var_dump. For some reason I cannot fathom, the loop is only processing rows 0 and 2 and is not processing 1 and 3.
Here's the code snippet:
<?php
foreach ($postCals as $key=>$cal){
var_dump($postCals, $cal, $key);
echo '<td style="text-align:right;>' . $cal . "</td>";
}
?>
$postCals has precisely 4 values. Here's the output from this part of the code (in terms of the var_dumps).
array (size=4)0 => string '2.00000' (length=7) 1 => string '2.00000' (length=7) 2 => string '3.20000' (length=7) 3 => string '4.00000' (length=7) string '2.00000' (length=7) int 0 array (size=4) 0 => string '2.00000' (length=7) 1 => string '2.00000' (length=7) 2 => string '3.20000' (length=7) 3 => string '4.00000' (length=7) string '3.20000' (length=7) int 2 That's it. I two other foreach loops identical to this and they run fine! Any ideas? (misc info: php: 5.4.7 running on XAMPP/Windows ) I wonder if anyone can help me, I have a MySQL table of football teams (team_name; link; description; rival_1; rival_2; rival_3;) where each 'team_name' has its own page with the relevant information from the table and is named as the link field from the table. Within each team page I also want to display the rival_1,2 and 3 teams with links to their pages. I know how to just display the information but am struggling with picking up the link from the relevant row in the table. Is this possible or would I be better off just placing a <a href> link around each rival team when I enter it into the MySQL table?? I hope this makes sense, any help would be very much appreciated. Thanks 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.I've been using this code for a long time and realised it's very repetitive, but the id_column I want changes all the time function getRows() { $query = mysql_query($sql); $rows = array(); while($row = mysql_fetch_assoc($query)) { $rows[$row['id_column']] = $row; } return $rows; } So I wrote this function that will automatically create an array with a column I choose if I wish, but I'm not sure if it's very efficient. function getRows($query, $column_id = false) { $rows = array(); while($row = mysql_fetch_assoc($result)) { if($column_id === false) { $rows[] = $row; } else { if(isset($row[$column_id])) { $rows[$row[$column_id]] = $row; } else { $rows[] = $row; } } } return $rows; } I would appreciate some input as to make it better. Thanks. Hi Guys! Trying to display data in 3 rows horizontally and 25 vertiacally Code: [Select] // Print out result while($row = mysql_fetch_array($result)){ echo "There are ". $row['COUNT(biddersId)'] ." bidders logged."; echo "<br />"; } $query = "SELECT * FROM bidders ORDER BY biddersId"; $result = mysql_query($query) or die(mysql_error()); echo "<table border='1'>"; echo "<tr> <th>Bidders</th>"; // keeps getting the next row until there are no more to get while($row = mysql_fetch_array( $result )) { // Print out the contents of each row into a table echo "<tr><td>"; echo"<font face= \"calibri\" size=\"3\">"; echo $row['biddersId']; echo "</br>"; echo "</td><td>"; } echo "</table>"; ?> |
|||||||