pixeltrace

Hi, I am in linux. honestly, i haven't tried doing php upgrading before. hope you could help me with this. thanks!

Hi, i have a problem and i need help. we have a server and is using apache 2 which has php4.3 now, my boss needs to upgrade php version to 4.7.7 my problem now is i dont know how to do this. hope you could help me with this. thanks!

how to do it in .htaccess? thanks!

hi, i am currently testing something and i renamed my index.php to index.php how do i add in linux or apache index1.php so when i access the test site www.domain.com it will point to index1.php and not index.php how to do this? hope you could help me with this. thanks!

hi, its still not working and i am getting a no data found $uSql = "SELECT * FROM jos_findit, jos_findit2"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ this is the query that i used hope you could help me with this. thanks!

hi, i need help, i need to display results from 2 different tables but having the same fields. my problem is , i dont know how my select query will be. its something like this $uSql = "SELECT * FROM table1 AND table2"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ hope you could help me with this. thanks!

hi, this is the code that i have inside my cron 15 0 * * * wget http://mydomainname.com/V3Uploader.php is there anything that i can add here so it automatically closes the application or browser? hope you could help me with this. thanks!

hi, V3Uploader.php is setup in cron to execute the php page every 12am and i used wget to run the php page. below is the code for the v3uploader.php <?php include 'db_connect.php'; $uSql = "SELECT * FROM jos_findit"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $client = new SoapClient("http://203.125.7.42/mapguide/phpviewersample/V3UploaderWebService.wsdl",array("trace"=>1)); try { $input=array('BuildingName'=>$uRow['TradeName'],'TradeBranch'=>$uRow['TradeBranch'],'TradeCode'=>$uRow['TradeCode'],'PostalCode'=>$uRow['PostalCode'],'CRUD'=>$uRow['CRUD']); $result= $client->getUpdateResult($input); $res = $result->getUpdateStatusReturns; echo $res->updateStatus ."<BR><BR>"; echo "Request Header : "; print htmlspecialchars($client->__getLastRequest()) . "\n<br><br>"; echo "Response Header : "; print htmlspecialchars($client->__getLastResponse()) . "\n"; } catch (SoapFault $exception) { echo $exception; } } } ?> also, is there any code that i can add in this php page so that after running the page, it will automatically close it? so in the future, i wont encounter the same issue on kill anymore. hope you could help me with this. thanks!

hi, i dont want to remove the application i just want to close it. i tried killall and kill but i really cant close the application whenever i used killall its telling me no process killed whenever i used kill process id, its telling me no such process i used ps -ef|grep V3Uploader.php.37 and i got the process id from the second column root 23193 23146 0 22:32 pts/0 00:00:00 grep V3Uploader.php.37 i type kill 23193 but its telling me: no such process. this is the entire application for v3uploader which i need to close -rw-r--r-- 1 root root 12016 Jun 29 00:15 V3Uploader.php -rw-r--r-- 1 root root 11960 Jun 30 00:15 V3Uploader.php.1 -rw-r--r-- 1 root root 11960 Jul 9 00:15 V3Uploader.php.10 -rw-r--r-- 1 root root 11960 Jul 10 00:15 V3Uploader.php.11 -rw-r--r-- 1 root root 11960 Jul 11 00:15 V3Uploader.php.12 -rw-r--r-- 1 root root 11960 Jul 12 00:15 V3Uploader.php.13 -rw-r--r-- 1 root root 11960 Jul 13 00:15 V3Uploader.php.14 -rw-r--r-- 1 root root 11960 Jul 14 00:15 V3Uploader.php.15 -rw-r--r-- 1 root root 11960 Jul 15 00:15 V3Uploader.php.16 -rw-r--r-- 1 root root 11960 Jul 16 00:15 V3Uploader.php.17 -rw-r--r-- 1 root root 11960 Jul 17 00:15 V3Uploader.php.18 -rw-r--r-- 1 root root 11960 Jul 18 00:15 V3Uploader.php.19 -rw-r--r-- 1 root root 11960 Jul 1 00:15 V3Uploader.php.2 -rw-r--r-- 1 root root 11960 Jul 19 00:15 V3Uploader.php.20 -rw-r--r-- 1 root root 11960 Jul 20 00:15 V3Uploader.php.21 -rw-r--r-- 1 root root 11960 Jul 21 00:15 V3Uploader.php.22 -rw-r--r-- 1 root root 11960 Jul 22 00:15 V3Uploader.php.23 -rw-r--r-- 1 root root 11960 Jul 23 00:15 V3Uploader.php.24 -rw-r--r-- 1 root root 10156 Jul 24 00:15 V3Uploader.php.25 -rw-r--r-- 1 root root 10156 Jul 25 00:15 V3Uploader.php.26 -rw-r--r-- 1 root root 10156 Jul 26 00:15 V3Uploader.php.27 -rw-r--r-- 1 root root 10156 Jul 27 00:15 V3Uploader.php.28 -rw-r--r-- 1 root root 10156 Jul 28 00:15 V3Uploader.php.29 -rw-r--r-- 1 root root 11960 Jul 2 00:15 V3Uploader.php.3 -rw-r--r-- 1 root root 10156 Jul 29 00:15 V3Uploader.php.30 -rw-r--r-- 1 root root 10156 Jul 30 00:15 V3Uploader.php.31 -rw-r--r-- 1 root root 10156 Jul 31 00:15 V3Uploader.php.32 -rw-r--r-- 1 root root 22260 Aug 1 00:15 V3Uploader.php.33 -rw-r--r-- 1 root root 22260 Aug 2 00:15 V3Uploader.php.34 -rw-r--r-- 1 root root 28303 Aug 3 00:15 V3Uploader.php.35 -rw-r--r-- 1 root root 36264 Aug 4 00:15 V3Uploader.php.36 -rw-r--r-- 1 root root 36264 Aug 5 00:15 V3Uploader.php.37 -rw-r--r-- 1 root root 11960 Jul 3 00:15 V3Uploader.php.4 -rw-r--r-- 1 root root 11960 Jul 4 00:15 V3Uploader.php.5 -rw-r--r-- 1 root root 11960 Jul 5 00:15 V3Uploader.php.6 -rw-r--r-- 1 root root 11960 Jul 6 00:15 V3Uploader.php.7 -rw-r--r-- 1 root root 11960 Jul 7 00:15 V3Uploader.php.8 -rw-r--r-- 1 root root 11960 Jul 8 00:15 V3Uploader.php.9 hope you could help me close this because its causing our server to slow down. thanks so much!

hi, i have a project that needs a forum wherein its will be easy to setup, manage and easy to modify the styling. any free forum components/modules which you can suggest? thanks!

hi, i tried using this code <? $i=0; $uSql = ("SELECT * FROM jos_findit_product_service_providers ORDER by provider_name ASC"); // For speed, only pull the rows you need $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $id = $uRow['id']; $parent = $uRow['parent']; $code = $uRow['code']; $name = $uRow['provider_name']; if ($parent == '0' || $parent == '0'){ echo '<option value="'.$code.'"><b>» » '.$name.'</b></option>'; $i++; if ($parent == $i || $parent == $i){ echo '<option value="'.$code.'"> '.$name.'</option>'; } else { } } } } mysql_close($connection); // Close the connection as specified in config.php ?> but its only showing me the main category is there aways that the logic on the second condition will be like this $parent ='0'; echo '<option value="'.$code.'"><b>» » '.$name.'</b></option>'; $parent !=0 and $id = maincategory id; echo '<option value="'.$code.'"> '.$name.'</option>'; hope you could help me fix this code because i really cant visualize how the could flow will be. thanks!

hi, i tried the ps -f .... command and kill the process id but the files are still there. what other methods can i do? also in my cron i used wget to run the php page is there any additional codes that i need to add so after executing the page it automatically closes the php page? hope you could help me with this. thanks!

hi, i tried this <select name="poitype" class="style2" style="width:200px"> <option value="">--select one--</option> <? $i=0; $uSql = ("SELECT * FROM jos_findit_product_service_providers ORDER by provider_name ASC"); // For speed, only pull the rows you need $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $id = $uRow['id']; $parent = $uRow['parent']; $code = $uRow['code']; $name = $uRow['provider_name']; if ($parent = 0 || $parent == 0){ echo '<option value="'.$code.'"><b>» » '.$name.'</b></option>'; $i++; if ($parent = $i || $parent == $i){ echo '<option value="'.$code.'">'.$name.'</option>'; } else { } } } } mysql_close($connection); // Close the connection as specified in config.php ?> but its only returing the main category but not the subcategory in my database the parent of my subcategory is equal to the id of the main category and main category has a 0 value for the parent id | parent | code | provider_name | 1 0 wer werer 2 0 rty rtytyt 4 1 tytu rtyttut 5 2 erere rtrtrtrtr something like that. check my test site http://mango.resonance.com.sg/myoochi/findit/providerfindit2.php click on advance tab and on that page, click 'search for product & service providers' you will see the returned value. hope you could help me fix the code thanks!

hi, thanks for the response again. i tried the codes you gave me, but its returning 0 results this is my current code <select name="poitype" class="style2" style="width:200px"> <option value="">--select one--</option> <? $i='0'; $sql = ("SELECT * FROM jos_findit_product_service_providers ORDER by provider_name ASC"); // For speed, only pull the rows you need while($row = mysql_fetch_array( $sql )) { $id = $row['id']; $parent = $row['parent']; $code = $row['code']; $name = $row['provider_name']; if ($parent = '0' || $parent == '0'){ echo '<option value="'.$code.'"><b>» » '.$name.'</b></option>'; $i++; if ($parent = $i || $parent == $i){ echo '<option value="'.$code.'">'.$name.'</option>'; } else { } } } mysql_close($connection); // Close the connection as specified in config.php ?> </select> whatelse did we miss? hope you could help me with this. thanks!

hi, this code is working. but the only thing that is missing is that the subcategories are not in line with its main category kindly check my test site http://mango.resonance.com.sg/myoochi/findit/providerfindit2.php click on advanced search tab click 'search by product & service providers' and see what i mean. the order should be something like this http://mango.resonance.com.sg/myoochi/findit/testa.html hope you could help me with this. thanks!

hi, linux newbie here. i am running a specific php page using cron. for 1 month already. now, when i login to our linux server using putty entering as root then i type ls -l i notice that the page, that i am running under cron in a daily basis has been opened for 29 times already and hasnt been closed. how do i close them? the files looked like this -rw-r--r-- 1 root root 12016 Jun 29 00:15 V3Uploader.php -rw-r--r-- 1 root root 11960 Jun 30 00:15 V3Uploader.php.1 -rw-r--r-- 1 root root 11960 Jul 9 00:15 V3Uploader.php.10 -rw-r--r-- 1 root root 11960 Jul 10 00:15 V3Uploader.php.11 -rw-r--r-- 1 root root 11960 Jul 11 00:15 V3Uploader.php.12 -rw-r--r-- 1 root root 11960 Jul 12 00:15 V3Uploader.php.13 -rw-r--r-- 1 root root 11960 Jul 13 00:15 V3Uploader.php.14 -rw-r--r-- 1 root root 11960 Jul 14 00:15 V3Uploader.php.15 -rw-r--r-- 1 root root 11960 Jul 15 00:15 V3Uploader.php.16 -rw-r--r-- 1 root root 11960 Jul 16 00:15 V3Uploader.php.17 -rw-r--r-- 1 root root 11960 Jul 17 00:15 V3Uploader.php.18 -rw-r--r-- 1 root root 11960 Jul 18 00:15 V3Uploader.php.19 -rw-r--r-- 1 root root 11960 Jul 1 00:15 V3Uploader.php.2 -rw-r--r-- 1 root root 11960 Jul 19 00:15 V3Uploader.php.20 -rw-r--r-- 1 root root 11960 Jul 20 00:15 V3Uploader.php.21 -rw-r--r-- 1 root root 11960 Jul 21 00:15 V3Uploader.php.22 -rw-r--r-- 1 root root 11960 Jul 22 00:15 V3Uploader.php.23 -rw-r--r-- 1 root root 11960 Jul 23 00:15 V3Uploader.php.24 -rw-r--r-- 1 root root 10156 Jul 24 00:15 V3Uploader.php.25 -rw-r--r-- 1 root root 10156 Jul 25 00:15 V3Uploader.php.26 -rw-r--r-- 1 root root 10156 Jul 26 00:15 V3Uploader.php.27 -rw-r--r-- 1 root root 10156 Jul 27 00:15 V3Uploader.php.28 -rw-r--r-- 1 root root 10156 Jul 28 00:15 V3Uploader.php.29 -rw-r--r-- 1 root root 11960 Jul 2 00:15 V3Uploader.php.3 -rw-r--r-- 1 root root 10156 Jul 29 00:15 V3Uploader.php.30 -rw-r--r-- 1 root root 10156 Jul 30 00:15 V3Uploader.php.31 -rw-r--r-- 1 root root 10156 Jul 31 00:15 V3Uploader.php.32 -rw-r--r-- 1 root root 22260 Aug 1 00:15 V3Uploader.php.33 -rw-r--r-- 1 root root 22260 Aug 2 00:15 V3Uploader.php.34 -rw-r--r-- 1 root root 11960 Jul 3 00:15 V3Uploader.php.4 -rw-r--r-- 1 root root 11960 Jul 4 00:15 V3Uploader.php.5 -rw-r--r-- 1 root root 11960 Jul 5 00:15 V3Uploader.php.6 -rw-r--r-- 1 root root 11960 Jul 6 00:15 V3Uploader.php.7 -rw-r--r-- 1 root root 11960 Jul 7 00:15 V3Uploader.php.8 -rw-r--r-- 1 root root 11960 Jul 8 00:15 V3Uploader.php.9 and i want to close them. hope you could help me with this. thanks!

hi, what is inside config.php?

sorry for not being able to explain clearly. i want to create an output that looks like this http://mango.resonance.com.sg/myoochi/findit/testa.html hope you could help me with this thanks!

hi, thanks this is what i actually did on my php code, but what i want is that the list menu will be in order by category my current code is like this <select name="poitype" class="style2" style="width:200px"> <option value="">--select one--</option> <? $uSql = "SELECT code, provider_name, id, parent FROM jos_findit_product_service_providers ORDER by provider_name ASC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $code = $uRow['code']; $provider = $uRow['provider_name']; $parent = $uRow['parent']; $id = $uRow['id']; ?> <? if ($parent = '0'){ echo "<option value=\""."$code"."\"><b>"."$provider"."</b></option>"; }elseif ($parent !='0' && $id == '$parent'){ echo "<option value=\""."$code"."\">"."$provider"."</option>"; } } } ?> </select> but currently its returning me nothing. this is how my table in my DB looked like id | parent | keyword | name | 1 | 0 | keyword | category1 22 | 1 | keyword | category1a 23 | 1 | keyword | category1b 2 | 0 | keyword | category2 24 |2 | keyword |category2a 25 | 2 | keyword | category2b hope you could help me with this. thanks!

hi, any help on this? thanks!

hi, i need help, i need to develop a list menu which have category and subcategory the html code looks like this <select name="select"> <option value="keyword"><b>category 1</b></option> <option value="keyword">subcategory1a</option> <option value="keyword">subcategory1b</option> <option value="keyword"><b>category 2</b></option> <option value="keyword">subcategory2a</option> <option value="keyword">subcategory2b</option> </select> but items for this list menu will be taken from the database my table fields are id | parent | keyword | name | 1 | 0 | keyword | category1 22 | 1 | keyword | category1a 23 | 1 | keyword | category1b 2 | 0 | keyword | category2 24 |2 | keyword |category2a 25 | 2 | keyword | category2b how will i generate the query so my outout will look similar to the html code? hope you could help me with this. thanks!

hi, this is exactly the same code that i used but i am getting that error. how to fix it? thanks!

hi, any response on this? thanks!

this is what i did //computation for the scaling $main_array = array("21-0-1000","20-1001-2000","19-2001-3000","18-3001-4000","18-4001-5000","16-5001-6000","16-6001-7000","16-7001-8000","16-8001-9000","16-9000-10000"); //echo " Scal is ".getscale($main_array,$distance); function getscale($main_array,$distance){ foreach($main_array as $index => $n_arr_range){ $val_ar = array(); $val_ar = explode("-",$n_arr_range); if($distance >= $val_ar[1] and $distance <= $val_ar[2]){ return $distance*$val_ar[0]; $scale=$distance*$val_ar[0]; } } } and i am getting this error Fatal error: Cannot redeclare getscale() (previously declared in /var/www/html/myoochi/findit/propertyfindit.php:876) in /var/www/html/myoochi/findit/propertyfindit.php on line 876 hope you could help me with this. thanks!

thanks! by the way, how do i get the value for $scale? since in my current code $scale=$distance*(multiplier) thanks again!