|
PHP - Php Read From Mysql Db
Similar TutorialsHi On my xampp server's database I get the warning that my database is read-only when I try to insert something into a table. I think I may know what cause this, because I created an export/import app that exports/import important data to the database... How can I remove the read-only from the database, because I am scared that the same thing might happen to my server's database? And is there a mysql query that test if the database is read-only? Thanks in advance I am working on a simple web app in which I want to store about 20 variables in a MYSQL table so when I hand off the project the variables can be easily edited by the end user. Is it easy to store variables in a MYSQL table then query those and make them PHP variables? Really I just need to read a MYSQL table and pull two columns; AppOption and AppOptionValue then create PHP variables for each of the results making the AppOption the variable name and the AppOptionValue the value of said varible. Any Ideas? Thanks! Sean MOD: Thanks for moving to the correct forum - much appreciated! OK, I've taken a look around and cannot find a complete tutorial on how to do this. I have created a database with a table and the following fields; id, day, month, year, event, type What I am trying to do is read the data held in the table by referencing the type field (unique data), have it populate data firleds which are user editable and then once all changes are made have it update into the table. I can't imagine that this is that hard at all, but I cannot for the life of me figure it out! Anybody got a tutorial or some code which will do this? Once upon a time needed help on March 12, 2008 this community helped me, I am still a learner tried to help back but all the problems posted here beyond my skills to solve them so I kept quiet. and Now I need help once again hope I will get it done. Its PHPPOS developed in Codeigniter This code below is from application\controllers\inventory_summary.php file Code: [Select] <?php require_once("report.php"); class Inventory_summary extends Report { function __construct() { parent::__construct(); } public function getDataColumns() { return array($this->lang->line('reports_item_name'), $this->lang->line('reports_item_number'), $this->lang->line('reports_description'), $this->lang->line('reports_count'), $this->lang->line('reports_reorder_level')); } public function getData(array $inputs) { $this->db->select('name, item_number, quantity, reorder_level, description'); $this->db->from('items'); $this->db->where('deleted', 0); $this->db->order_by('name'); return $this->db->get()->result_array(); } public function getSummaryData(array $inputs) { return array(); } } ?> And this partial code below is from application\controllers\report.php file Code: [Select] function inventory_summary($export_excel=0) { $this->load->model('reports/Inventory_summary'); $model = $this->Inventory_summary; $tabular_data = array(); $report_data = $model->getData(array()); foreach($report_data as $row) { $tabular_data[] = array($row['name'], $row['item_number'], $row['description'], $row['quantity'], $row['reorder_level']); } $data = array( "title" => $this->lang->line('reports_inventory_summary_report'), "subtitle" => '', "headers" => $model->getDataColumns(), "data" => $tabular_data, "summary_data" => $model->getSummaryData(array()), "export_excel" => $export_excel ); $this->load->view("reports/tabular",$data); } } ?> Together they get the job done as follow: Item Name Item Number Description Count Reorder Level (Count is quantity in stock) Item 1 0002 xyz 5 3 Item 2 0s00 xyz 5 3 Item 3 0005 xyz 5 3 Item 4 0006 xyz 5 3 The output I want need to be like this: Item Name Item Number Description cost price Count Reorder Level Item 1 0002 xyz 250 5 3 Item 2 0s00 xyz 120 5 3 Item 3 0005 xyz 300 5 3 Item 4 0006 xyz 500 5 3 Total Stock Value 5850 Total Count 20 <-- this doesn't require any formation just needs to be at bottom of all the queries like shown here. This is what I want mainly >>>>>>>>>> Total Stock Value (cost price * count foreach and then sum of all results ) and sum of all count cost price table and column is different than one used above in the code which is: databse table is ' receivings_items ' Column is 'item_cost_price' example php code to fetch is : Code: [Select] $sql = "SELECT `item_cost_price` FROM `receivings_items`"; config.php contains all the connection variables to MySQL Please Help me I am having trouble trying to save my image file names to mysql after reading a dir. I am trying to use the file below.
Any help would be appreciated. I was originallly getting the files to list but they we not showing up in the database.
Now the page shows up blank.
<?php
require("config_0.php");
// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("test")or die("cannot select DB");
$files = glob("images/*.jpg");
for ($i=1; $i<count($files); $i++)
{
$num = $files[$i];
$sql="INSERT INTO images (url) VALUES ('$num')";
if (!mysql_query($sql))
{
die('Error: ' . mysql_error());
}
echo '<img src="'.$num.'" alt="random image">'." ";
}
?>
I have a MySQL database with each record of a person who has registered for an event, I am displaying the information on a web page for a user, but he wants to be able to print out all the records in alphabetical order by last name, first name later on so he will have a hard copy of each person who has registered at the table when they arrive. How can I write each record to a Txt file that he can print out later that will be formated with the record contents along with each fields definition (Ex. Last Name - Smith, First Name - John, etc)? Hi again, i'm wondering how can i make Sort (for example a-z) an column in php reading mysql informations. Here's the script: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="table.css" type="text/css"> </head> <body style="margin: 0 0 0 0;"> <? include("passwd.php"); @$start = $_GET["start"]; if($start =='') $start =0; include("lib.php"); $link = mysql_connect($host,$username,$password); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db($db, $link); if (!$db_selected) { die ("Can't use $db : " . mysql_error()); } //total number of records in the table $res = mysql_query("SELECT * from `$table`"); @$rows = mysql_num_rows ($res); $result = mysql_query("SELECT * from `$table` limit $start,10"); if (!$result) { die('Invalid query: ' . mysql_error()); } echo "<p align=center class = 'menu'> Ocitana tabela: $table </p>"; $cols = mysql_num_fields($result); $records = mysql_num_rows ($result); echo "<table align='center' width='1200' >"; echo "<tr bgcolor='BBCCDD' class='menu'>"; for ($i = 0; $i < $cols;$i++) { echo "<td align='center'>".mysql_field_name($result,$i)."</td>"; } echo "</tr>"; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "<tr bgcolor='F6F6F6' class='normal'>"; foreach ($row as $value) { echo "<td align='center'>".$value ."</td>"; } echo "</tr>"; } $end = $start + $records; echo "<tr align = 'center' bgcolor = 'BBCCDD' class='menu'><td colspan=$cols> Prijema $start do $end od $rows </td></tr>"; echo "<tr align = 'center' class='mylink'><td colspan=$cols> "; if($start != 0) { $prev = $start - 10; echo "<a href='tabela.php?start=$prev'> Prethodna </a> "; } if($start<$rows-10) { $next = $start + 10; echo "<a href = 'tabela.php?start=$next'>Sledeca</a> "; } echo "</td></tr>"; echo "</table>"; ?> </body> </html> Hello,
I try to get website speed of some website, but i can read only ''domain.com'' i can't read website files like css , js ... why ? i use proxies for this job.
here is the php code:
$options = array(
'useragent' => "Firefox (+http://www.firefox.org)", // who am i
'connecttimeout' => 120, // timeout on connect
'timeout' => 120, // timeout on response
'redirect' => 10, // stop after 10 redirects
'referer' => "http://www.google.com",
'proxyhost' =>'85.25.8.14:80'
);
$response = http_get("http://solve-ict.com/wp-content/themes/ict%20theme/js/jquery-1.7.1.min.js", $options , $info);
but it works fine with http://domain.com/ , but with files css or js it gives 404, using some free proxy servers available
?
Thanks.
Trying to get this done: Page_1 has many external links, when certain links are clicked i do not want user to go directly to page, but rather go to a special add page_2 where user must click a second time on the link to finally get there. The add page_2 must show on screen the name of the initial link from page_1, it must change accordingly with the link it came from page_1,once on page_2 the hyperlink redirects outside the site. So far i am thinking give an id to the div or "<a href..." on page_1 then somehow have page_2 detect that id and fill in the variable for the final external link. Other wise is there a way to detect a url from incoming? I guess a similar example is how some domain name sellers landing page will indicate the name of the site. Such as "Thisdomain.com" is for sale. same landing page but the name changes according to the domain that was typed. I got a question im using izabi for me im one who loves the software. But there some quirks that they forgot to add when making the mail system. I was wondering how it would be possible to code in a peice of php where it says read after someone read the email. If you need a copy of the mail mail script let me know. this is what i have so far: Code: [Select] $var=$_POST["fname"]; $xmlDoc = new DOMDocument(); $xmlDoc->loadXML($var); I would like to use something similar to this included in it before sql insert: Code: [Select] for($c = 0; $c<$node->length; $c++) { 1 root, 4 parents and varying childs I believe? Code: [Select] <node> <building>Number 65</building> <workers><label>executive</label><names>john</names><label>cook</label><names>terry</names><label>waitress</label><names>jill</names><label>buser</label><names>4564646</names><label>Main</label><number>45564646</number><label>home fax</label><number>45964646</number></workers> <food><label>breakfast</label><meal>eggs</meal><label>lunch</label><meal>turkey</meal><label>dinner</label><meal>steak</meal></food> <addresses><label>Home</label><Country>usa</Country><Street>123 mulberry ln </Street><ZIP>57888</ZIP><City>teledo</City><State>Ohio</State><label>location</label><Street>turnpike east 23</Street><City>danbury</City><State>Connecticut</State><Country>USA</Country></addresses> <building>Number 66</building> etc... </node> Thank you! Hi everyone, I need some help here. I don't know PHP coding and how to write custom php code for reading a XML in PHP. I have a application which updates the server status in real time and send out the data in XML format. I want to create a PHP page so that can show the data in XML to frontend user... I am pasting the XML code that need to be converted in PHP. Any kind of help will be appreciated. If anybody can give me the code and displaying the data in table format that will be awesome.... Code: [Select] <?xml version="1.0" encoding="UTF-8"?> -<simplehelp_metrics builddate="20120419-123521" version="3.12"> -<technician_metrics> <metric value="2" name="Technicians Logged In" id="tech_logged_in"/> <metric value="0" name="Technicians In Session" id="tech_in_session"/> <metric value="0" name="Technicians In Remote Session" id="tech_in_remote_session"/> </technician_metrics> -<customer_metrics> <metric value="0" name="Customers Logged In" id="cust_logged_in"/> <metric value="0" name="Customers In Session" id="cust_in_session"/> <metric value="0" name="Customers Waiting" id="cust_waiting"/> </customer_metrics> -<server_metrics> <metric value="1" name="Server Maximum Sessions" id="server_max_sessions"/> <metric value="23" name="Server Total Number of Sessions" id="server_total_sessions"/> <metric value="23" name="Server Total Number of Support Sessions" id="server_total_support_sessions"/> <metric value="0" name="Server Total Number of Access Sessions" id="server_total_access_sessions"/> <metric value="21217" name="Average Queue Time" id="server_average_queue_time"/> <metric value="17052" name="Last Queue Time" id="server_last_queue_time"/> <metric value="1830883" name="Average Session Duration" id="server_average_session_time"/> <metric value="5932145" name="Last Session Duration" id="server_last_session_time"/> </server_metrics> -<technicians> <technician name="tlc10271" login="tlc10271"/> <technician name="tlc10072" login="tlc10072"/> </technicians> </simplehelp_metrics> i have this code Code: [Select] <?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0"> <channel> <item> <title> tttt1</title> <link>lll1</link> <description> dddd1 </description> </item> <item> <title> tttt2</title> <link>lll2</link> <description> dddd2 </description> </item> <item> <title> tttt3</title> <link>lll3</link> <description> dddd3 </description> </item> and i want go get to array all the details tttt1 lll1 dddd1 tttt2 lll2 dddd2 tttt3 lll3 dddd3 how can i do that simple? I SEE THIS http://il2.php.net/xml_parse but 1)i dont understand this how can i do what i want 2) it is too long and class code i need short and simple please help hi, there is a script or something that can read this file? http://ical.imac.com/ical/portuguese32holidays.ics the ideia is to save all days and holidays for a mysql and then update time to time. thanks for your help hi, i am requesting bookrenter.com with curl and getting back a response in something like xml format The response is Code: [Select] <response> <book> <info> <isbn13>9780324786453</isbn13> <isbn10>032478645X</isbn10> </info> <prices> <rental_price days="45">$17.43</rental_price> <rental_price days="90">$24.35</rental_price> <rental_price days="60">$20.87</rental_price> <rental_price days="30">$15.87</rental_price> <rental_price days="125">$28.99</rental_price> </prices> <lowest_shipping_price>$0.00</lowest_shipping_price> <availability>In Stock</availability> <url>http://www.shareasale.com/r.cfm?u=&b=96706&m=14293&urllink=www.bookrenter.com%2Fdiscovering-computers-2010-living-in-a-digital-world-complete-shelly-cashman-series-032478645X-9780324786453</url> </book> </response> Now i want to process the response so that it will show the values in user readable form like 45 day's rent is $17.43 90 day's rent is $24.35 60 day's rent is $20.87 30 day's rent is $15.87 125 day's rent is $28.99 Shipping price is $0.00 please help Thanks Good morning guys. I am pulling data from vehicle tracking site via soap curl. but the data format that I am getting it in is unusable, maybee i am doing something wrong. please have a look. here is the code. <?php //Data, connection, auth $dataFromTheForm = $_POST['fieldName']; // request data from the form $soapUrl = "https://fleet11.******.co.za/api/"; // asmx URL of WSDL $soapUser = "********"; // username $soapPassword = "********"; // password // xml post structure $xml_post_string = '<?xml version="1.0" encoding="utf-8"?> <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:api="fleet11.cartrack.co.za/api/"> <soapenv:Header/> <soapenv:Body> <api:endpoint.get_vehicle_last_positions soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <username xsi:type="xsd:string">?</username> </api:endpoint.get_vehicle_last_positions> </soapenv:Body> </soapenv:Envelope>'; $headers = array( "Content-type: application/x-www-form-urlencoded", "Accept: text/xml", "Cache-Control: no-cache", "Pragma: no-cache", "SOAPAction: fleet11.******.co.za/api/#get_vehicle_last_positions", "Content-length: ".strlen($xml_post_string), ); $url = $soapUrl; // var_dump($url); $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_USERPWD, $soapUser.":".$soapPassword); curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY); curl_setopt($ch, CURLOPT_TIMEOUT, 10); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, $xml_post_string); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); `curl_setopt($ch, CURLOPT_HEADER, true);` // converting $response = curl_exec($ch); curl_close($ch); //paul add //echo "<pre>"; print_r($response); What is returning is single line entries QuoteGMT Server: [32] => Apache X-SOAP-Server: [33] => NuSOAP/0.9.5 [34] => (1.123) Content-Length: [35] => 15407 Vary: [36] => Accept-Encoding,User-Agent Access-Control-Allow-Origin: [37] => * Access-Control-Allow-Methods: [38] => POST, [39] => GET, [40] => OPTIONS Access-Control-Allow-Headers: [41] => Origin, [42] => X-Requested-With, [43] => Content-Type, [44] => Accept Access-Control-Allow-Credentials: [45] => true Content-Type: [46] => text/xml; [47] => charset=UTF-8 version="1.0" [49] => encoding="UTF-8"?> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" [51] => xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" [52] => xmlns:xsd="http://www.w3.org/2001/XMLSchema" [53] => xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" [54] => xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" [55] => xmlns:tns="fleet11.cartrack.co.za/api/"> xsi:type="SOAP-ENC:Array" [57] => SOAP-ENC:arrayType="tns:get_vehicle_last_positionsResultType0Row[20]"> xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">115687333 xsi:type="xsd:string">HG07DPGP xsi:type="xsd:string">2020-07-01 [62] => 08:03:32+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.118315 xsi:type="xsd:double">28.162389 xsi:type="xsd:string">0 xsi:type="xsd:string">Greenstone [68] => Hill, [69] => Kempton [70] => Park, [71] => Gauteng, [72] => South [73] => Africa xsi:type="xsd:string">25065631 xsi:type="xsd:string">ADNUSN1D5U0135477 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">115687485 xsi:type="xsd:string">HG07DKGP xsi:type="xsd:string">2020-07-01 [80] => 08:02:56+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.130168 xsi:type="xsd:double">28.159369 xsi:type="xsd:string">0 xsi:type="xsd:string">Diaz [86] => Avenue, [87] => Eastleigh, [88] => Edenvale, [89] => Gauteng, [90] => South [91] => Africa xsi:type="xsd:string">53844088 xsi:type="xsd:string">ADNUSN2D5U0135485 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">116851782 xsi:type="xsd:string">HH65MRGP xsi:type="xsd:string">2020-07-01 [98] => 06:46:10+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.19221 xsi:type="xsd:double">28.226617 xsi:type="xsd:string">0 xsi:type="xsd:string">Pretoria [104] => Road, [105] => Witfield, [106] => Boksburg, [107] => Gauteng, [108] => South [109] => Africa xsi:type="xsd:string">35613090 xsi:type="xsd:string">ADNUSN1D5U0139460 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">124523243 xsi:type="xsd:string">HM02SRGP xsi:type="xsd:string">2020-07-01 [116] => 07:35:45+02 xsi:type="xsd:string"> xsi:type="xsd:double">-25.75936 xsi:type="xsd:double">28.377471 xsi:type="xsd:string">0 xsi:type="xsd:string">Close [122] => to [123] => Mamelodi, [124] => Gauteng, [125] => South [126] => Africa xsi:type="xsd:string">72339064 xsi:type="xsd:string">ABNALGD22ZR114138 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">124523364 xsi:type="xsd:string">HL98BLGP xsi:type="xsd:string">2020-07-01 [133] => 08:04:54+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.111563 xsi:type="xsd:double">28.130599 xsi:type="xsd:string">98 xsi:type="xsd:string">Eastern [139] => Bypass, [140] => Lombardy [141] => East, [142] => Johannesburg, [143] => Gauteng, [144] => South [145] => Africa xsi:type="xsd:string">41388033 xsi:type="xsd:string">ADNUSN1D5U1046692 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131644752 xsi:type="xsd:string">DZ04YCGP xsi:type="xsd:string">2020-07-01 [152] => 07:12:08+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.058652 xsi:type="xsd:double">27.9626 xsi:type="xsd:string">0 xsi:type="xsd:string">Sharonlea [158] => & [159] => Exts, [160] => Randburg, [161] => Gauteng, [162] => South [163] => Africa xsi:type="xsd:string">99787541 xsi:type="xsd:string">ADNUSN1DSU018112 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131928943 xsi:type="xsd:string">CM63CKGP xsi:type="xsd:string">2020-07-01 [170] => 08:04:23+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.091137 xsi:type="xsd:double">28.136977 xsi:type="xsd:string">5 xsi:type="xsd:string">Reid [176] => Avenue, [177] => Linbro [178] => Park [179] => AH, [180] => Sandton, [181] => Gauteng, [182] => South [183] => Africa xsi:type="xsd:string">127659623 xsi:type="xsd:string">ADNUSN1D5U0062513 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131929103 xsi:type="xsd:string">CW94GBGP xsi:type="xsd:string">2020-07-01 [190] => 07:45:08+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.121185 xsi:type="xsd:double">28.037383 xsi:type="xsd:string">0 xsi:type="xsd:string">Zandfontein [196] => 42 [197] => IR [198] => Ext [199] => 42, [200] => Sandton, [201] => Gauteng, [202] => South [203] => Africa xsi:type="xsd:string">90508868 xsi:type="xsd:string">ADNUSN1D5U0072740 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131929189 xsi:type="xsd:string">DJ17CSGP xsi:type="xsd:string">2020-07-01 [210] => 08:02:23+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.037962 xsi:type="xsd:double">28.115413 xsi:type="xsd:string">0 xsi:type="xsd:string">Auston [216] => View, [217] => Midrand, [218] => Gauteng, [219] => South [220] => Africa xsi:type="xsd:string">133138296 xsi:type="xsd:string">ADNUSN1D5U0083443 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">133862270 xsi:type="xsd:string">HR66YXGP xsi:type="xsd:string">2020-07-01 [227] => 08:03:59+02 xsi:type="xsd:string"> xsi:type="xsd:double">-29.525639 xsi:type="xsd:double">31.204625 xsi:type="xsd:string">0 xsi:type="xsd:string">Deepdene, [233] => Ballito, [234] => KwaZulu-Natal, [235] => South [236] => Africa xsi:type="xsd:string">65364399 xsi:type="xsd:string">ADNALGD22ZR115154 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">146454559 xsi:type="xsd:string">HV78BLGP xsi:type="xsd:string">2020-07-01 [243] => 07:34:51+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.085404 xsi:type="xsd:double">28.133489 xsi:type="xsd:string">0 xsi:type="xsd:string">Clulee [249] => Road, [250] => Linbro [251] => Park [252] => AH, [253] => Sandton, [254] => Gauteng, [255] => South [256] => Africa xsi:type="xsd:string">30852771 xsi:type="xsd:string">ADNUSN1DSU0156147 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">152773681 xsi:type="xsd:string">HX90JJGP xsi:type="xsd:string">2020-06-30 [263] => 17:52:53+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.130205 xsi:type="xsd:double">28.15951 xsi:type="xsd:string">0 xsi:type="xsd:string">Diaz [269] => Avenue, [270] => Eastleigh, [271] => Edenvale, [272] => Gauteng, [273] => South [274] => Africa xsi:type="xsd:string">14419677 xsi:type="xsd:string">ADNUSN1D5U0161101 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">159833291 xsi:type="xsd:string">JB31BYGP xsi:type="xsd:string">2020-07-01 [281] => 07:17:59+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.181345 xsi:type="xsd:double">28.216789 xsi:type="xsd:string">1 xsi:type="xsd:string">Jet [287] => Park [288] => Road, [289] => Witfield, [290] => Boksburg, [291] => Gauteng, [292] => South [293] => Africa xsi:type="xsd:string">30900017 xsi:type="xsd:string">ADNUSN1D5U0164185 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">167023369 xsi:type="xsd:string">HZ14SDGP xsi:type="xsd:string">2020-07-01 [300] => 08:01:53+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.13017 xsi:type="xsd:double">28.159555 xsi:type="xsd:string">0 xsi:type="xsd:string">Lucas [306] => Road, [307] => Eastleigh, [308] => Edenvale, [309] => Gauteng, [310] => South [311] => Africa xsi:type="xsd:string">17826940 xsi:type="xsd:string">KMFZB7LKU621919 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">167435050 xsi:type="xsd:string">JH04HZGP xsi:type="xsd:string">2020-07-01 [318] => 07:32:35+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.058647 xsi:type="xsd:double">27.961838 xsi:type="xsd:string">0 xsi:type="xsd:string">Sharonlea [324] => & [325] => Exts, [326] => Randburg, [327] => Gauteng, [328] => South [329] => Africa xsi:type="xsd:string">26932527 xsi:type="xsd:string">ADNAPGD222R123234 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">174261628 xsi:type="xsd:string">FF98ZWGP xsi:type="xsd:string">2020-07-01 [336] => 08:04:03+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.129867 xsi:type="xsd:double">28.164617 xsi:type="xsd:string">15 xsi:type="xsd:string">Erasmus [342] => Avenue, [343] => Eden [344] => Glen, [345] => Edenvale, [346] => Gauteng, [347] => South [348] => Africa xsi:type="xsd:string">110330236 xsi:type="xsd:string">ADNU5N1D5U0112998 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">174261922 xsi:type="xsd:string">JG94XXGP xsi:type="xsd:string">2020-06-30 [355] => 13:49:51+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.130232 xsi:type="xsd:double">28.159559 xsi:type="xsd:string">0 xsi:type="xsd:string">Diaz [361] => Avenue, [362] => Eastleigh, [363] => Edenvale, [364] => Gauteng, [365] => South [366] => Africa xsi:type="xsd:string">24696958 xsi:type="xsd:string">ADNUSN1D5U0174093 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">174262077 xsi:type="xsd:string">FX50RTGP xsi:type="xsd:string">2020-07-01 [373] => 08:03:26+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.08572 xsi:type="xsd:double">28.133629 xsi:type="xsd:string">0 xsi:type="xsd:string">Clulee [379] => Road, [380] => Linbro [381] => Park [382] => AH, [383] => Sandton, [384] => Gauteng, [385] => South [386] => Africa xsi:type="xsd:string">108068376 xsi:type="xsd:string">ADNSUN1D5U0128530 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">176362877 xsi:type="xsd:string">FJ14LJGP xsi:type="xsd:string">2020-07-01 [393] => 08:02:22+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.111907 xsi:type="xsd:double">28.151657 xsi:type="xsd:string">0 xsi:type="xsd:string">Willow [399] => Way, [400] => Greenstone [401] => Hill, [402] => Kempton [403] => Park, [404] => Gauteng, [405] => South [406] => Africa xsi:type="xsd:string">85623895 xsi:type="xsd:string">ADNUSN1D5U0115408 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">176819319 xsi:type="xsd:string">JL90NYGP xsi:nil="true" [413] => xsi:type="xsd:string"/> xsi:type="xsd:string"> xsi:nil="true" [416] => xsi:type="xsd:double"/> xsi:nil="true" [418] => xsi:type="xsd:double"/> xsi:nil="true" [420] => xsi:type="xsd:string"/> xsi:nil="true" [422] => xsi:type="xsd:string"/> xsi:nil="true" [424] => xsi:type="xsd:string"/> xsi:type="xsd:string">ASNUSN1DSU0175716 ) How di i get this into a format to import into mysql Hi there, I have an xml file which actually hold the currency conversion information which I downloaded from xe.com In the xml, the currency section snapshot looks like this: <currency> <csymbol>EUR</csymbol> <cname>Euro</cname> <crate>0.713</crate> <cinverse>1.403 </cinverse> </currency> this is the conversion of USD to Euro. And it tells how much is 1USD gonna be in Euros. i.e 1 USD = 0.713 EUR I have a product page on my website having the rates shown in USD. For the visitor is accessing the page from Europe it has to show the converted price in Euros. My application can detect the visitors country if hes accessing the page from Europe so that is not a problem. I just need to read the xml file and display the converted price based on the rates in the xml file. How can I read the xml file and output the price in Euros based on the rate. Thank you. All comments and feedbacks are always welcome Trying to read through this query string to get a list of subjects (sub) and products (pro) sub2=pro73&sub2=pro76&sub2=pro79&sub2=pro90&sub2=pro92&sub3=pro73&sub3=pro74&sub3=pro87&sub3=pro90 so i need 2 -73, 2-76, 2-79, 3-73, 3-74 etc. What am i missing in this code.
foreach($_POST as $key => $val) {
$sub = substr($key, 3);
$pro = substr($val, 3);
// $links = "SELECT * FROM table WHERE sub='".$sub."' AND pro='".$pro."';";
}
I wrote a script that inserts an IP to a text file called 'banlist.txt', it works. But how can I read the text-file, and for everyline of IPs, die and don't let them see the content? I've got this so far <?php $file = @fopen("banlist.txt", "r"); if ($file) { while (!feof($file)) { $buff = fgets($file, 4096); echo "" . $buff . "<br />"; } fclose($handle); } ?> I need PHP script I have test.txt file and content is: Cat Dog Bird PHP must find line 1 and line 3 and show up in browser. Cat Bird Eng not good but I hope you understand me. Very thanks. |
|||||||