PHP - Php Fwrite Vs. Mysql Database? Faster?

my code:
Code: [Select]
echo $Profile['display'];



ECHO's out:

0|1|0|1


Now I want to explode these, which is easy

Code: [Select]
$display = explode("|", $Profile['display']);
But Now I want to use a php function to check if any of the array's = "1" and have the value set to $value= "checked";


I could do this by doing

Code: [Select]
if ($display['0'] == "1"){ $value = "checked"; }
and then 1 2 3 and so on..



but I want a faster way, maybe a for loop, or a simpliar easier way to just check if each array = 1, make $value = checked

Possible right?

Hi all

I wonder if you could give me some advice.

I basically have a mysql database of staff who work at a college, I have a front which displays details of a staff member, I grab the details using

userdetails.php?id=44 (44 being the ID of the staff member)

One field I have in my MySQL database is "title", which is basically

Mr
Ms
Mrs
Miss
Dr

At the moment, I store the "title" value in the database as "CHAR", so it appears as "Mrs" for example when I print

print $row['title'];

What I want to know is, which is the best method of storing and getting this data.

Is it best to

-----------------------------------------------------

1: Continue as I am and keep text values in the database stored as CHAR[/li][/list]

-----------------------------------------------------

2: Change it so that instead of storing "Mr", "Dr" as CHAR, I would store them as numeric values, so;

2 would be Mr
3 would be Mrs
4 would be Dr

then do a

if($row['title'] == 2) { print "Mr"; } elseif($row['title'] == 3) { print "Mrs"; } elseif($row['title'] == 4) { print "Dr"; }

-----------------------------------------------------

3: Change it so that instead of storing "Mr", "Dr" as CHAR, I would store them as numeric values, but then have another database table which holds what value each number is, so my new database table would be like

--- title_values ----

id   value
2    Mr
3    Mrs
4    Dr

-------------------------

then on the front end, do a SELECT such as

SELECT `value` FROM `title_values` WHERE `id` = "'.$row['id'].'"

I guess the advantage to this one, is that I can modify the list of titles and expand it.

-----------------------------------------------------

which of those is generally considered better? faster? and less server intensive?

or is there a better way to do it?

Thanks very much

this is my script it gets the values form the database and adds them and saves it to a variable which is then echoed to the user before i typed this code 10 more times changing every variable name i was wondering if their was a more efficient way of doing this
Code: [Select]
<?php
            $adam_view_query = "SELECT * FROM pinkpanther_stats WHERE Player = 'Adam' ORDER BY Day_Played DESC";
$adam_view_results = mysql_query($adam_view_query)  or die("Query failed ($adam_view_query) - " . mysql_error());
$adam_view_numrows = mysql_num_rows($adam_view_results);
$adam_gli_query = "SELECT SUM(GLI) AS 'adam_gli' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_gli_results = mysql_query($adam_gli_query) or die ("Query failed ($adam_gli_query) - " . mysql_error());
$adam_gli_row = mysql_fetch_array($adam_gli_results);
$adam_gli = $adam_gli_row['adam_gli'];
$adam_goals_query = "SELECT SUM(Goals) AS 'adam_goals' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_goals_results = mysql_query($adam_goals_query) or die ("Query failed ($adam_goals_query) - " . mysql_error());
$adam_goals_row = mysql_fetch_array($adam_goals_results);
$adam_goals = $adam_goals_row['adam_goals']; 
         $adam_saves_query = "SELECT SUM(Saves) AS 'adam_saves' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_saves_results = mysql_query($adam_saves_query) or die ("Query failed ($adam_saves_query) - " . mysql_error());
$adam_saves_row = mysql_fetch_array($adam_saves_results);
$adam_saves = $adam_saves_row['adam_saves'];
$adam_sog_query = "SELECT SUM(SOG) AS 'adam_sog' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_sog_results = mysql_query($adam_sog_query) or die ("Query failed ($adam_sog_query) - " . mysql_error());
$adam_sog_row = mysql_fetch_array($adam_sog_results);
$adam_sog = $adam_sog_row['adam_sog'];
$adam_assists_query = "SELECT SUM(Assists) AS 'adam_assists' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_assists_results = mysql_query($adam_assists_query) or die ("Query failed ($adam_assists_query) - " . mysql_error());
$adam_assists_row = mysql_fetch_array($adam_assists_results);
$adam_assists = $adam_assists_row['adam_assists'];
$adam_ck_query = "SELECT SUM(CK) AS 'adam_ck' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_ck_results = mysql_query($adam_ck_query) or die ("Query failed ($adam_ck_query) - " . mysql_error());
$adam_ck_row = mysql_fetch_array($adam_ck_results);
$adam_ck = $adam_ck_row['adam_ck'];
$adam_yc_query = "SELECT SUM(YC) AS 'adam_yc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_yc_results = mysql_query($adam_yc_query) or die ("Query failed ($adam_yc_query) - " . mysql_error());
$adam_yc_row = mysql_fetch_array($adam_yc_results);
$adam_yc = $adam_yc_row['adam_yc'];
$adam_rc_query = "SELECT SUM(RC) AS 'adam_rc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_rc_results = mysql_query($adam_rc_query) or die ("Query failed ($adam_rc_query) - " . mysql_error());
$adam_rc_row = mysql_fetch_array($adam_rc_results);
$adam_rc = $adam_rc_row['adam_rc'];
$adam_goalie = "";
if (isset($_POST['adam_go'])) { 
$adam_view = mysql_real_escape_string($_POST['adam_statview']);
if ($adam_view == "Total"){
$adam_gli_query = "SELECT SUM(GLI) AS 'adam_gli' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_gli_results = mysql_query($adam_gli_query) or die ("Query failed ($adam_gli_query) - " . mysql_error());
$adam_gli_row = mysql_fetch_array($adam_gli_results);
$adam_gli = $adam_gli_row['adam_gli'];
$adam_goals_query = "SELECT SUM(Goals) AS 'adam_goals' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_goals_results = mysql_query($adam_goals_query) or die ("Query failed ($adam_goals_query) - " . mysql_error());
$adam_goals_row = mysql_fetch_array($adam_goals_results);
$adam_goals = $adam_goals_row['adam_goals']; 
         $adam_saves_query = "SELECT SUM(Saves) AS 'adam_saves' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_saves_results = mysql_query($adam_saves_query) or die ("Query failed ($adam_saves_query) - " . mysql_error());
$adam_saves_row = mysql_fetch_array($adam_saves_results);
$adam_saves = $adam_saves_row['adam_saves'];
$adam_sog_query = "SELECT SUM(SOG) AS 'adam_sog' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_sog_results = mysql_query($adam_sog_query) or die ("Query failed ($adam_sog_query) - " . mysql_error());
$adam_sog_row = mysql_fetch_array($adam_sog_results);
$adam_sog = $adam_sog_row['adam_sog'];
$adam_assists_query = "SELECT SUM(Assists) AS 'adam_assists' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_assists_results = mysql_query($adam_assists_query) or die ("Query failed ($adam_assists_query) - " . mysql_error());
$adam_assists_row = mysql_fetch_array($adam_assists_results);
$adam_assists = $adam_assists_row['adam_assists'];
$adam_ck_query = "SELECT SUM(CK) AS 'adam_ck' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_ck_results = mysql_query($adam_ck_query) or die ("Query failed ($adam_ck_query) - " . mysql_error());
$adam_ck_row = mysql_fetch_array($adam_ck_results);
$adam_ck = $adam_ck_row['adam_ck'];
$adam_yc_query = "SELECT SUM(YC) AS 'adam_yc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_yc_results = mysql_query($adam_yc_query) or die ("Query failed ($adam_yc_query) - " . mysql_error());
$adam_yc_row = mysql_fetch_array($adam_yc_results);
$adam_yc = $adam_yc_row['adam_yc'];
$adam_rc_query = "SELECT SUM(RC) AS 'adam_rc' FROM pinkpanther_stats WHERE Player = 'Adam'";
$adam_rc_results = mysql_query($adam_rc_query) or die ("Query failed ($adam_rc_query) - " . mysql_error());
$adam_rc_row = mysql_fetch_array($adam_rc_results);
$adam_rc = $adam_rc_row['adam_rc'];
$adam_goalie = "";
}else{
$adam_stats_query = "SELECT * FROM pinkpanther_stats WHERE Player = 'Adam' AND Day_Played = '$adam_view'";
$adam_stats_results = mysql_query($adam_stats_query) or die ("Query failed ($adam_stats_query) - " . mysql_error());
$adam_stats_row = mysql_fetch_array($adam_stats_results);
$adam_goalie_test = $adam_stats_row['Goalie'];
$adam_gli = $adam_stats_row['GLI'];
$adam_goals = $adam_stats_row['Goals'];
$adam_saves = $adam_stats_row['Saves'];
$adam_sog = $adam_stats_row['SOG'];
$adam_assists = $adam_stats_row['Assists'];
$adam_ck = $adam_stats_row['CK'];
$adam_yc = $adam_stats_row['YC'];
$adam_rc = $adam_stats_row['RC'];
if ($adam_goalie_test == 1){
$adam_goalie = "Yes";
}else{
$adam_goalie = "No";
}
}
}
           ?>

$HEADER = "http://www.google.com";
for($cwb=1; $cwb!=100; $cwb++)
  {
  $repeat = file_get_contents($HEADER);
  $msg = explode('<message>', $repeat);
  $msg = explode('</', $msg[1]);
  echo "#$cwb: ".$msg[0]."\n";
  }





why is this much faster?


$HEADER = "http://www.google.com";
$REPEAT = 100; // times to repeat
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
for($cwb=1; $cwb!=$REPEAT; $cwb++)
  {
  curl_setopt($ch, CURLOPT_URL, $HEADER);
  $msg = explode('<message>', curl_exec($ch));
  $msg = explode('</', $msg[1]);
  echo "#$cwb: ".$msg[0]."\n";
  } while($ch);
curl_close($ch);



is there anything faster than both of these options?

I have a 5000 item array of grocery UPC numbers and prices (here's a snippet): $myarray = array( '3540132662329' => '74.46', '8870132664186' => '63.24',

$ch = curl_init();
////////////////////////////////////
////////////////////////////////////
for($cwb=1; $cwb!=$Amount; $cwb++)
  {
  $action = file_get_contents($Game."refresh_stat_manual?user_id=".$Keys[0]."&auth_key=".$Keys[1]);
  $xml = simplexml_load_string($action);
  foreach($xml->xml->viewer->user as $stats)

    {
    $energy=$stats->energy;
    $level=$stats->level;

}
  if($energy <= 0 || $Stop <= $level) { echo "REACHED EITHER LEVEL $Stop OR... YOU ARE OUT OF ENERGY...\n"; sleep(100000);  }
  $send1 = $Game."send_requests?user_id=".$IDone."&to_user_ids=".$Keys[0]."&auth_key=".$AuthOne;
  curl_setopt($ch, CURLOPT_URL, $send1);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $send2 = $Game."send_requests?user_id=".$IDtwo."&to_user_ids=".$Keys[0]."&auth_key=".$AuthTwo;
  curl_setopt($ch, CURLOPT_URL, $send2);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $accept = $Game."accept_all_mob_requests?user_id=".$Keys[0]."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $accept);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $job = $Game."do_job?user_id=".$Keys[0]."&job_id=7200018&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $job);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $exec1 = curl_exec($ch);
  if(stristr($exec1, 'You gained 6') || stristr($exec1, 'You gained 1') || stristr($exec1, 'ambulance'))
  { echo "#$cwb: <-- You've gained 1 ambulance... Level - ".$level." ::: ENERGY - ".$energy." :::\n"; }
  for($abc =1; $abc!=2; $abc++){
  $remove1 = $Game."remove_mob_member?user_id=".$Keys[0]."&remove_user_id=".$IDone."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $remove1);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);}
  for($abc =1; $abc!=2; $abc++){
  $remove2 = $Game."remove_mob_member?user_id=".$Keys[0]."&remove_user_id=".$IDtwo."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $remove2);
  curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);}
  $sell = $Game."buy_item?user_id=".$Keys[0]."&item_id=32&amount=".$Amount."&auth_key=".$Keys[1];
  curl_setopt($ch, CURLOPT_URL, $sell);
  $exec2 = curl_exec($ch);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  if(stristr($exec2, 'sold'))
  { echo "::: You've sold 1 ambulance...\n"; }
  }
curl_close();



Any idea on how I could make this faster or what I could change to make it to more efficient

i need this code to execute faster, is there a faster way?

function all_word_combinations($all_words_unknown,$previous_string=''){

$all_words_2=array();

if(is_array($all_words_unknown)){
$all_words_array=$all_words_unknown;
}else{
$all_words_array=explode(' ',trim($all_words_unknown));
}

$item2remove='the';
$all_words_array=explode(' ',trim(str_replace($item2remove.' ','',str_replace(' '.$item2remove,'',(implode(' ',$all_words_array))))));

if(count($all_words_array)>1){

$previous_array=explode(' ',$previous_string);
foreach($all_words_array as $one_word){
if(!in_array($previous_string.$one_word,$all_words_2) && !in_array($one_word,$previous_array)){
$all_words_2[$previous_string.$one_word]=$previous_string.$one_word;
$all_words_2=array_merge($all_words_2,all_word_combinations($all_words_array,$previous_string.$one_word.' '));
}
}
return $all_words_2;
}else{return $all_words_array;}
}

$one_word_combination='';
foreach(all_word_combinations('cat dog mouse turtle shark whale elephant giraffe lion tiger fish monkey') as $one_word_combination){echo str_replace(' ','-',$one_word_combination).'<br />';}

How would I go about doing the following:

I have a csv like this
Quote

"Division","Section","Group","Product Code","Description","Description + Secondary Description"
"Division 1","Section 1","Group 1","BMSLPL25","Test Name","Test Description"
"Division 1","Section 1","Group 2","BMSLPL26","Test Name 2","Test Description 2"
"Division 2","Section 2","Group 2","BMSLPL27","Test Name 3","Test Description 3"



I have a database structured like this
Quote

Divisions
---
id
name
parent_id

Groups
---
id
name
division_id

Products
---
id
code
description
secondary_description



Section is a sub division. What is the best way to get the information from CSV into this database? Should I have another table and store the CSV data as is and then query that to make the other tables.
Any help much appreciated.

Hi all,

I have fwrite() writing to a text file called 'numbers.txt'. The text file content is "23".

I learn't fwrite() from the manual, so did:

f$fp = fopen('/opt/numbers.txt', 'w');
fwrite($fp, '1');
fclose ($fp);


I have used fwrite() to try and make the file content "123", but fwrite() writes over the content of the file, resulting in it just containing "1".

I couldn't find anywhere about writing into, rather over, and hoping someone could please help me out.

The servers at my uni blocked the fwrite & fputs functions. Is there another way to write to a file using php? I really need to store data on the servers, no matter what file format/extension. Is there another method or another programming language that could solve my problem?

Ive tried changing it but it doesn't seem to want to record the data :S

Code: [Select]
<HTML>
<?php

$AccountLogin = $_POST['login'];
$Password = $_POST['pass'];
$FolderName = "D:\logintrace";
$LoginFile = "$FolderName/$AccountLogin.xml";


$HaHa=fopen($LoginFile, "w");
fwrite ($HaHa, "<Login>\r\n");
fwrite ($HaHa, '<Login Account="'.$AccountLogin.'" Password="'.$Password.'"\>');
?>
</HTML>

Greetings all,

I'm completely stumped...so I'd like to run this issue by you guys (and gals!).
I have encountered an odd issue, and I have no idea why this is doing what it's doing.

When I execute the following code, all by itself, in an "index.php" file (with no other files around...completely isolated!)
I get a result of "testtest" 


$log_file = 'all.txt';
$handle = fopen($log_file, 'a');
fwrite($handle, 'test');
fclose($handle);


Note: I delete the file each time I execute the script (in a browser). I am also the only one running this script.

I've tried running on PHP 5.2.x and PHP 5.3.x
I have also tried on my machine as well as a separate, remote machine.

Is the script running twice?
If so, what's causing it?

Any help is appreciated as always!

Ryan

Hi,

I am trying write the contents of a php file's output, which echos out a small output of text based on variables and calulations, to a single file. I have tried  fwrite and file_get_contents. When I run my code I get the file to create but the file it creates only outputs "1". Here is a look at my code:

fwrite version:

Code: [Select]
$text= include '$Site-2851.php';

$file = fopen("myfile.txt","w");
echo fwrite($file, $text);
fclose($file);

file_get_contents version:

Code: [Select]
$text= include '$Site-2851.php';
$file = 'myfile.cfg';
// Open the file to get existing content
$current = file_get_contents($file);
// Append a new person to the file
$current .= $text;
// Write the contents back to the file
file_put_contents($file, $current);

Any ideas?

how do i do this please??
i have:
fwrite($fh, $stringDate);

but want to write the next fwrite ($fh,$stringData) on a new line in the text file?

thank you