PHP - Variable Fopen File Name Loop To Make Multiple Files?

I know it needs a for loop, but i don't know where in the code i should be putting it?

Code: [Select]
function check_input($value)
{
// Stripslashes
if (get_magic_quotes_gpc())
  {
  $value = stripslashes($value);
  }
// Quote if not a number
if (!is_numeric($value))
  {
  $value = "'" . mysql_real_escape_string($value) . "'";
  }
return $value;
}

$_POST = array_map('check_input', $_POST);

$sql="INSERT INTO testimonials (CustomerName, Town, Testimonial, SortOrder, Images)
VALUES
({$_POST['customername']}, {$_POST['town']}, {$_POST['testimonial']}, {$_POST['sort_order']}, '$imgname'

)";

}
if (!mysql_query($sql,$con))
  {
  die("<br>Query: $sql<br>Error: " . mysql_error() . '<br>');
  }
echo "<p align=center><b>1 testimonial added</b></p>";

mysql_close($con);


Thanks in Advance,
Steve

So in my last thread I was working on checking if a file was there...I resorted to something not in the library and used

$pic_exists_jpg = fopen($jpg_path,'r');
$pic_exists_jpeg = fopen($jpeg_path,'r');
$pic_exists_gif = fopen($gif_path,'r');
$pic_exists_png = fopen($png_path,'r');
if ($pic_exists_jpg != '0') {
$jpg_test = '1';
} elseif ($pic_exists_jpg == '1') {
$jpg_test = '2';
} elseif ($pic_exists_jpg == '0') {
$jpg_test = '2';
} elseif ($pic_exists_jpeg != '0') {
$jpeg_test = '1';
} elseif ($pic_exists_gif != '0') {
$gif_test = '1';
} elseif ($pic_exists_png != '0') {
$png_test = '1';
}

now for some reason php is being a poo and no matter what returning that there is a file there. no matter what method i use be it fopen or file_exists or anything else, it saying I have a file in that directory BUT I DO NOT! THERE IS NOT ONE OF THOSE FILES. I know I have my paths right because If I echo them directly I get the picture...what the heck?!

if (!file_exists('../images/flags/imNum.txt')) {

$file1 = fopen('../images/flags/imNum.txt','c');

fclose($file1);
}

why won't that work =\

it makes no sense to me

I have a script that I am trying to transfer one file from a remote server to my local server and save it. The files can be quite large. I have successfully backed up around 200 MB... But, anything over that seems to fail with a strange error... I was hoping for a little guidance... here is my code and error/warning that I get:

PHP Code:
function remote_capture($tmp_url, $filename)
   {
   
      $r_handle = fopen($tmp_url, "rb");
      $d_handle = fopen($filename, 'w');
      
      if($r_handle&&$d_handle)
      {
          while(($buffer = fgets($r_handle)) !== false)
          {
            fputs($d_handle, $buffer);
          }
         
          fclose($r_handle);
         fclose($d_handle);
         
         return true;
         
      }
      else
      {
         return false;
      }
   
   }

Warning Message:
Warning: file_get_contents(URL_OF_MY_SCRIPT_HAS_BEEN_REMOTED) [function.file-get-contents]: failed to open stream: HTTP request failed! in /path/on/my/local/server/to/script on line 298

Hey guys,


I have a script that is run once a week to fetch some user info for a large number of accounts.
The code I have now writes the info correctly, but I was wondering if there was an easy way to have the accountdata.txt file completely wiped before new updated info is written to it, as opposed to deleting it manually every week.

        $FileName = "accountdata.txt";

$f=fopen($FileName,"a+");

fwrite($f, $UserKey[$i]." ".$SigKey[$i]."\n");

$f=fclose;


I could in theory just open the file and delete everything in it manually, save it and then run this script, but I'm always looking for more ways to make things efficient, and come a time when it's run more than once a week it'd be nice to have all that automated.

So in summary, I need it to delete all data (if any) from the accountdata.txt file before it writes anything to it.

Thanks.

Can't figure out why the page wont save after clicking save.

$KOHDE="index.php?s=admin";
$LOMAKE_W = 400;
$TEXTAREA_W = 50;
$TEXTAREA_H = 20;
$LOMAKE = mysql_real_escape_string($_GET["l"]);
$LOMAKE2 = mysql_real_escape_string($_POST["lomake"]);

after a few more lines...

elseif ($LOMAKE2 == "etusivu"){ #Etusivun muokkaus
$teksti = stripslashes($_POST["teksti"]);
$f = fopen("etusivu.php", "w");
fwrite($f, $teksti);
fclose($f);
}
elseif ($LOMAKE == "etusivu"){ #Etusivun muokkaus
echo "<h1>Edit home page</h1>";
$f = file("etusivu.php");
echo "<form action='$KOHDE' method='post'>
<textarea name='teksti' cols='$TEXTAREA_W' rows='$TEXTAREA_H'>";
for ($i = 0; $i < count($f); $i++){
$f[$i] = str_replace("\"", "''", $f[$i]);
echo $f[$i];
}
echo "</textarea>
<input type='hidden' value='etusivu' name='lomake'/>
<br><input type='submit' value='Save'/>
</form><br/>";
html_ohje();
}

I can't see where it has gone wrong. Can anyone help?

Hey,

I'm trying to open a .php file and read a comment block that is in the beginning of the file.

I'm having some trouble in that nothing is being echoed out.

Here is the reading file:

<?php

$fb = fopen("tepl.php", "r");

$data = fread($fb, 8192);

fclose($fb);

var_dump($data);

?>


here is the file (tepl.php) being read:

<?php
/*
Name: Test Plugin 1
URI: http://www.theorangeday.com/plugintest/
Description: This is just a test plugin because I need to test how this thing is going to work overall.
Author: Thomas Francis
Author URI: http://www.theorangeday.com/
Version: 0.1
*/

function test_plugin(){
echo "we loaded the test plug";
}

?>


the var_dump returns
Code: [Select]
string(321) " "
What's wrong here?

I have a php script on a server writing to an html file on a remote server. I'm using the following combination of fopen and fputs. The problem is that once out of maybe every 10 or 15 writes to the file, the file that is written is blank with nothing in it.

Has anyone here had experience with this before? The file is fixed the next time it writes to it. this code is within a loop that runs every 10 seconds.



Code: [Select]
// Allows overwriting of existing files on the remote FTP server
$stream_options = array('ftp' => array('overwrite' => true));

// Creates a stream context resource with the defined options
$stream_context = stream_context_create($stream_options);

// Opens the file for writing and truncates it to zero length
if ($fh = fopen($ftp_path, 'w',0, $stream_context))
{

if ( $change > 0   )
fputs($fh, "the contents of the html file is here");      //the case if change is positive

else
fputs($fh, "the contents of the html file is here");   //the case if change is negative

// Closes the file handle
fclose($fh);
}
else
{
die('Could not open file.');
}

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Okay so my news script is set to view only 10 pieces of news. But I want it so that it starts a new page once I have more than 10 pieces of news.

Code: [Select]
<?php
require("functions.php");
include("dbconnect.php");

session_start();

head1();
body1();
new_temp();
sotw();
navbar();
     
$start = 0;
$display = 10;
$query = "SELECT * FROM news ORDER BY id DESC LIMIT $start, $display";
$result = mysql_query( $query );

if ($result) {
    while( $row = @mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
        news_box( $row['news'], $row['title'], $row['user'], $row['date'], $row['id'] );
    }
    mysql_free_result($result);
} else {
    news_box( 'Could not retrieve news entries!', 'Error', 'Error', 'Error');
}
                   
footer();

mysql_close($link);
?>
I tried a few things but they failed....miserably.

I run a dev site locally on Windows and the real site on a hosting provider on LINUX. PHP5, XAMP, etc.

Locally my fopen works.
On the web server it throws an error: "Warning: fopen() [function.fopen]: Unable to access" filepath/name

The file exists on both servers; upper/lower case is correct; so are access rights.

I noticed the error only today; this was working for the last 7 months; the function serves a range of content-types; just tested XLS and it works.

Now I am stuck 

This line throws the error:
$handle = fopen($strPathFileName, 'rb');

$strPathFileName uses / only

Any pointers appreciated... thanks.

can anybody tell me what's wrong with my query ?


$filesa = "SELECT id, uid, size, filehash, filename, dwnloads, swidth, sheight, fores, flabel, vpre FROM pf_fmusic WHERE (aid='$albumid' AND vpre='complete') ORDER BY id DESC";


I am using this in while loop with ps_pagination class but getting 2 records for same set of files. in other words its running while loop 2 time complete code is here...


       $filesa = "SELECT id, uid, size, filehash, filename, dwnloads, swidth, sheight, fores, flabel FROM ibwf_fmusic WHERE (aid='$albumid' AND vpre='complete') ORDER BY id DESC";
$pager = new PS_Pagination($conn, $filesa, 9, 5, $albumid, $sortid, $sub, $selectalbum3[uid], $title, $collective);
$results = $pager->paginate();
  while($files=mysql_fetch_array($results))
  {
// Blah Blah
}


Output is something like this

1. song 1
2. song 2
3. song 3
4. song 4
1. song 1
2. song 2
3. song 3
4. song 4

 Thanks is advance

I am working on a little project for my site and I am trying to get this script to ignore the index.html file and the .htaccess file in there. I just want it to display all files like .zip, .rar, .tar, .gz, .gtar, .ace, ect...

  echo "    <td width='70%'><select id='download'>";
        echo "    <option value=''>None</option>";
if ($handle = opendir("./modules/Downloads/files")) { 
    while (false !== ($file = readdir($handle))) {  
        if ($file != "." && $file != "..") {  
echo "    <option value='".$file."'>".$file."</option>";  
        }  
    } 
    closedir($handle);  
}


echo "    </td>\n";

Hey guys,

im starting out on my php journey with a small question.

I have a small uploading site and i want to allow php uploads. Once uploaded, you get a direct upload link, and i want the file to download, rather than execute.

How can this be done?

Thanks!

Hi All

I am trying to set up a system that where a user sets up an account the system automatically sets up a new directory and inserts template files into it.

I understand mkdir is something to do with it.

Does anyone know how to go about this please?

thanks