PHP - Writting Sql Data To Xml File

Hi,

I am updating a few parts of my current website.
Currently, the website updates user accounts by uploading CSV data reports.

I currently use fgetcsv to deal with each row and this is taking forever to deal with the data as this is currently the code for each row.


while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
$grabinfo = "SELECT * FROM transactions WHERE id = '$data[$i]'";
$grabinforesult = mysql_query($grabinfo) or die(mysql_error());
while($row = mysql_fetch_array($grabinforesult)){
$merchant = $row['merchant'];
$username = $row['username'];
$datetime = $row['datetime'];
$letthem = $row['letthem'];
$validate = "SELECT * FROM transactions WHERE merchant = '$merchant' and username = '$username' and (status='pending' or status='success' or status='confirmed') and datetime='$datetime'";
$validator = mysql_query($validate) or die(mysql_error());
if(mysql_num_rows($validator) >= $letthem)
{
$import="UPDATE transactions SET amount='0.00' WHERE id='$data[$i]' and status ='awaiting'";
mysql_query($import) or die(mysql_error());
}}


 

mysql_query($import) or die(mysql_error());
} fclose($handle);


This is performing lots of checks on the csv data and checking it with the system. It checks each row.
Is there a quicker way of reading the csv data? There are lots of checks and while loops within the fgetcsv while loop. It can take upto half an hour to process a file with 1000 csv rows.

Hope someone could offer some advise.

Thanks

hello,

I need xml file as playlist.xml and i want to retrive data from my mysql table. I have the following code as i am trying to use php code inside playlist.xml file.
Code: [Select]
<?xml version="1.0" encoding="utf-8"?>

<xml>
<?php

$dbhost='localhost';
$dbuser='pavel';
$dbpass='pavel123';
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("amarmusic");

$sql=("select *from  bband where artist='Meghdol' and album='Drohe Montre Valobasha';");
$res = mysql_query($sql);

while ($result = mysql_fetch_array($res)){
    ?>
        <track>
            <path> <? $result['link']?></path>
            <title><? $result['title']?></title>
        </track>
    <?
}
?>
</xml>

but unfortunately its not working. any1 have any idea how to fix it? please help me.

Hi,

I am not that versed in PHP.  I have been working with this snippet of code that I found on a tutorial site.  It works like 97% and I get the format  mostly like I need it. 

Except, I can not figure how to add an extra single node to the list.

The code generates 20 random numbers and puts them into an array.  The array is then used to create a numbers node in the xml file.  It goes through and creates all the nodes.  I can not seem to figure out how to put a single game numbernode at the top of all the numbers nodes.

I am also not  understanding how to write the output to create the actual xml file.  I have written code in the past  to write a string to a text file but I am not sure about this because it is in an array?  The xml file will be appended every 5 minutes for data comparison down the road.    I think I will need to add a routine that calls the data back in at the beginning of the script and looks for the last game number if it is there and add 1.  The game number must increment each time it is appended. 

Any ideas on how to finish this up?

The final out put will look like this.  I only did a few lines instead of all 20 numbers to keep this short.

Code: [Select]
<?xml version="1.0">
<Container>
     <gamenumber>10</gamenumber>
     <numbers>47</numbers>
     <numbers>10</numbers>
     <numbers>5</numbers>
     <numbers>27</numbers>
</Container>

My Script
Code: [Select]
  <?php
  $balls = range(1,80);
  shuffle($balls);
  $pick = array_slice($balls,1,20);
  //$drawn = implode(", ",$pick);
  $arraySize = sizeof($pick);
 // print ("Arraw is $drawn\n\n");
  
  $doc = new DOMDocument();
  $doc->formatOutput = true;
  
  $drawn = array();
  $r = $doc->createElement( "Container" );
  $doc->appendChild( $r );
  
   for ($i=0; $i!= $arraySize; $i++){
  $drawn [] = array(
  'numbers' => $pick[$i],
  );
  }  
  
  foreach( $drawn as $draw )
  {    
  $numbers = $doc->createElement( "numbers" );
  $numbers->appendChild(
  $doc->createTextNode( $draw['numbers'] )
  );
  $r->appendChild( $numbers);
  
  }
    
  echo $doc->saveXML();
  ?>


Thanks for  your advise and help!!!

is there a php solution that will take
the raw data from one file and paste it
into another text file?

I have a master file and a download
file that always starts at quarter past
midnight . this data needs to be
pasted into the master file, in the
correct place , possibly overlapping
and replacing data that already exists.

the length of the download file will
vary but will always start at 00. 15
the two files are

www.maidenerleghweather.com/download.txt and also
www.maidenerleghweather.com/master.txt

any help appreciated .

Hi,
I'm quite new to PHP and I'd like to know if there's a way for me to use some PHP solution to get data from another PHP file instead of used AJAX.
My intention is to have some kind of a loop in one PHP file that'll have a variable that gets the returned data from a different PHP file on every iteration and does something with it.
Would be simple enough to do it with Ajax but I can't use it in this instance.
Any thoughts?

Hello,

How can I get the id in the search bar into the viewuser.php file

...

 <?php foreach($myObjectMap as $key => $item): ?>
                    <tr>
                      
                      <td>
                      <a href="viewuser.php?id=<?PHP echo $item->ID; ?>">
                      <?PHP echo $item->UserName; ?>
                      </td>
                        ...

 

I want half of the results to to show up with a hyperlink (if I've added the link as a field in my CSV file) and half of the results to show up with no hyperlink. The link URL's are located in field 8 of a database : [8] as seen below.

Could anyone help me to figure out how to add an "if" statement perhaps? Something like "if 8 true" then display "<a href"?

I did not write this php code I am only modifying it. The csv file is very very straightforward, but this PHP is beyond me. Would appreciate the help!

 <p><a href="<?=htmlspecialchars($r[8])?>"><?=htmlspecialchars($r[1])?></a><br />
        <?=htmlspecialchars($r[2])?><br />
        <?=htmlspecialchars($r[3])?><br />
        <?=htmlspecialchars($r[4])?><br />
        <?=htmlspecialchars($r[5])?><br />
        <a href="mailto:<?=htmlspecialchars($r[7])?>"><?=htmlspecialchars($r[7])?></a>
    </p>

I need to search through a text file and output certain text.
My current script doesn't work well at all.

Code: [Select]
<?
$file = 'flist.txt';
$handle = @fopen($file, "r");
$names = array();
$func = array();
$desc = array();
$nme;
$fnc;
$dsc;
$s = -1;
$e = -1;
$n = 0;
if ($handle) {
    while (($buffer = fgets($handle, 4096)) !== false) {

if($nme == 0)
{
if(strpos($buffer,"<a name") !== false)
{
$nme = 1;
$s = strpos($buffer,"<a name");
}
}
else if($nme == 1)
{
if(strpos($buffer,"</span>") !== false)
{
$nme = 2;
$e = strpos($buffer,"</span>");
$num = $e - $s;
$names[$n] = strip_tags(substr($buffer,$s,$num));
}
}
else if($nme == 2)
{
if($fnc == 0)
{
if(strpos($buffer,"<table style") !== false)
{
$fnc = 1;
$s = strpos($buffer,"<table style");
}
}
else if($fnc == 1)
{
if(strpos($buffer,"</td>") !== false)
{
$fnc = 2;
$e = strpos($buffer,"</td>");
$num = $e - $s;
$func[$n] = strip_tags(substr($buffer,$s,$num));
}
}
else if($fnc == 2)
{
if($dsc == 0)
{
if(strpos($buffer,"<p>") !== false)
{
$dsc = 1;
$s = strpos($buffer,"<p>");
}
}
else if($dsc == 1)
{
if(strpos($buffer,"</p>") !== false)
{
$fnc = 0;
$nme = 0;
$dsc = 0;
$e = strpos($buffer,"</p>");
$num = $e - $s;
$desc[$n] = strip_tags(substr($buffer,$s,$num));
}
}
}
}
    }
    if (!feof($handle)) {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);
$n = 0;
while($n < 100)
{
echo $names[$n] . "<br>";
echo $func[$n] . "<br>";
echo $desc[$n] . "<p>";
$n ++;
}
}
?>
4096 gets the data for each line, right? Well some of my data uses two lines.

After all the searching is done I need it to output $names, $func, and $desc in plain text.

Hello again. I'm trying to load data from a Facebook Share Data XML file and then displaying them in a WordPress plugin. Here's my code so far:


// Fetch Share Count Data

function fb_button () {
$fbshareUrl = urlencode(get_permalink($post->ID));
$fbshareTitle = urlencode($post->post_title);
$fbLinkStats = simplexml_load_file('http://api.facebook.com/restserver.php?method=links.getStats&urls='.$shareUrl);

 $fb_params =
        '?u=' . $fbshareUrl .
        '&amp;t=' . $fbshareTitle .
        ''
        ;

// Vertical Facebook Button

       $fb_share = '
<div class="fsbsharer" id="fb">
<a href="http://www.facebook.com/sharer.php' . $fb_params . '"  class="facebookShare">

<span class="fb_share_size_Small fb_share_count_wrapper">
<span></span>

<span class="fb_share_count_nub_top "></span> 
<span class="fb_share_count  fb_share_count_top">


<div class="fb_share_count_inner">
'. $fbLinkStats->link_stat->total_count .'
</div>

</div>
<span style="cursor:pointer;" class="FBConnectButton FBConnectButton_Small"><span class="FBConnectButton_Text">Share</span></span>
</a>
</div>
';


       echo $fb_share;
    }


This code works for everything except the title and the share count. I can fix the title myself but the share count isn't working.

When I use this in plain HTML:
<?php echo $fbLinkStats->link_stat->total_count.''; ?>
it works fine, but when I combine it all into another function to echo, it no longer works properly.

Thanks.

Hello there.new member here in need of help!
So i use the code the code below to display images from a folder into a form. My problem is that i put checkboxes with various selections in order to transfer the selected items later to a file or echo the submission. As it seems at the moment is that i can display correctly everything in my form but for some unknown reason i cannot echo/write to a txt file the files(names) that i choose with the checkbox.There seems to be something wrong with my loop but i'm not sure. I would appreciate any help.thank you in advance.

Here is my code:

<?php 
SESSION_START(); 
?>&#65279; 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> 
<head> 
<meta http-equiv="content-type" content="text/html; charset=utf-8" /> 
<meta name="author" content="vs" /> 
<meta name="robots" content="index, follow" /> 
<link rel="stylesheet" type="text/css" href="style.css" media="screen" /> 
<link rel="stylesheet" type="text/css" href="print.css" media="print" /> 
<link rel="stylesheet" href="lightbox.css" type="text/css" media="screen" /> 
<script type="text/javascript" src="js/prototype.js"></script> 
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script> 
<script type="text/javascript" src="js/lightbox.js"></script> 
<title></title> 
</head> 
<body> 

<div id="centerColumn"> 
<div id="header"> 

</div><!--//end #headern//--> 
    
<div id="navbar"> 
<ul> 
<li><a href="index.html" title="Home">Home</a></li> 
<li><a href="about.html" title="About us">About us</a></li> 
<li><a href="gallery.html" title="Gallery">Gallery</a></li> 
<li><a href="contact.html" title="Contact">Contact</a></li> 
</ul> 
</div><!--//end #nav//--> 
<?php 
echo '<h2 class="medium"><i>Hello '.$_SESSION['user'].'</i></h2>'; 
?> 
<p><span class="small"></span><br /> 
This is your private directory. Please submit your selections and fill in the contact form, thank you. 
</p><br> 
<div align="center"> 

<form method="post" action="data2file.php"> 
<?php 

echo '<div STYLE="overflow: auto; width: 780px; height: 600px; 
            border-left: 5px gray solid; border-bottom: 5px gray solid; border-top: 5px gray solid; border-right: 5px gray solid;; 
            padding: 0px; margin: 0px";> 
            
<table border="1" cellspacing=0 cellpadding=1> 
<tr><td>'; 
     $username = $_SESSION['user']; 
        $url = $username."/"; 
        $handle = opendir ($url); 
        while (false !== ($file = readdir($handle))) { 
            if($file != "." && $file != ".." && $file != basename(__FILE__)) {                    
                                                             
                  //echo '<table border=1><tr><td>';                    
                   echo '<a href="'.$url.$file.'" rel="lightbox"><img border=1 src="'.$url.$file.'"></a>'; 
                   echo '<br />'; 
                    
                   echo "<input type=CHECKBOX name=$file>"; 
                  print $file; 
                  echo '<br>'; 
                  echo                     
                            '<select name=color> 
                  <option>Select Color Format...</option> 
                  <option> Sepia </option> 
                  <option> Black & White </option>                   
                  </select>'; 
                  echo                     
                            '<br> 
                            <select name=size> 
                  <option>Select Size Format...</option> 
                  <option name=5x7> 5" x 7"(13x19 cm)</option> 
                  <option name=6x8> 6" x 8"(15x21 cm)</option> 
                  <option name=8x12> 8" x 12"(20x30 cm) </option>                   
                  <option name=9x14> 9" x 14"(24x30 cm) </option>                   
                  <option name=12x18> 12" x 18"(30x40 cm) </option> 
                  </select>'; 
                  echo '<br>Reprints <input type="text" name="reprints" size="1" value="0"><br />'; 
                  echo '<hr>'; 
                  //echo '</td></tr></table>';            
            
            } 
        } 
echo 
'</td></div>'; 

echo ' 
<td valign="top"> 
<p>*First name, Last name, Country, Home Address, Postal code and email fields are required*</p> 
<input type="text" name="first" value="First Name" size="35"/><br> 
<input type="text" name="last" value="Last Name" size="35"/><br> 
<select name="country"> 
    <option value="  " selected>(please select a country)</option> 
    <option value="AF">Afghanistan</option> 
    <option value="AL">Albania</option> 
    <option value="DZ">Algeria</option> 
    <option value="AS">American Samoa</option> 
    <option value="AD">Andorra</option> 
    <option value="AO">Angola</option> 
    <option value="AI">Anguilla</option> 
    <option value="AQ">Antarctica</option> 
    <option value="AG">Antigua and Barbuda</option> 
    <option value="AR">Argentina</option> 
    <option value="AM">Armenia</option> 
    <option value="AW">Aruba</option> 
    <option value="AU">Australia</option> 
    <option value="AT">Austria</option> 
    <option value="AZ">Azerbaijan</option> 
    <option value="BS">Bahamas</option> 
    <option value="BH">Bahrain</option> 
    <option value="BD">Bangladesh</option> 
    <option value="BB">Barbados</option> 
    <option value="BY">Belarus</option> 
    <option value="BE">Belgium</option> 
    <option value="BZ">Belize</option> 
    <option value="BJ">Benin</option> 
    <option value="BM">Bermuda</option> 
    <option value="BT">Bhutan</option> 
    <option value="BO">Bolivia</option> 
    <option value="BA">Bosnia and Herzegowina</option>echo 
    <option value="BW">Botswana</option> 
    <option value="BV">Bouvet Island</option> 
    <option value="BR">Brazil</option> 
    <option value="IO">British Indian Ocean Territory</option> 
    <option value="BN">Brunei Darussalam</option> 
    <option value="BG">Bulgaria</option> 
    <option value="BF">Burkina Faso</option> 
    <option value="BI">Burundi</option> 
    <option value="KH">Cambodia</option> 
    <option value="CM">Cameroon</option> 
    <option value="CA">Canada</option> 
    <option value="CV">Cape Verde</option> 
    <option value="KY">Cayman Islands</option> 
    <option value="CF">Central African Republic</option> 
    <option value="TD">Chad</option> 
    <option value="CL">Chile</option> 
    <option value="CN">China</option> 
    <option value="CX">Christmas Island</option> 
    <option value="CC">Cocos (Keeling) Islands</option> 
    <option value="CO">Colombia</option> 
    <option value="KM">Comoros</option> 
    <option value="CG">Congo</option> 
    <option value="CD">Congo, the Democratic Republic of the</option> 
    <option value="CK">Cook Islands</option> 
    <option value="CR">Costa Rica</option> 
    <option value="CI">Cote dIvoire</option> 
    <option value="HR">Croatia (Hrvatska)</option> 
    <option value="CU">Cuba</option> 
    <option value="CY">Cyprus</option> 
    <option value="CZ">Czech Republic</option> 
    <option value="DK">Denmark</option> 
    <option value="DJ">Djibouti</option> 
    <option value="DM">Dominica</option> 
    <option value="DO">Dominican Republic</option> 
    <option value="TP">East Timor</option> 
    <option value="EC">Ecuador</option> 
    <option value="EG">Egypt</option> 
    <option value="SV">El Salvador</option> 
    <option value="GQ">Equatorial Guinea</option> 
    <option value="ER">Eritrea</option> 
    <option value="EE">Estonia</option> 
    <option value="ET">Ethiopia</option> 
    <option value="FK">Falkland Islands (Malvinas)</option> 
    <option value="FO">Faroe Islands</option> 
    <option value="FJ">Fiji</option> 
    <option value="FI">Finland</option> 
    <option value="FR">France</option> 
    <option value="FX">France, Metropolitan</option> 
    <option value="GF">French Guiana</option> 
    <option value="PF">French Polynesia</option> 
    <option value="TF">French Southern Territories</option> 
    <option value="GA">Gabon</option> 
    <option value="GM">Gambia</option> 
    <option value="GE">Georgia</option> 
    <option value="DE">Germany</option> 
    <option value="GH">Ghana</option> 
    <option value="GI">Gibraltar</option> 
    <option value="GR">Greece</option> 
    <option value="GL">Greenland</option> 
    <option value="GD">Grenada</option> 
    <option value="GP">Guadeloupe</option> 
    <option value="GU">Guam</option> 
    <option value="GT">Guatemala</option> 
    <option value="GN">Guinea</option> 
    <option value="GW">Guinea-Bissau</option> 
    <option value="GY">Guyana</option> 
    <option value="HT">Haiti</option> 
    <option value="HM">Heard and Mc Donald Islands</option> 
    <option value="VA">Holy See (Vatican City State)</option> 
    <option value="HN">Honduras</option> 
    <option value="HK">Hong Kong</option> 
    <option value="HU">Hungary</option> 
    <option value="IS">Iceland</option> 
    <option value="IN">India</option> 
    <option value="ID">Indonesia</option> 
    <option value="IR">Iran (Islamic Republic of)</option> 
    <option value="IQ">Iraq</option> 
    <option value="IE">Ireland</option> 
    <option value="IL">Israel</option> 
    <option value="IT">Italy</option> 
    <option value="JM">Jamaica</option> 
    <option value="JP">Japan</option> 
    <option value="JO">Jordan</option> 
    <option value="KZ">Kazakhstan</option> 
    <option value="KE">Kenya</option> 
    <option value="KI">Kiribati</option> 
    <option value="KP">Korea, Democratic Peoples Republic of</option> 
    <option value="KR">Korea, Republic of</option> 
    <option value="KW">Kuwait</option> 
    <option value="KG">Kyrgyzstan</option> 
    <option value="LA">Lao Peoples Democratic Republic</option> 
    <option value="LV">Latvia</option> 
    <option value="LB">Lebanon</option> 
    <option value="LS">Lesotho</option> 
    <option value="LR">Liberia</option> 
    <option value="LY">Libyan Arab Jamahiriya</option> 
    <option value="LI">Liechtenstein</option> 
    <option value="LT">Lithuania</option> 
    <option value="LU">Luxembourg</option> 
    <option value="MO">Macau</option> 
    <option value="MK">Macedonia, The Former Yugoslav Republic of</option> 
    <option value="MG">Madagascar</option> 
    <option value="MW">Malawi</option> 
    <option value="MY">Malaysia</option> 
    <option value="MV">Maldives</option> 
    <option value="ML">Mali</option> 
    <option value="MT">Malta</option> 
    <option value="MH">Marshall Islands</option> 
    <option value="MQ">Martinique</option> 
    <option value="MR">Mauritania</option> 
    <option value="MU">Mauritius</option> 
    <option value="YT">Mayotte</option> 
    <option value="MX">Mexico</option> 
    <option value="FM">Micronesia, Federated States of</option> 
    <option value="MD">Moldova, Republic of</option> 
    <option value="MC">Monaco</option> 
    <option value="MN">Mongolia</option> 
    <option value="MS">Montserrat</option> 
    <option value="MA">Morocco</option> 
    <option value="MZ">Mozambique</option> 
    <option value="MM">Myanmar</option> 
    <option value="NA">Namibia</option> 
    <option value="NR">Nauru</option> 
    <option value="NP">Nepal</option> 
    <option value="NL">Netherlands</option> 
    <option value="AN">Netherlands Antilles</option> 
    <option value="NC">New Caledonia</option> 
    <option value="NZ">New Zealand</option> 
    <option value="NI">Nicaragua</option> 
    <option value="NE">Niger</option> 
    <option value="NG">Nigeria</option> 
    <option value="NU">Niue</option> 
    <option value="NF">Norfolk Island</option> 
    <option value="MP">Northern Mariana Islands</option> 
    <option value="NO">Norway</option> 
    <option value="OM">Oman</option> 
    <option value="PK">Pakistan</option> 
    <option value="PW">Palau</option> 
    <option value="PA">Panama</option> 
    <option value="PG">Papua New Guinea</option> 
    <option value="PY">Paraguay</option> 
    <option value="PE">Peru</option> 
    <option value="PH">Philippines</option> 
    <option value="PN">Pitcairn</option> 
    <option value="PL">Poland</option> 
    <option value="PT">Portugal</option> 
    <option value="PR">Puerto Rico</option> 
    <option value="QA">Qatar</option> 
    <option value="RE">Reunion</option> 
    <option value="RO">Romania</option> 
    <option value="RU">Russian Federation</option> 
    <option value="RW">Rwanda</option> 
    <option value="KN">Saint Kitts and Nevis</option> 
    <option value="LC">Saint LUCIA</option> 
    <option value="VC">Saint Vincent and the Grenadines</option> 
    <option value="WS">Samoa</option> 
    <option value="SM">San Marino</option> 
    <option value="ST">Sao Tome and Principe</option> 
    <option value="SA">Saudi Arabia</option> 
    <option value="SN">Senegal</option> 
    <option value="SC">Seychelles</option> 
    <option value="SL">Sierra Leone</option> 
    <option value="SG">Singapore</option> 
    <option value="SK">Slovakia (Slovak Republic)</option> 
    <option value="SI">Slovenia</option> 
    <option value="SB">Solomon Islands</option> 
    <option value="SO">Somalia</option> 
    <option value="ZA">South Africa</option> 
    <option value="GS">South Georgia and the South Sandwich Islands</option> 
    <option value="ES">Spain</option> 
    <option value="LK">Sri Lanka</option> 
    <option value="SH">St. Helena</option> 
    <option value="PM">St. Pierre and Miquelon</option> 
    <option value="SD">Sudan</option> 
    <option value="SR">Suriname</option> 
    <option value="SJ">Svalbard and Jan Mayen Islands</option> 
    <option value="SZ">Swaziland</option> 
    <option value="SE">Sweden</option> 
    <option value="CH">Switzerland</option> 
    <option value="SY">Syrian Arab Republic</option> 
    <option value="TW">Taiwan, Province of China</option> 
    <option value="TJ">Tajikistan</option> 
    <option value="TZ">Tanzania, United Republic of</option> 
    <option value="TH">Thailand</option> 
    <option value="TG">Togo</option> 
    <option value="TK">Tokelau</option> 
    <option value="TO">Tonga</option> 
    <option value="TT">Trinidad and Tobago</option> 
    <option value="TN">Tunisia</option> 
    <option value="TR">Turkey</option> 
    <option value="TM">Turkmenistan</option> 
    <option value="TC">Turks and Caicos Islands</option> 
    <option value="TV">Tuvalu</option> 
    <option value="UG">Uganda</option> 
    <option value="UA">Ukraine</option> 
    <option value="AE">United Arab Emirates</option> 
    <option value="GB">United Kingdom</option> 
    <option value="US">United States</option> 
    <option value="UM">United States Minor Outlying Islands</option> 
    <option value="UY">Uruguay</option> 
    <option value="UZ">Uzbekistan</option> 
    <option value="VU">Vanuatu</option> 
    <option value="VE">Venezuela</option> 
    <option value="VN">Viet Nam</option> 
    <option value="VG">Virgin Islands (British)</option> 
    <option value="VI">Virgin Islands (U.S.)</option> 
    <option value="WF">Wallis and Futuna Islands</option> 
    <option value="EH">Western Sahara</option> 
    <option value="YE">Yemen</option> 
    <option value="YU">Yugoslavia</option> 
    <option value="ZM">Zambia</option> 
    <option value="ZW">Zimbabwe</option> 
</select> 
<input type="text" name="address" value="Home Address" size="45"> 
<input type="text" name="address" value="Postal Code" size="35" 
<input type="text" name="email" value="e-mail" size="35"/><br> 
<input type="text" name="date" value="Wedding Date (dd-mm-yyyy)" size="35"/><br> 
<input type="text" name="time" value="Wedding Time (hh:mm)"/><br> 
<input type="text" name="hotel" value="Hotel" size="35"/><br> 
<input type="text" name="room" value="Room Number" size="10"/><br> 
<hr> 
<TEXTAREA NAME="comments" ROWS=10 COLS=45 value="Comments">Notes / Comments 
</TEXTAREA><br> 
</td></tr> 
</table>'; 
echo '</div> 
<br> 
<input type="submit" name="submit" value="Submit">&nbsp;<input type="reset" name="reset" value="Reset">&nbsp;<a href="logout.php"><input type="button" name="logout" value="Logout"></form></a> 
</div> 
<br>'; 
?> 
<div id="footer"> 
<a href="http://validator.w3.org/" title="W3C HTML Validation">XHTML</a> . 
<a href="http://jigsaw.w3.org/css-validator/validator-uri.html" title="W3C CSS Validation">CSS</a> . 
<a href="http://www.w3.org/TR/WCAG10/" title="Web Content Accessibility Guidelines">WCAG</a> . 
<a href="http://www.csstinderbox.com">The CSS Tinderbox</a></div> 
<div align="center" class="boxes"> 
  <!--//end #footer//--><small> 
  &copy;2009-2010</small></div> 
</div> 
<!--//end #centerColumn//--> 
<!--width=256 height=170--> 
</body> 
</html>


and here is the process to file code:

<?php 
SESSION_START(); 
$arxeio = "data.txt"; 
$fp = fopen($arxeio, "a") or die("Couldn't open $arxeio for writing!"); 
//fwrite($fp, $_POST[$file]."\n"); 
fwrite($fp, $_POST['color']."\n") or die("Couldn't write values to file!"); 
fwrite($fp, $_POST['size']."\n"); 
fclose($fp); 
echo $_SESSION['user']; 
echo $_POST['color']; 
echo $_POST['country']; 
echo "Saved to $arxeio successfully!"; 
?> 


How should i make my code to work only for the selected items along with their attributes.
Thank you very much.

Hello,

hello everyone, please anyone can help me how to read data of excel file in php

Hey folks,

I thought this would be simple but obviously not. I can get the data to display in the textarea from the text file. That's not an issue. The issue is, updating the text from the textarea and saving it in the file, while keeping the text in the textarea.
Basically, I want to create a personal notepad inside the site I am making.

Here is the code I am using:

<form action="?admintext.txt" method=post>
<textarea name="file_content" class="textarea1"><? include "admintext.txt"; ?></textarea><br/>
<input type=submit name=submit value=Update>
</form>

Can anyone help with this? I tried loads of tips I found from Google but none worked.

Is this the correct way to write binary data to a file?

$string = 'this is a string';
$handle = fopen('b.dat', 'wb');
for($i=0;$i<strlen($string);$i++){
    $hx = bin2hex($string{$i});
    fwrite($handle, pack("H*", $hx));
} 

If so, how do I read it an convert it back to a string?
If it is not correct, how do I do it?

hi all i'm trying to make a quick and simple '.htaccess' installer and i'm using fopen/fwrite to do this but i'm getting an error:

Quote

Parse error: parse error in /var/www/test.php on line 12


here's the code:

Code: [Select]
<?PHP
$File = ".htaccess";
$fh = fopen($File, 'a');
$Data = "\n#test write
<IfModule mod_deflate.c>
   AddOutputFilterByType DEFLATE text/css
   AddOutputFilterByType DEFLATE text/javascript application/javascript application/x-javascript text/x-js text/ecmascript application/ecmascript text/vbscript text/fluffscript
   AddOutputFilterByType DEFLATE image/svg+xml application/x-font-ttf application/x-font font/opentype font/otf font/ttf application/x-font-truetype application/x-font-opentype application/vnd.ms-fontobject application/vnd.oasis.opendocument.formula-template
   AddOutputFilterByType DEFLATE text/xml application/xml
</IfModule>
<IfModule mod_expires.c>
<FilesMatch "\.(ico|gif|jpg|JPG|jpeg|png|PNG|swf|css|js|html?|xml|txt)$">
ExpiresActive On
ExpiresDefault "access plus 1 month"
</FilesMatch>
</IfModule>
#test write\n";
fwrite($fh, $Data);
fclose($fh);
?>
how do i include the code in the $Data string bit?