peehaichpee

hey all so I have this bit down: $query="SELECT `2010 Region Code` AS codes FROM locations"; $results = mysql_query($query); $options=""; $options = "<select location='codes'>"; while($nt=mysql_fetch_assoc($results)) { $thing=$nt["codes"]; $options.="\r\n<option value ='{$nt['codes']}'> {$nt['codes']}</option>"; } $options .="\r\n</select>"; echo $options; what I'm trying to do is grab the selection from the drop down and display it as a table (the sql query would be extended should we manage to figure this one out I've tried echo"<form name='LOCATIONS' action='".$_SERVER['PHP_SELF']."' target='iframe' method='post'>"; any ideas?

I'm trying to work out a count of how many of what assets are in a certain location: there should be 13 different categories (asset types) in a location and i want the individual count of each category. here's what i have - which seems to give me a total count of all assets and locations together plus one asset description and one location..... almost right. $con = mysql_connect('localhost','root',''); if(! $con) die(mysql_error()); mysql_select_db("test",$con); $result = mysql_query("SELECT DISTINCT COUNT(`Asset Description`) AS TOTALAD, LOCATION, `Asset Description` AS AD FROM master WHERE LOCATION like 'NC%'"); while($row = mysql_fetch_array($result)) { echo $row["LOCATION"]; echo "<br />"; echo $row["TOTALAD"]; echo "<br />"; echo $row["AD"]; echo "<br />"; } mysql_close($con);

I built a chart using PHPRunner and that's all cool but I dont' want the whole thing, I just really want the legend, is there a way to work out how that is being formed so I can just pinch that code? here's the settings.php $tdatamaster_Chart["Asset Description"]=$fdata; $tdatamaster_Chart[".chartXml"] = '<chart> <attr value="tables"> <attr value="0">master Chart</attr> </attr> <attr value="chart_type"> <attr value="type">2d_column</attr> </attr> <attr value="parameters">'; $tdatamaster_Chart[".chartXml"] .= '<attr value="0"> <attr value="name">Asset Count</attr> <attr value="currencyFormat">0</attr> <attr value="decimalFormat">0</attr> <attr value="customFormat">0</attr> <attr value="customFormatStr"></attr>'; $tdatamaster_Chart[".chartXml"] .= '</attr>'; $tdatamaster_Chart[".chartXml"] .= '<attr value="1"> <attr value="name">Asset Description</attr> </attr>'; $tdatamaster_Chart[".chartXml"] .= '</attr> <attr value="appearance">'; $tdatamaster_Chart[".chartXml"] .= '<attr value="scolor11">FF0000</attr> <attr value="scolor12">FF0000</attr>'; $tdatamaster_Chart[".chartXml"] .= '<attr value="head">'.xmlencode("Asset Description Count").'</attr> <attr value="foot">'.xmlencode("Assets").'</attr> <attr value="y_axis_label">'.xmlencode("CoCd").'</attr> <attr value="color51">49563A</attr> <attr value="color52">49563A</attr> <attr value="color61">49563A</attr> <attr value="color62">49563A</attr> <attr value="color71">FDFAF6</attr> <attr value="color72">FDFAF6</attr> <attr value="color81">F5E5CB</attr> <attr value="color82">F5E5CB</attr> <attr value="color91">000000</attr> <attr value="color92">000000</attr> <attr value="color101">000000</attr> <attr value="color102">000000</attr> <attr value="color111">000000</attr> <attr value="color112">000000</attr> <attr value="color121"></attr> <attr value="color122"></attr> <attr value="color131">000000</attr> <attr value="color132">000000</attr> <attr value="color141">000000</attr> <attr value="color142">000000</attr> <attr value="slegend">true</attr> <attr value="sgrid">false</attr> <attr value="sname">true</attr> <attr value="sval">true</attr> <attr value="sanim">true</attr> <attr value="sstacked">false</attr> <attr value="saxes">false</attr> <attr value="slog">false</attr> <attr value="aqua">0</attr> <attr value="cview">0</attr> <attr value="is3d">0</attr> <attr value="isstacked">0</attr> <attr value="linestyle">0</attr> <attr value="autoupdate">0</attr> <attr value="autoupmin">5</attr> <attr value="cscroll">true</attr> <attr value="maxbarscroll">10</attr>'; $tdatamaster_Chart[".chartXml"] .= '</attr> <attr value="fields">'; $tdatamaster_Chart[".chartXml"] .= '<attr value="0"> <attr value="name">Asset Count</attr> <attr value="label">'.xmlencode("Asset Count").'</attr> <attr value="search"></attr> </attr>'; $tdatamaster_Chart[".chartXml"] .= '<attr value="1"> <attr value="name">Asset Description</attr> <attr value="label">'.xmlencode("Asset Description").'</attr> <attr value="search"></attr> </attr>'; $tdatamaster_Chart[".chartXml"] .= '</attr> <attr value="settings"> <attr value="name">master Chart</attr> <attr value="short_table_name">master_Chart</attr> </attr> </chart>'; $tables_data["master Chart"]=&$tdatamaster_Chart; $field_labels["master_Chart"] = &$fieldLabelsmaster_Chart; $fieldToolTips["master Chart"] = &$fieldToolTipsmaster_Chart; // -----------------start prepare master-details data arrays ------------------------------// // tables which are detail tables for current table (master) $detailsTablesData["master Chart"] = array(); // tables which are master tables for current table (detail) $masterTablesData["master Chart"] = array(); // -----------------end prepare master-details data arrays ------------------------------// require_once(getabspath("classes/sql.php")); function createSqlQuery_master_Chart() { $proto0=array(); $proto0["m_strHead"] = "SELECT DIstinct"; $proto0["m_strFieldList"] = "COUNT(`Asset Description`) AS `Asset Count`, `Asset Description`"; $proto0["m_strFrom"] = "FROM master"; $proto0["m_strWhere"] = ""; $proto0["m_strOrderBy"] = ""; $proto0["m_strTail"] = "GROUP BY `Asset Description`"; $proto1=array(); $proto1["m_sql"] = ""; $proto1["m_uniontype"] = "SQLL_UNKNOWN"; $obj = new SQLNonParsed(array( "m_sql" => "" )); $proto1["m_column"]=$obj; $proto1["m_contained"] = array(); $proto1["m_strCase"] = ""; $proto1["m_havingmode"] = "0"; $proto1["m_inBrackets"] = "0"; $proto1["m_useAlias"] = "0"; $obj = new SQLLogicalExpr($proto1); $proto0["m_where"] = $obj; $proto3=array(); $proto3["m_sql"] = ""; $proto3["m_uniontype"] = "SQLL_UNKNOWN"; $obj = new SQLNonParsed(array( "m_sql" => "" )); $proto3["m_column"]=$obj; $proto3["m_contained"] = array(); $proto3["m_strCase"] = ""; $proto3["m_havingmode"] = "0"; $proto3["m_inBrackets"] = "0"; $proto3["m_useAlias"] = "0"; $obj = new SQLLogicalExpr($proto3); $proto0["m_having"] = $obj; $proto0["m_fieldlist"] = array(); $proto5=array(); $proto6=array(); $proto6["m_functiontype"] = "SQLF_COUNT"; $proto6["m_arguments"] = array(); $obj = new SQLField(array( "m_strName" => "Asset Description", "m_strTable" => "master" )); $proto6["m_arguments"][]=$obj; $proto6["m_strFunctionName"] = "COUNT"; $obj = new SQLFunctionCall($proto6); $proto5["m_expr"]=$obj; $proto5["m_alias"] = "Asset Count"; $obj = new SQLFieldListItem($proto5); $proto0["m_fieldlist"][]=$obj; $proto8=array(); $obj = new SQLField(array( "m_strName" => "Asset Description", "m_strTable" => "master" )); $proto8["m_expr"]=$obj; $proto8["m_alias"] = ""; $obj = new SQLFieldListItem($proto8); $proto0["m_fieldlist"][]=$obj; $proto0["m_fromlist"] = array(); $proto10=array(); $proto10["m_link"] = "SQLL_MAIN"; $proto11=array(); $proto11["m_strName"] = "master"; $proto11["m_columns"] = array(); $proto11["m_columns"][] = "Asset Number"; $proto11["m_columns"][] = "Asset Description"; $proto11["m_columns"][] = "CoCd"; $proto11["m_columns"][] = "Class"; $proto11["m_columns"][] = "Serial No#"; $proto11["m_columns"][] = "Invent No"; $proto11["m_columns"][] = "CostCentre"; $proto11["m_columns"][] = "Plnt"; $proto11["m_columns"][] = "LOCATION"; $proto11["m_columns"][] = "Location Name"; $proto11["m_columns"][] = "Remarks"; $proto11["m_columns"][] = "Formula"; $proto11["m_columns"][] = "sub class"; $proto11["m_columns"][] = "Cost"; $proto11["m_columns"][] = "W Start"; $proto11["m_columns"][] = "AssetDeleted"; $obj = new SQLTable($proto11); $proto10["m_table"] = $obj; $proto10["m_alias"] = ""; $proto12=array(); $proto12["m_sql"] = ""; $proto12["m_uniontype"] = "SQLL_UNKNOWN"; $obj = new SQLNonParsed(array( "m_sql" => "" )); $proto12["m_column"]=$obj; $proto12["m_contained"] = array(); $proto12["m_strCase"] = ""; $proto12["m_havingmode"] = "0"; $proto12["m_inBrackets"] = "0"; $proto12["m_useAlias"] = "0"; $obj = new SQLLogicalExpr($proto12); $proto10["m_joinon"] = $obj; $obj = new SQLFromListItem($proto10); $proto0["m_fromlist"][]=$obj; $proto0["m_groupby"] = array(); $proto14=array(); $obj = new SQLField(array( "m_strName" => "Asset Description", "m_strTable" => "master" )); $proto14["m_column"]=$obj; $obj = new SQLGroupByItem($proto14); $proto0["m_groupby"][]=$obj; $proto0["m_orderby"] = array(); $obj = new SQLQuery($proto0); return $obj; } $queryData_master_Chart = createSqlQuery_master_Chart(); $tdatamaster_Chart[".sqlquery"] = $queryData_master_Chart; $tableEvents["master Chart"] = new eventsBase; $tdatamaster_Chart[".hasEvents"] = false;

nailed it. $data wasn't being passed through to the sql statement, so I moved the curly bracket from the while statement down under it and it works. Still haven't worked out why I have to access the array with the number instead of using field names though but I'm stoked it's working.

OK I'm going about it a slightly different way, and it's inefficient in that each CSV has to be exactly the same since I can only seem to grab the array location by number instead of by column name, but on top of that the SQL just isn't working: $allowed_extensions = array('csv'); $upload_path = 'c:\wamp\tmp'; if (!empty($_FILES['file'])) { if ($_FILES['file']['error'] == 0) { // check extension $file = explode(".", $_FILES['file']['name']); $extension = array_pop($file); if (in_array($extension, $allowed_extensions)) { if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) { echo "move success<br />"; $filename = $upload_path.'\\'.$_FILES['file']['name']; if (($handle = fopen($filename, "r")) !== false) { # Set the parent multidimensional array key to 0. $nn = 0; #as long as there is data in the file while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { # Count the total keys in the row. $c = count($data); # Populate the multidimensional array. for ($x=0;$x<$c;$x++) { $csvarray[$nn][$x] = $data[$x]; //$csvarray[$nn]['AssetNumber'] = $data[]; } print_r($data[8]); $nn++; } # Close the File. // fclose($handle); } # Print the contents of the multidimensional array. columnize the array //import the csv file into mysql $conndb = mysql_connect("localhost", "root", ""); mysql_select_db("test", $conndb); $LOCATION = $data[8]; $LocationName = $data[9]; $AssetNumber = $data['0']; $sql = "UPDATE `master` SET LOCATION = $LOCATION, `Location Name` = '$LocationName' WHERE `Asset Number` = '$AssetNumber'"; echo "<br />".$sql; mysql_query($sql); any ideas? edit: block comment code removed

ok I worked that bit out, now it's not updating the SQL field so I added echo $value and I get this: 40102401024010240102401024010240102401024010240102 $conndb = mysql_connect("localhost", "root", ""); mysql_select_db("test", $conndb); //foreach($out as $key => $value) { foreach ($out as $lineNo => $values) { $LOCATION = $value['LOCATION']; $LocationName = $value['Location Name']; $AssetNumber = $value['Asset Number']; $sql = "UPDATE `master` SET `LOCATION` = '{$LOCATION}', `Location Name` = '{$LocationName}' WHERE `Asset Number` = {$AssetNumber}"; echo $value; mysql_query($sql); } mysql_close($conndb); $message = '<span class="green">File has been uploaded successfully</span>'; } } } } else { $message = '<span class="red">Only .csv file format is allowed</span>'; } } else { $message = '<span class="red">There was a problem with your file</span>'; } } what am I missing here?

Hey DavidAM, I'm learning as I go, I tried your suggestion and it's saying Notice: Undefined index: LOCATION in but for all of the variables, so how would I go about declaring them properly or setting a value to them?

where am I going wrong here? <?php $message = null; $allowed_extensions = array('csv'); $upload_path = 'c:\wamp\tmp'; if (!empty($_FILES['file'])) { if ($_FILES['file']['error'] == 0) { // check extension $file = explode(".", $_FILES['file']['name']); $extension = array_pop($file); if (in_array($extension, $allowed_extensions)) { if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) { if (($handle = fopen($upload_path.'/'.$_FILES['file']['name'], "r")) !== false) { $keys = array(); $out = array(); $insert = array(); $line = 1; while (($row = fgetcsv($handle, 0, ',', '"')) !== FALSE) { foreach($row as $key => $value) { if ($line === 1) { $keys[$key] = $value; } else { $out[$line][$key] = $value; } } $line++; } fclose($handle); if (!empty($keys) && !empty($out)) { $conndb = mysql_connect("localhost", "root", ""); mysql_select_db("master", conndb); foreach($out as $key => $value) { $sql = "UPDATE `master` SET `LOCATION` = '{$LOCATION}', `Location Name` = '{$Location Name}' WHERE `Asset Number` = {$Asset Number}"; mysql_query($sql); } mysql_close($conndb); $message = '<span class="green">File has been uploaded successfully</span>'; } } } } else { $message = '<span class="red">Only .csv file format is allowed</span>'; } } else { $message = '<span class="red">There was a problem with your file</span>'; } } ?> <!DOCTYPE HTML> <html lang="en"> <head> <meta charset="utf-8" /> <title>Upload CSV to MySQL</title> <meta name="description" content="" /> <meta name="keywords" content="" /> <link href="/styles/core.css" rel="stylesheet" type="text/css" /> <!--[if lt IE 9]> <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script> <![endif]--> </head> <body> <section id="wrapper"> <form action="" method="post" enctype="multipart/form-data"> <table cellpadding="0" cellspacing="0" border="0" class="table"> <tr> <th><label for="file">Select file</label> <?php echo $message; ?></th> </tr> <tr> <td><input type="file" name="file" id="file" size="30" /></td> </tr> <tr> <td><input type="submit" id="btn" class="fl_l" value="Submit" /></td> </tr> </table> </form> </section> </body> </html> Line 55 errors saying: ( ! ) Parse error: syntax error, unexpected T_STRING, expecting '}' in C:\Documents\PHPRunnerProjects\Jobs3\output\importtest.php on line 55 the line in question is: $sql = "UPDATE `master` SET `LOCATION` = '{$LOCATION}', `Location Name` = '{$Location Name}' WHERE `Asset Number` = {$Asset Number}";

the trouble is I'm modifying existing code and the array has been arranged like so: $fieldsArr = array(); $arr = array(); $arr['fName'] = "Asset Number"; $arr['viewFormat'] = ViewFormat("Asset Number", $strTableName); $fieldsArr[] = $arr; $arr = array(); $arr['fName'] = "Asset Description"; $arr['viewFormat'] = ViewFormat("Asset Description", $strTableName); so what I want to do is add a table at the bottom with my SQL statement to only show matching records based on that asset number on this page.... is that possible with the way the array has been done?

if I'm outputting from mysql with this: // Connects to your Database mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("test") or die(mysql_error()) ; //Retrieves data from MySQL $data = mysql_query("SELECT * FROM tickets") or die(mysql_error()); //Puts it into an array while($info = mysql_fetch_array( $data )) { //Outputs the image and other data Echo "<b>asset number:</b> ".$info['AssetNumber'] . "<br> "; Echo "<b>subject:</b> ".$info['subject'] . " <br>"; Echo "<b>notes:</b> ".$info['Notes'] . " <hr>"; } can I base the record it outputs somehow on this: $value=""; $value = ProcessLargeText(GetData($data,"Asset Number", ""),"","",MODE_VIEW); if($mainTableOwnerID=="Asset Number") $ownerIdValue=$value; $xt->assign("Asset_Number_value",$value); if(!$pageObject->isAppearOnTabs("Asset Number")) $xt->assign("Asset_Number_fieldblock",true); else $xt->assign("Asset_Number_tabfieldblock",true); It's kind of like a job history so its getting records of job history from one table while the second piece of code is getting the asset details from a main table

total PHP noob, so I started using PHP runner, and it turns out I love PHP coding. Anyway I'm building this database and I'm working around what phprunner did. What exactly is going on here: {BEGIN details_row} <tr class="runner-row style1"> <td class="runner-cl"><img src="images/spacer.gif"></td> <td class="runner-cc ">{$Asset_Number_value}</td> <td class="runner-cc ">{$Asset_Description_value}</td> <td class="runner-cc ">{$CoCd_value}</td> <td class="runner-cc ">{$Class_value}</td> <td class="runner-cc ">{$Serial_No__value}</td> <td class="runner-cc ">{$Invent_No_value}</td> <td class="runner-cc ">{$CostCentre_value}</td> <td class="runner-cc ">{$Plnt_value}</td> <td class="runner-cc ">{$LOCATION_value}</td> <td class="runner-cc ">{$Location_Name_value}</td> <td class="runner-cc ">{$Remarks_value}</td> <td class="runner-cc ">{$Formula_value}</td> <td class="runner-cc ">{$sub_class_value}</td> <td class="runner-cc ">{$Cost_value}</td> <td class="runner-cc runner-clast">{$W_Start_value}</td> <td class="runner-cr"><img src="images/spacer.gif"></td> </tr> {END details_row} ultimately what I want to do is pull up details of an asset from another table based on what $Asset_Number_value is in the main table.... is that possible? I was hoping to use what phprunner did but I don't mind cracking out my own solution thanks