[array of file paths putting white space in front of filenames]

I did try trim, and it had been returning the same results... I went ahead and tried it again, just for good measure and it seems to be working now...

thanks man.

[array of file paths putting white space in front of filenames]

Hello, i have the following code: php 5, ms server 2008, iis 7

I pass this script a csv list of file paths like so...

,C:\path\path\path\file.name,C:\path\path\anotherFile.name,C:\path\path\path\file3.file

(yes there is a leading comma in the string for some reason..)

$files = $_POST['files'];

$files = explode(',', $files)
foreach($files as $filename){
if(file_exists($filename)){

echo '":' . $filename .':"Does Exist<br />';

} else {

echo 'Sorry ":' . $filename . ':" Does Not Exist<br />';

}
}

My problem:

the first file path shows it exists and there is no white space in the string, all the file paths after the first one show like such:

 

":C:\path\path\path\file.name:" Does Exist  // 1st path (good)

": C:\path\path\anotherFile.name :" Does Not Exist

": C:\path\path\file3.file:" Does Not Exist

 

pleas note... i put the ": and :" in there to show that there is indeed a white space character in front of and behind the filepaths. EXCEPT for the last path.. there is no trailing white space there.

 

Please explain why you think the white space is being added to these and what i can do to get rid of it.

 

thanks,

dogdaynoon

 

 

 

[php loop for changing mssql results]

that worked great! however it doesn't stop.

infinite...

I will look at that and get back here once I see why that is happening...

 

 

THIS DID IT!!! thank you very much. I had been staring at this for days! I didn't know you could put the $column=>$value in the foreach. that is great!

while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
   foreach ($row as $column=>$value){
      echo $column.": ".$value."<br />";
   }
   echo '<hr />';
}

[php loop for changing mssql results]

Thank you for your response.

here is a sample of the select statement:

SELECT xml_test_table.idCred, xml_test_table.datacred, dbo.assoc_files.associated_file
FROM py_testing.dbo.xml_test_table 
INNER JOIN py_testing.dbo.assoc_files
ON py_testing.dbo.xml_test_table.full_xml_path=py_testing.dbo.assoc_files.full_xml_path 
WHERE idCred LIKE '%james%' OR datacred LIKE '%james%' 

This is a statement built with variables so the part that reads xml_test_table.idCred, xml_test_table.datacred, dbo.assoc_files.associated_file is built from user inputed check boxes and the part that says

idCred LIKE '%james%' OR datacred LIKE '%james%' is built from the user input as well as the user text input for a search term

Then end resulting $stmt is as follows:

$tsql = "SELECT $slctTerm 
        FROM py_testing.dbo.xml_test_table 
	INNER JOIN py_testing.dbo.assoc_files
	ON py_testing.dbo.xml_test_table.full_xml_path=py_testing.dbo.assoc_files.full_xml_path
	WHERE $likeTerm";

the $slctTerm and the $likeTerm are built on the fly.

is this what you were looking for?

[mysql php problem reading sent messages]

this may be wrong path but do you have your to_id and from_id columns set to int? if you do, you don't need quotes around the number in the insert statement.

[SQL query - HELP!]

could you put all the items in an array and then put that in the user_items table in one column? assuming that the user is selecting items from a list...?

$items = $_POST['checked_items_checkboxes'];

[php loop for changing mssql results]

Hello, i am running the following:
MS Server 2008 R2, SQL Express 2012, IIS 7, PHP 5

I have a user input form that allows users to select what fields in the database that they would like to search with a supplied search term, (supplied by them).

This is working well. My problem is that since the sqlsrv_fetch_array() statement can return a varrying number of items I am having a hard time looping through each row returned and showing all the selected results. Let me explain more.
Example table looks like this:
ID | FIRSTNAME | LASTNAME | AGE | CITY | MAIDENNAME | STATE | AUTOMOBILE
---------------------------------------------------------------------------------------------------
1 | BILLY | FRANKLIN | 37 | RIO | CONNER | WISCONSON | GEO METRO
2 | ******** ******* ** *** ****** *************** ***********

A user can select check boxes for any of the columns that they wish to search, so the search results could return any combination of the column names above.
So a user may enter search term Sam and select FIRSTNAME and MAIDENNAME to search
so my code to loop through this data would be:

 

while($row = sqlsrv_fetch_array($stmt) {
echo($row['FIRSTNAME'] . " - " . $row['MAIDENNAME'] . "<hr />");
}

This works fine and dandy until a user decides to search AGE and CITY and FIRSTNAME: 
now my echo statement will need to reflect that it is $row['AGE'], $row['CITY'], and $row['FIRSTNAME'].

How do write that echo statement to reflect the ever changing selection of the user for what columns or fields they want to search?

Thanks in advance,
dogdaynoon

 

 

here are a couple of examples of what i have tried...
 

while($row = sqlsrv_fetch_array($stmt)) {
             $rslt = "";
            for($i=0; $i>=count($row);$i++){
               $rslt .= $row[$i] . " "; 
               $i++
             }
           echo($rslt);
         }

I am sad to say that i don't have a very logistical thought process so i am all about trial and error.

 

$i = 0;
$rslt = "";
while($row = sqlsrv_fetch_array($stmt)){
      while($i<count($row)){
         $rslt = $rlst . " " . $row[$i] . " ";
         $i++;
         if($i>=count($row)){
            $rslt .= "<hr />";
            echo($rslt);
            $i++;
            break;
          }
      }
}