PHP - Working With Csv File Data

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

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.

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

 

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 .

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'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?

//database
create table mydata (
	id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fname varchar(20),	
    phoneno int(12) NOT NULL
    /*......*/
);
//class my data php

<?php

include('connect.php');
class InsertMydata {
    public function insertnow($fname, $phoneno) {
        $connect = new Connect;
        $insrt = $db -> prepare('INSERT INTO mydata (fname, phoneno) VALUES (?,?)');
		$insrt -> execute(array($fname, $phoneno));		
	}
}
?>


//insernow validate form

<?php
include('../classs/mydata.php');
//Declare data and error arrays
$errors = [];
$mydara = [];
if(!preg_match('/^[a-zA-Z]{4,15}$/', $_POST['fname'])) {
	$errors['fname'] = 'Enter full name!';
}
//this block not working even the phone exist
$connect = new Connect;
$phoneno = $_POST['phoneno'];
$checkiexist = $connect -> prepare('SELECT * FROM mydata WHERE phoneno = ?');
$checkiexist -> execute([$phoneno]);
if($checkiexist->rowCount() > 0) {
      $errors['phonenoexist'] = 'Try another phone number!';
 }
if(!empty($errors)){
      $data['success'] = false;
      $data['errors'] = $errors;
}else{
      $data['success'] = true;
      $data['message'] = 'success message!';  
      $mydata = new InsertMydata;
      $mydata -> insertnow($fname, $phoneno);
}
echo json_encode($data);

?>

//my ajax

$("#insertbtn").click( function(e) {
     var fname = $('#fname').val(),
         phoneno = $('#phoneno').val(),
           
       $.ajax({
           url: 'insertnow.php',
           type: 'POST',
           data: {fname:fname, phoneno:phoneno},
           dataType: "JSON",
           encode: true,
        }).done( function (data) {
         
         if (data.success == false) {
           if (data.errors.fname) {
                 $('#fname').append('<p class="text-danger">' + data.errors.fname + '</p>');
            } 
            if (data.errors.phonenoexist) {
              $('.card-header').append('<div class="alert alert-info alert-dismissible" role="alert">
                <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>'+data.errors.phonenoexist+'</div>');
            }
            } else {
             $('.card-header').append('<div class="alert alert-success alert-dismissible" role="alert"><button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>'+data.message+'</div>');
        }
    });
       e.preventDefault();
    });


//the problem is, the code insert data even if the phone exist why?

the problem is, the code insert data even if the phone exist why?

Edited April 8 by mahenda

Hello there,

I have a script which uses the LOAD DATA LOCAL INFILE command see below:

<?php

//connect to your database
mysql_connect("localhost", "xxx", "xxx"); //(host, username, password)

//specify database 
mysql_select_db("xxx") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "LOAD DATA INFILE  '/public_html/admin/files/test-jp-stock.csv' INTO TABLE 'jpaero_stocksearch' FIELDS TERMINATED BY  ',' LINES TERMINATED BY  '\r\n' IGNORE 1 LINES";
     
if(mysql_query($query)){

echo ">> New Stock Data has now been uploaded. Database is now live and searchable.";}
else{

echo "Upload failed. Please contact support.";}

?> 

Initially I uploaded the csv file through phpmyadmin and everything worked fine - so I then used the SQL generated inside my script, changing the location to where the file actually is - however now nothing happens at all.

Any ideas on whats gone wrong, gratefully received!

Thanks,

Hello,

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"

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);

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>

Ok, I have tried using the code from this link http://answers.yahoo.com/question/index?qid=20100927173625AAmEmiW


Code: [Select]
<?php
// Get the name they entered in the form
// We'll be naming the file this
$file = $_POST['name'];
// Get the email from the form
$email = $_POST['email'];
// We want the file to be a text file right?
$ex = ".txt";
// Try to open a file named $file$ex (johndoe.txt for example)
// Because this file doesn't exist yet the server creates it
$write = fopen("$file$ex","w");
// Now open the file up again but this time save the email in it
fwrite($write,$email);
// MAKE SURE you close the file!!!
fclose($write);
// The folder that this script is in on the server is where the file we just made was saved
// We can 'rename' it to another folder
// The folder on the server we want to move it to 
$data = "../emails/";
// Now put it all together: This example goes out of the folder we're in and into the folder 'emails'
// The new 'name' would be this now (../emails/johndoe.txt): So now the file is moved to where we want for storage
rename ("$file","$data$file$ex");
// The script is done, send the user to another page (Just read the address below and you'll get it)
exit;
?>



unfortunately it doesn't do as i would like.  I'm not sure how to get it to save a new file based on a variable on the form page or from one of the fields in the form.  What i need is a way for a user to submit the form and it save the data into a uniquely named csv file.  I know the code given is for text files, not csv, but that was about all i could find.  If there is any help i would greatly appreciate it.

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.

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?