php - copy content of text file and inserting into database table where a given column is equal to the title of te text file -


i have folder text files. text files created when user submit form data , named based on user input of particular column, use these file contents update 1 table in database using clause 2 conditions, first email of user correspond email column in table, , second file title correspond title column in table. each row, have the content of file it's title correspond saved in seen column.

i'm using below code it's not working

$size = "";  $dir = "counters/ads";  if ($handle = opendir($dir)) { while (false !== ($file = readdir($handle))) {     if($file == '.' || $file == '..') continue;      $myfile = "$dir/$file";     $fh = fopen($myfile, 'r');      $size = filesize($myfile);     if ($size > 0) {     $content = fread($fh, $size);      $name = $file;      }     $target = $row2['target'];     $progress = ($content/$target)*100;     // check connection          $result3=mysqli_query($db_handle,"update advert set seen='$content', progress='$progress', counter='$name' email='".$email."' && title='".$title."'");       fclose($fh); } closedir($handle); }

however when removed title condition, query update table inserting $name counter column, it's not updating $content seen column

please idea on how can go it

the problem code semi-colon before where clause:

counter='$name';

it terminates process. need remove it.

since semi-colon valid character in php, not have thrown error it.

it's what's called "end of statement" character.

reference:

as in c or perl, php requires instructions terminated semicolon @ end of each statement. closing tag of block of php code automatically implies semicolon; not need have semicolon terminating last line of php block. closing tag block include trailing newline if 1 present."

it's best check errors using php's error reporting , mysqli_error() on query, in case.

references:


Comments

Post a Comment

Popular posts from this blog

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more