PHP - Get Data Out Of Xml File

I'm trying to write to a xml file from my database. Have it writing to the file ok with a simple string:
--------
$handle = fopen("test.xml", "w");//erase file first

$filename = 'test.xml';

$somecontent = "Add this text to the file\n";

// make sure the file exists and is writable first.
if (is_writable($filename)) {

    // that's where $somecontent will go when we fwrite() it.
    if (!$handle = fopen($filename, 'a')) {
         echo "Cannot open file ($filename)";
         exit;
    }

    // Write $somecontent to our opened file.
    if (fwrite($handle, $somecontent) === FALSE) {
        echo "Cannot write to file ($filename)";
        exit;
    }

    echo "Success, wrote ($somecontent) to file ($filename)";

    fclose($handle);

} else {
    echo "The file $filename is not writable";
}
?>
--------

So how would i go about adding a while loop to it to so it writes all the rows from my database. I was going to manually write the xml tags in.
For example:
<newsitem id=['id']>
<title>['heading']</title>
<content>['description']</content>
<date>['date']</date>
</newsitem>

obviously with the php tags... just not sure how to do this loop within the fwrite section.

I tried just the normal :
 while ($row = mysql_fetch_array($result))
   {                                                                           
      print "  <tr>";                                                       
      print "    <td>" . $row["id"] . "</td>";
      print "    <td>" . $row["date"]. "</td>";
      print "    <td>" . $row["heading"]. "</td>";
      print "    <td>" . $row["content"]. "</td>";
      print "  </tr>";                                                       
   }                                                                           
   print "</table>";

}

but it wasnt writing it into the file, not sure how i would reference that loop code to the $somecontent variable.

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

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!!!

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?

Hi all,

this is the code i'm using at the moment which is at the bottom of a webpage

Code: [Select]
// Open file export.csv.
$f = fopen("export.csv", "w");

// Put all values from $out to export.csv.
fputs($f, $out);
fclose($f);

$filename = "StatisticalAnalysis-" . gmdate("Y-m-d-H-i-s") . ".csv";

header("Content-type: application/csv");
header("Content-Disposition: attachment; filename=" . $filename);
readfile("export.csv");
The variable named $out is a long line of text in csv format. I've echoed that variable and it's all good.

When a checkbox in a form further up the page is checked the code creates and fills in the $out variable and then carries out the code above.

The problem i have is that when the csv save dialog comes up and the file is saved, all it contains is a copy of the html code which is on that page, not the info stored in the $out variable.

Can anyone offer any advice on what the problem is?

Cheers

i have a text file that has spaces between each column.

eg

12 12 13 22 34.5
10 13 18 88 32.5
12 33 17 23 22.3

(the actual data is weather data that accumulates a new line every 15 mins and is seen at www.maidenerleghweather.com/clientraw.txt )

each column represents a weather variable.

i would like to use php to find the maximum values in each column and minimum values etc etc.

how can i get the text data into arrays, so that i can then easily perform some simple stats on it?

HOWEVER each line would NOT be an array.

the first value in each line makes up array number one, second makes up two etc

any ideas for a newbie beginner would be welcomed.

Any help on this would be greatly appreciated.  I am trying to run a mysqldump from my site for my client when they want to back up.  They basically will jsut click a button to run the backup. 

With my script below, the backup file is genrated, but there is no table data in the file.  There are the headers in the file with the server IP, linux versin, etc..., but there is no data in the file.  Does this look right?  Thank you for helping me out.

Ryan

Code: [Select]
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$dbhost = 'localhost';
$dbuser = 'databaseuser';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'database';
mysql_select_db($dbname);

$tableName  = 'lots';
$backupFile1 = '/home/stuff/wwwroot/stuff/appnew/backup/';
$backupFile = $backupFile1.$dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h$dbhost -u$dbuser -p$dbpass $dbname | gzip > $backupFile";
system($command);
$result = mysql_query($command);

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?

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.

Hey guys, first post and I've just returned to PHP after about 4 years of no coding, so be gentle! 

In a nutshell I'm creating a photo album and I've pretty much got the majority of it complete, apart from a few tweaks and the obvious ongoing development.

I'm at the stage now where I need to moderate images being uploaded, so I've made an admin only script which displays the uploaded images with links that say approve and delete.

Uploaded images are stored in uploads/ which are left there until i move them to img/, plus the filename is stored in mysql so I can "<img src='../uploads/".$row['filename']."' width='200'>".

Now, I would like to make the Approve button move the image from uploads/ to img/ and I'd like the delete button to remove both the entry from MySQL and the file from the uploads folder and I'm not too sure on how to make it work.

Here's what I have so far in the mod.php file (mod for moderation)

Code: [Select]
$image = mysql_query("SELECT * FROM images WHERE id");
while($row = mysql_fetch_assoc($image))
{
echo "
<table>
<td>
<tr>
<img src='../uploads/".$row['filename']."' width='200'><br />
</tr>
</td>
<td>
<tr>
<a href=''>Approve</a> <a href=''>Delete</a>
</tr>
</td>
</table>
";
}
You'll have to ignore the table tags, I'm still getting used to positioning items on the screen lol.

Any clues would be greatly appreciated

Live long and prosper.

Just trying to create a simple form that will let you enter a message that will get written to a text file.

Code for SetMessage.php:

Code: [Select]

<?php

if($_SERVER['REQUEST_METHOD'] != 'POST')
{
?>

<form method="POST" action="setmessage.php" name="setmessage">
<p>Message to Display:<Input type="text" name="message" size="50"></p>
<p><input type="submit" value="Submit" name="submit"></p>
</form>
<?php
}
else
{
   //Writes the contents of the message to a file
   echo file_put_contents('message.txt', $_POST['message']);
}
?>


When submitting, I get the error "Call to undefined function: file_put_contents() on line 16"

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, this script originally works by reading a physical copy of 'bans.txt' located in the same directory. How could I get it to read the remote bans.txt located here and parse info from it like the on-site copy?

the remote file: http://108.163.211.219/bans.txt

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Data Tables and Cascading Style Sheets Gallery</title>
<style>/*
Tema: Soft Table - A Simple table style with the use of the soft brown color
Author: Newton de G?es Horta
Site: --
Country Origin: Brazil
*/

table {
 font-size:0.9em;
 font-family: Arial, Helvetica, verdana sans-serif;
 background-color:#fff;
 border-collapse: collapse;
 width: 100%;
}
caption {
 font-size: 25px;
 color: #1ba6b2;
 font-weight: bold;
 text-align: left;
 background: url(http://www.nghorta.com/csstg/header_bg.jpg) no-repeat top left;
 padding: 10px;
 margin-bottom: 2px;
}
thead th {
 border-right: 1px solid #fff;
 color:#fff;
 text-align:center;
 padding:2px;
 text-transform:uppercase;
 height:25px;
 background-color: #a3c159;
 font-weight: normal;
}
tfoot {
 color:#1ba6b2;
 padding:2px;
 text-transform:uppercase;
 font-size:1.2em;
 font-weigth: bold;
 margin-top:6px;
 border-top: 6px solid #e9f7f6;
}
tbody tr {
 background-color:#fff;
 border-bottom: 1px solid #f0f0f0;
}
tbody td {
 color:#414141;
 padding:5px;
 text-align:left;
}
tbody th {
 text-align:left;
 padding:2px;
}
tbody td a, tbody th a {
 color:#6C8C37;
 text-decoration:none;
 font-weight:normal;
 display:block;
 background: transparent url(http://www.nghorta.com/csstg/links_yellow.gif) no-repeat 0% 50%;
 padding-left:15px;
}
tbody td a:hover, tbody th a:hover {
 color:#009193;
 text-decoration:none;
}
/* tr:nth-child(even) {
    background-color: grey;
} */
</style></head>
<body>

<table summary="Submitted table designs">
<thead><tr>
<th style="font-size:12px" scope="col"><center>Nickname</center></th>
<th style="font-size:12px" scope="col"><center>Admin</center></th>
<th style="font-size:12px" scope="col"><center>Banned</center></th>
<th style="font-size:12px" scope="col"><center>Reason</center></th>
<th style="font-size:12px" scope="col"><center>SteamID</center></th>
<th style="font-size:12px" scope="col"><center>Length</center></th>
<th style="font-size:12px" scope="col"><center>Status</center></th>
</tr></thead>


<tbody>

<!-- <tr><th scope="row" id="r100"><a href="100.php">rows table template</a></th>
<td><a href="http://www.adobati.it">Omar '0m4r' Adobati</a></td><td>Italy</td>
<td>Simple, clean and a quite classic table template :)</td>
<td><a href="http://www.adobati.it/labs/CSSTable/0m4r.table.css" title="Download the rows table template CSS file">Download</a></td>
<td>test</td>
<td>test2</td>
</tr> -->




<?php

// Credits to justin as he was able to understand my messy PHP code and do this much better code for me.

function buildBanList($arr)
{

$filename = "bans.txt";

$bans = array();

$tmp_array = array();



// Build Ban Array
if (file_exists($filename)) 
{
foreach( $arr as $line )
{



if( substr(trim($line), 0, 7) == '"STEAM_' )
{

$tmp_array["user_steamid"] = str_replace('"', '', trim($line));

}



if( substr(trim($line), 0, 6) == '"time"' )
{

$tmp = explode(' ', trim($line));

$tmp_array["user_bantime"] = str_replace('"', '', $tmp[1]);

}



if( substr(trim($line), 0, 15) == '"modified_time"' )
{

$tmp = explode(' ', trim($line));

$tmp_array["user_modified"] = str_replace('"', '', $tmp[1]);

}



if( substr(trim($line), 0, 7) == '"unban"' )
{

$tmp = explode(' ', trim($line));

$tmp_array["user_unban"] = str_replace('"', '', $tmp[1]);

}



if( substr(trim($line), 0, 7) == '"admin"' )
{

$tmp = explode('" "', trim($line));

$tmp2 = explode('(', $tmp[1]);

$tmp_array["admin_name"] = str_replace('"', '', $tmp2[0]);

}



if( substr(trim($line), 0, 6) == '"name"' )
{

$tmp = explode('" "', trim($line));

$tmp_array["user_name"] = str_replace('"', '', $tmp[1]);

}



if( substr(trim($line), 0, 8) == '"reason"' )
{

$tmp = explode('" "', trim($line));

$tmp_array["user_reason"] = str_replace('"', '', $tmp[1]);

}



// Save ban record to main array once detected end.

if( substr(trim($line), 0, 1) == '}' )
{

// If console ban then set required fields.

if( $tmp_array["admin_name"] == "")
$tmp_array["admin_name"] = "Console";

array_push($bans, $tmp_array);
$tmp_array = array();

}

}
}



//Sort Array by Ban Date

$tmp = array(); 

foreach($bans as &$ma) 

    $tmp[] = &$ma["user_bantime"];

array_multisort($tmp, SORT_DESC, $bans); 



return $bans;



}



//Begin Presentation



$file = file("./bans.txt");

date_default_timezone_set("Europe/London");



$bans = buildBanList($file);



foreach ($bans as $ban)

{

echo '<tr>
';

// Output
if ($ban["user_name"] != '')
echo '<td style="text-align:center; font-size: 12px">'.$ban["user_name"].'</td><td style="text-align:center; font-size: 12px" class="admin">';
else
echo '<td style="text-align:center; font-size: 12px"><span style="color:#FF0000">N/A</span></td><td style="text-align:center; font-size: 12px" class="admin">';


echo $ban["admin_name"].'</td><td style="text-align:center; font-size: 12px">'.date('H:i - d/m/y',$ban["user_bantime"]).'</td>';

/* Unban date.
if ($ban["user_unban"] != "0")
{

echo date('H:i - d/m/y',$ban["user_unban"]);

} else {

echo "Never";

}*/


 echo '<td style="text-align:left; font-size: 11px">'.$ban["user_reason"].'</td>';


// Status
$today = strtotime("now");
echo '</td><td style="text-align:center; font-size: 12px">'.$ban["user_steamid"].'&nbsp;&nbsp;</td>';

// Ban Length
$date1 = date('y-m-d H:i:s',$ban["user_bantime"]);
$date2 = date('y-m-d H:i:s',$ban["user_unban"]);
$to_time=strtotime($date1);
$from_time=strtotime($date2);

$ban_length = round(abs($to_time - $from_time) / 60,0);
if ($ban["user_unban"] != "0")
{
// Days
if ($ban_length >= 1440)
{
$ban_length = round(abs($to_time - $from_time) / 24 / 60 / 60,0);
// Years couldn't be arsed to think of another way to do it.
if ( $ban_length >= 365 )
{
$ban_length = round(abs($to_time - $from_time) / 360 / 24 / 60 / 60,0);
if ($bans_length > 1)
echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Years </td>";
else
echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Year </td>";
}
else
echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Days </td>";
}
// Hours
else if ($bans_length >= 60)
{
$ban_length = round(abs($to_time - $from_time) / 60 / 60,0);
if ($bans_length > 1)
echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Hours </td>";
else 
echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Hour </td>";
}
else
echo "<td style=\"text-align:center; font-size: 12px\">".$ban_length." Minutes </td>";
}

else {
echo "<td style=\"text-align:center; font-size: 12px\">Permanent</td>";
}

if ($ban["user_unban"] == "0")
echo '<td style="text-align:center; font-size: 12px"><span style="color:#FF0000">Banned</span></td>';

else if ( $today  > $ban["user_unban"] )
echo '<td style="text-align:center; font-size: 12px"><span style="color:#008000">Expired</span></td>';

else
echo '<td style="text-align:center; font-size: 12px"><span style="color:#FF0000">Banned</span></td>';

echo '</tr>';


}

?></table>

<center><p>Web-based ULX bans by Russy.</p></center>

</div>



</body>

</html>
I've tried experimenting w/ stuff like

Code: [Select]
$filename = "http://108.163.211.219/bans.txt";
$contents = file_get_contents($filename);
but it doesn't seem to want to work.

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.

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?