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

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
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

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more