PHP - adding a string to a variable (array) CSV --> MySQL -


i have problem thats baffling mind, i'm unable add string gradually loaded csv file array (through while loop) after writes database.

the code runs, echoes fact has written database, nothing happens, when remove string writes database fine.

the syntax should $variable = 'string' . $csvvalue; won't write database when case, when is: $variable = $csvvalue;

here code:

<?php // script insert data csv-file ad information in mysql database.  // connect database  $connect = mysqli_connect("localhost","root","password","dbname");   if(!$connect){    die('could not <span id="il_ad1" class="il_ad">     connect to</span> mysql: ' . mysql_error()); }  // charset mysqli_query($connect, "set names 'utf8'");  // file path define('csv_path','/home/administrator/desktop/');   $csvname = csv_path . "ansattinfo.csv"; // name of csv-file $csvfile = fopen($csvname, 'r'); $thedata = fgets($csvfile); $i = 0;  while(!feof($csvfile)){      $csv_data[] = fgets($csvfile, 2048);     $csv_array = explode(",", $csv_data[$i]);     $insert_csv = array();     $insert_csv['samaccountname'] = $csv_array[0];     $insert_csv['displayname'] = $csv_array[1];     $insert_csv['employeenumber'] = $csv_array[2];     $insert_csv['mail'] = $csv_array[3];     $insert_csv['company'] = $csv_array[4];     $footer = str_replace(' ', '_', $insert_csv['company']);     //$footer = '@' . str_replace(' ', '_', $insert_csv['company']);      $query = "insert playsms_tblusertest (status, username, enable_webservices, webservices_ip, name, mobile, email, footer, country, datetime_timezone, language_module, fwd_to_mobile, send_as_unicode)         values(             3,             ".$insert_csv['samaccountname'].",             1,             '*.*.*.*',             ".$insert_csv['displayname'].",             ".$insert_csv['employeenumber'].",             ".$insert_csv['mail'].",             ".$footer.",             137,             '+0100',             'nb_no',             1,             1              ) on duplicate key         update name = $insert_csv[displayname], mobile = $insert_csv[employeenumber], email = $insert_csv[mail], footer = $footer";     mysqli_query($connect, $query);     $i++; }  fclose($csvfile);  echo "csv imported user-table! \n";  mysqli_close($connect); // closing connection   ?>

what want here add string infront of $footer value, @ groupname of contact group, '@' indicator of being group.

in csv file company name not have '@' infront of it, want add. this:

$footer = '@' . str_replace(' ', '_', $insert_csv['company']);

this not give syntax errors, nothing gets written database.

does have suggestion on solution here?

cheers help.

if field footer in database of "string-type", have fill string:

/* ... */             ".$insert_csv['employeenumber'].",             ".$insert_csv['mail'].",             '".$footer."',             137,             '+0100',             'nb_no',             1,             1              ) on duplicate key         update name = $insert_csv[displayname], mobile = $insert_csv[employeenumber], email = $insert_csv[mail], footer = '$footer'"; /* ... */

and declare string in mysql-query have put in between quotes shown above $footer value.

i think got same error multiple times in query: example $insert_csv['mail'] string too, guess.

hint: if used kind of error-handling, have seen there mysql-error (since using pdo don't know how works in mysqli).


Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more