erok

August 11, 2015

There is a little javascript. But unrelated, different part of the code. just to say good evening etc.

Page suppose to retrieve information related to user. If, in previous visit user checked e.g. trans or short or long. That information suppose to appear at user personal page when he/she logged in. If user needs to make changes, he/she should be able make changes and keep the other informations unchanged as previous visit.

Problem as i said before, CHROME and OPERA

unable to retrive data from phpmyadmin. Actually when i use var_dump i see the variable values in there,

Chrome unable hold onto it. Chrome unable to process it.

INTERNET EXPLORER and FIREFOX able to.

August 11, 2015

Hi.

I tested with

FIREFOX it is working fine

- able to insert, update, delete checkbox values.

same code with

OPERA

unable to retrieve checkbox values

able to upload and update checkbox values.

regards

August 11, 2015

Thanks for reply

i just did it

i see this

<input type="checkbox" name="len[]" size="9" maxlength="20" value="10" checked /> // checked attribute is actually being applied with chrome

August 11, 2015

Hi all,

i have php code working with INTERNET EXPLORER fine

- able to insert, update, delete checkbox values.

brief sections of code ;

$bea=$dow['bea'];

$dow1 = explode(",", $dow['len']);

if(in_array(5,$dow1)) $che5="checked";

else $che5="";

if(in_array(10,$dow1)) $che10="checked";

else $che10="";

..

same code with GOOGLE CHROME

unable to retrieve checkbox values

able to upload checkbox values.

I tried ...$che5="checked=checked";

$che5="checked='checked'";

$che5='checked' ;

not helping.

Anybody who has experience wih this kind of problem?

directing , pointing kindly appreciated

erok

March 30, 2015

UPDATE:<input type="checkbox" name="up[]" value="<?php echo $nid=$row['id'] ; ?>" checked />

Now it is working.

Thanks for your support

March 28, 2015

I got the following message with phpinfo() function

when i tried to update second image. its picture id=2 in database

Apache Environment

REQUEST_METHOD POST

QUERY_STRING no value

REQUEST_URI /dakgooduy.php

SCRIPT_NAME /dakgooduy.php

HTTP Headers Information

HTTP Request Headers

HTTP Request POST /dakgooduy.php HTTP/1.1

Accept text/html, application/xhtml+xml, */*

Referer http://localhost/dakgooduyar.php

PHP Variables

Variable

Value

_REQUEST["title"] NEW HOPE 501

_REQUEST["country"] USA

.

_REQUEST["MAX_FILE_SIZE"] 2000000

_REQUEST["caption"] Array

(

[0] => asli 328 211

[1] => bill 328 502

)

_REQUEST["up"] Array

(

[0] => 2

)

_REQUEST["kitchen"] update

_POST["title"] NEW HOPE 501

.

_POST["MAX_FILE_SIZE"] 2000000

_POST["caption"] Array

(

[0] => asli 328 211

[1] => bill 328 502

)

_POST["up"] Array

(

[0] => 2

)

_POST["kitchen"] update

_FILES["image"] Array

(

[name] => Array

(

[0] =>

[1] => _70132432_vikingship.jpg

)

[type] => Array

(

[0] =>

[1] => image/jpeg

)

[tmp_name] => Array

(

[0] =>

[1] => C:xampptmpphp5153.tmp

)

[error] => Array

(

[0] => 4

[1] => 0

)

=> Array

(

[0] => 0

[1] => 59725

)

March 27, 2015

sorry i made it looks like a little bit ambiguous.

following code is part of the for loop on the first post

// use checkbox value="$nid" to transfer image id to to upload file.

UPDATE:<input type="checkbox" name="up[]" value="<?php echo $nid=$row['id'] ; ?>" />

I can updates two images no problem i got following message with var_dump function

string(1) "9" string(2) "10"

when i tried second image only i got following messege

Notice: Undefined offset: 1 in C:xampphtdocsdakgooduy.php on line 166

NULL

March 27, 2015

" So then $_POST['up'] will be an array of checkbox values that were selected. You should start by looping through $_POST['up'] to get each ID value and process the uploaded file from there. "

if i want to update two pictures i update both of the pictures. If i want to update first picture only i can update first picture only. I can not update second pictures only.

if you look at my first post you can see my codes i m looping through already.

March 26, 2015

Hi Ingolme

I use checkbox value="$nid" to transfer image id to to upload file.

UPDATE:<input type="checkbox" name="up[]" value="<?php echo $nid=$row['id'] ; ?>" />

so it is coming from checkbox.

March 26, 2015

Hi,

I got the following errors. Sounds like i am able to bring (image id) $nid from the form page to here. Somehow this page does not recognize $nid

I am trying to bring array $nid

Warning: strlen() expects parameter 1 to be string, array given in C:xampphtdocsdakgooduy.php on line 149form ok false

/* line 149 / if (!empty($_POST['up']) && isset($_POST['up']) && (strlen($_POST['up']) <= 3) && !empty($_FILES['image']) && isset($_POST['image']) || isset($_POST['caption']))

{

$formOk = true ;

.

Notice: Undefined offset: 1 in C:xampphtdocsdakgooduy.php on line 166NULL

/* line 166 / $nid=$_POST['up'][$i] ;

/* line 167 / var_dump($nid) ;

I defined $nid= array() ; earlier on the dakgooduy.php

Any comment appreciated

March 26, 2015

Hi all,

I have two separate images in phpmyadmin database; files on xampp

able to update

first image alone ,

able to update

two images in two rows.

But unable to update if i wanted to update second image alone.

.

$abc = "SELECT id, type, caption FROM dakimages WHERE pid=".$pid." ORDER BY id" or die();

$rs = mysqli_query($con, $abc) ;

$icount=mysqli_num_rows($rs) ;

for($i=0;$i<$icount;$i++) {

$row=mysqli_fetch_array($rs) ;

$type=$row['type'] ;

$nid= $row['id'] ;

$caption=$row['caption'] ;

echo $nid ;

.

I use checkbox value="$nid" to transfer image id to to upload file.

UPDATE:<input type="checkbox" name="up[]" value="<?php echo $nid=$row['id'] ; ?>" />

In upload file "dakgooduy.php"

$icount = 2 ;

for($i=0;$i<$icount;$i++) {

if (!isset($_POST['up'])) $formOk = false ;

$path = $_FILES['image']['tmp_name'][$i] ;

if (filesize($path) > 2000000 or filesize($path) < 1)

{

$formOk = false; //// something wrong here

echo " form ok false " ;

}

else {

$type = $_FILES['image']['type'][$i] ;

$caption = $_POST['caption'][$i] ;

$nid=$_POST['up'][$i] ;

What might cause this problem?

Any conceptual help greatly appreciated

February 20, 2015

Hi all.

I wish i would have better solution. For now, i put each picture to separate tables. At least it is working!

February 20, 2015

I am NOT saying i am doing the right thing. I have a problem and i am looking to solution.

" if you have 2 SQL insert queries then it will insert 2 rows, with whatever data you have in each row. " i tried this and that way inserting the second picture twice.

I also tried using array, giving error message. Do not insert any row at all.

I tried PREPARE. it insert the row but give blob 0. Means no image inserted. Somehow prepare do not insert image. Maybe it is only for the string data.

I need to insert each picture to separate rows.

Any help appreciated

February 19, 2015

" but if you have 2 SQL insert queries then it will insert 2 rows, with whatever data you have in each row. "

Does not make difference still insert the second picture to the both rows.

February 17, 2015

I am trying to upload to two separate rows

$path =$_FILES['image']['tmp_name'];

$path1=$_FILES['image1']['tmp_name]; This way they all need to go to same row.

How can upload two separate pictures to two separate rows?

February 17, 2015

for the first image; I used $path, $name, $type, $content, $caption variables and

for the second image; $path1, $name1, $type1, $content1, $caption1 variables. At least I thought that way.

I am trying to upload two pictures at separate rows, not two images in the same row.

February 17, 2015

with these codes second picture goes twice to database. I am unable to upload first picture. What am i doing wrong?

Any help appreciated

$pid = mysqli_insert_id($con) ;

if (!empty($_FILES['image']) || !empty($_POST['caption']))

{ //1

$formOk = true;

//Assign Variables

$path = $_FILES['image']['tmp_name'] ;

$name = $_FILES['image']['name'] ;

$type = $_FILES['image']['type'] ;

$caption = $_POST['caption'] ;

// check for file size.

if (filesize($path) > 2000000)

{ //4

$formOk = false;

echo "Error: File size must be less than 2000 KB.";

} //4+

if ($formOk)

{

// read file contents

$content2 = file_get_contents($path);

$content = mysqli_real_escape_string($con, $content2);

$caption = mysqli_real_escape_string($con, $caption) ;

}

if (!empty($_FILES['image']) || !empty($_POST['caption']))

{ //1

$formOk = true;

//Assign Variables

$path1 = $_FILES['image']['tmp_name'] ;

$name1 = $_FILES['image']['name'] ;

$type1 = $_FILES['image']['type'] ;

$caption1 = $_POST['caption'] ;

// check for file size.

if (filesize($path1) > 2000000)

{ //4

$formOk = false; //// something wrong here

echo "Error: File size must be less than 2000 KB.";

} //4+

if ($formOk)

{

// read file contents

$content2 = file_get_contents($path);

$content1 = mysqli_real_escape_string($con, $content2);

$caption1 = mysqli_real_escape_string($con, $caption) ;

$sql = "insert into images (pid, name, type, content, caption) values ('{$pid}', '{$name}', '{$type}', '{$content}', '{$caption}'), ('{$pid}', '{$name1}', '{$type1}', '{$content1}', '{$caption1}')";

$sql= mysqli_query($con, $sql) ;

February 9, 2015

i deleted all table and rebuilded used different name. Now it is working i can insert into table in database.

Thank for caring

February 8, 2015

Tinyint(4) for radiobuttons columns

varchar for checkboxes and text columns.

same structure i used earlier with which i can upload to phpmyadmin database table. Only difference more columns.

I have not tried to upload images yet, images gonna go to another table though.

February 8, 2015

I faced a setback when i increase number of columns from 5 to 31 combination of radios, checkboxes and text, plus some images which are going to another table under the same form. I can not upload to database tables. No error messages. Is it because limitation of xampp? is it too much for xampp to able to handle?

February 6, 2015

Ingolme, Justsomeguy.

Thanks alot guys for your great help

With string data type instead of tinyinteger implode is working fine. I am able to store multiple values into same field

February 5, 2015

"The other option is to use a string data type instead of integer and then just store a list of the values, but the problem with a design like that is that you lose SQL's ability to quickly search for records if you're storing multiple searchable values in a single field. "

I think i m willing to use a string data type instead of focusing on search speed.

February 4, 2015

My question is ;

How can i iterate into the same field different checkbox values? Implode function is good for displaying both values on the screen, but not inserting both values into same database field . Only inserting the first value in the checkbox to the field, ignores the the second or third...values.

this code is able to

if(!empty($_POST['period']))

{

$period=array() ;

$period=implode(",", $_POST['period']) ;

echo $period ;

}

echo out 100,200 on the screen when i checked both 100 and 200. But only insert value 100 to database. Values are integer not string.

and looks like this;

// insert into table

$sql = "insert into dakdeneme (title, trans, length, period) values ('{$title}', '{$trans}', '{$length}', '{$period}')" ;

$sql= mysqli_query($con, $sql) ;

I want to display that particular boat is available for 100 days or 200 days or both 100 and/or 200 days depends on boat owner's preferences.

February 4, 2015

True tinyint set. That is why excepts integer. But still " echo out ' 100,200 ' on the screen when i checked both 100 and 200. But only insert value 100 to database."

how can i iterate in to the same field? implode helps only for displaying on the screen both values but not inserting into database.

February 4, 2015

this code is able to

if(!empty($_POST['period']))

{

$period=array() ;

$period=implode(",", $_POST['period']) ;

echo $period ;

}

echo out 100,200 on the screen when i checked both 100 and 200. But only insert value 100 to database.

this code is able to insert into database phpmyadmin as value 0 or 1 whichever i check. Value "yes" or "no" unable to insert into database.

if(!empty($_POST['trans'])) {

$trans=$_POST['trans'] ;

}

echo $trans ;

Yes <input type="radio" name="trans" size="3" maxlength="3" value="1" /> instead of value="yes"

No <input type="radio" name="trans" size="3" maxlength="3" value="0" /> instead of value="no"

Sign In

erok

Posts

Joined

Last visited

Content Type

Profiles

Forums

Events

Posts posted by erok

checkbox working with internet explorer not with chrome

checkbox working with internet explorer not with chrome

checkbox working with internet explorer not with chrome

checkbox working with internet explorer not with chrome

update images

update images

update images

update images

update images

update images

update images

last field overwriting when uploading multiple images into mysqli d.b.

last field overwriting when uploading multiple images into mysqli d.b.

last field overwriting when uploading multiple images into mysqli d.b.

last field overwriting when uploading multiple images into mysqli d.b.

last field overwriting when uploading multiple images into mysqli d.b.

last field overwriting when uploading multiple images into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

insert radio and checkbox values into mysqli d.b.

Browse

Activity