mysql - PHP store, retrieve and edit an array from database -

-

i have problem arrays, i'm not new in php have little experience manipulating complex arrays 1 need now.

i'm building shopping cart , idea of cart database row every user have , shopping process should go this

when user buys product if product doesn't exist in cart script should add product cart e.g. 1=1 or in array words $cart = [ [1]=>'1' ] means product id1 quantity 1, if product exist in cart script should update quantity e.g. 1=2 , on higher quantity.

this poor attempt accomplish aforementioned

php

<?php session_start();  require_once('config.php');  $member_id = '1'; // test data $pr_id     = filter_input(input_post, 'pr_id', filter_sanitize_string); // sending id jquery/ajax works fine of course $pr_qty    = '1'; // start quantity $up_qty    = '5'; // test data  try {   $getcart = $conn->prepare("select cart members member_id = :member_id ");   $getcart->bindparam(':member_id', $member_id);   $getcart->execute();   $cart    = $getcart->fetch(pdo::fetch_assoc);    if(array_key_exists($pr_id, $cart)) {      $cart[$pr_id] = $up_qty . ',';   }   else {      $cart[$pr_id] = $pr_qty . ',';   }    $updatecart = $conn->prepare("update members set cart = :cart member_id = :member_id ");   $updatecart->bindparam(':member_id', $member_id);   $updatecart->bindparam(':cart', implode($cart));    if($updatecart->execute()) {      echo '1';   }  } catch(pdoexception $error) {       echo 'error: ' . $error->getmessage(); }  $conn = null; ?>

later on should able retrieve product id's , quantities database when time comes...

i'm working 3 days on , i'm hopeless, searched everywhere, find many tutorials on multidimensional arrays think problem little unique or i'm stupid enough , can't solve it.

thanks in advance, hope we'll solve together, more brains = more knowledge = solution ;)

the implode function use not work cart, because array indices lost, lose product ids. can serialize or json_encode shopping cart array.

$_session['cart'] = array(     1 => 1,     6581 => 4 );  $json = json_encode($_session['cart']);

then can store $json string member table. when want fetch database later, have json_decode , put function result in $_session['cart'] again.

$_session['cart'] = json_decode($json, true);

as see, have put $cart variable $_session. not need retrieve again database when user navigates on site. reduce load on database speed script. shopping website important website load fast possible, customers enjoy shopping , staying on site.

to add new product or increase quantity of existing position this:

function addproduct($id) {     if (isset($_session['cart'][$id]))         $_session['cart'][$id]++;     else         $_session['cart'][$id] = 1; }

after calling addproduct should json_encode , update database make cart persistent.


Comments

Post a Comment

Popular posts from this blog

database - VFP Grid + SQL server 2008 - grid not showing correctly -

-
i having problem, have grid called "gridbasica" , this: thisform.gridbase.recordsource = "sgviemp" sgviemp cursor made executing select sqlserver command sqlexec. when want modify registry, go form , the update there. so, when come form grid, grid isnt grid anymore, big white rectangle. reading around said: delete recordsource , asingt again. thisform.gridbase.recordsource = "" *--i sqlexe here thisform.gridbase.recordsource = "sgviemp" i , works, but, when click button modify again cursos updated modify form doesnt load fields did first time. could me out that? thanks in advance. --------------- edit ------------------ i have been doing recommended: lnselect = select(0) n = sqlexec(thisform.conexion,"select emp_ccodigo codigo, emp_cnombre 'nombre o razon social', emp_cnumrif 'r.i.f' sgviempr","sgviemp1") set echo on suspend select sgviemp zap in sgviemp *-- browse *--zaps correct
Read more

jquery - Set jPicker field to empty value -

-
im using jpicker color selector in form. have clear value set window/icon 'no color selected' state. i've tried following: $(':input[name="color"]').val(''); //access value directly. (does not affect jpicker) 2: $.jpicker.list[0].color.active.val('hex', '', this); //set color black , input value 000000, instead of empty string 3: $.jpicker.list[0].color.active.val(null, '', this); //does nothing none of 3 methods seems behave properly. in advance. this works me :) $.jpicker.list[0].color.active.val('v', null); here example: http://jsfiddle.net/3up7n/
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r
Read more