www.webdeveloper.com
Results 1 to 8 of 8

Thread: quantity in shopping cart !! Litle help

  1. #1
    Join Date
    Feb 2014
    Posts
    11

    quantity in shopping cart !! Litle help

    i bild litle webpage and seling some staffs there but in my shopingcart when visiter enter some big number shoping cart calculate price for it even there is no that much products in DB ... so i need just a litle part of code that will "take a look in DB in fild lager" and if there is no that much what visitor enter to get message that there is no that much products right now ! here is code of shoping cart

    PHP Code:
    <?php 
        
    include("includes/db.php"); 
        include(
    "includes/functionss.php"); 
        include(
    "languages/frontend.ch.php"); 
            
    //$db = $_SESSION['database']; 
        
    if($_REQUEST['command']=='delete' && $_REQUEST['pid']>0){ 
            
    remove_product($_REQUEST['pid']); 
        } 
        else if(
    $_REQUEST['command']=='clear'){ 
            unset(
    $_SESSION['cart']); 
        } 
        else if(
    $_REQUEST['command']=='update'){ 
            
    $max=count($_SESSION['cart']); 
            for(
    $i=0;$i<$max;$i++){ 
                
    $pid=$_SESSION['cart'][$i]['productid']; 
                
    $q=intval($_REQUEST['product'.$pid]); 
                if(
    $q>&& $q<=500){ 
                    
    $_SESSION['cart'][$i]['qty']=$q
                } 
                else{ 
                    
    $msg='Some proudcts not updated!, quantity must be a number between 1 and 999'
                } 
            } 
        } 

    ?>
    this is functions .... i add a function to get how much products are in DB but i dont know how to inplement it on shoping cart

    PHP Code:
    <?php 
        
    function get_product_name($pid){ 
            
    $result=mysql_query("select Art from druckfederi where artnr=$pid") or die("select Art from druckfederi where artnr=$pid"."<br/><br/>".mysql_error()); 
            
    $row=mysql_fetch_array($result); 
            return 
    $row['Art']; 
        } 
        function 
    get_price($pid){ 
            
    $result=mysql_query("select cena from druckfederi where artnr=$pid") or die("select art from products where artnr=$pid"."<br/><br/>".mysql_error()); 
            
    $row=mysql_fetch_array($result); 
            return 
    $row['cena']; 
        } 
        function 
    get_stanje($pid){ 
            
    $result=mysql_query("select stanje from druckfederi where artnr=$pid") or die("select art from products where artnr=$pid"."<br/><br/>".mysql_error()); 
            
    $row=mysql_fetch_array($result); 
            return 
    $row['stanje']; 
        } 
        function 
    remove_product($pid){ 
            
    $pid=intval($pid); 
            
    $max=count($_SESSION['cart']); 
            for(
    $i=0;$i<$max;$i++){ 
                if(
    $pid==$_SESSION['cart'][$i]['productid']){ 
                    unset(
    $_SESSION['cart'][$i]); 
                    break; 
                } 
            } 
            
    $_SESSION['cart']=array_values($_SESSION['cart']); 
        } 
        function 
    get_order_total(){ 
            
    $max=count($_SESSION['cart']); 
            
    $sum=0
            for(
    $i=0;$i<$max;$i++){ 
                
    $pid=$_SESSION['cart'][$i]['productid']; 
                
    $q=$_SESSION['cart'][$i]['qty']; 
                
    $price=get_price($pid); 
                
    $sum+=$price*$q
            } 
            return 
    $sum
        } 
        function 
    addtocart($pid,$q){ 
            if(
    $pid<or $q<1) return; 
             
            if(
    is_array($_SESSION['cart'])){ 
                if(
    product_exists($pid)) return; 
                
    $max=count($_SESSION['cart']); 
                
    $_SESSION['cart'][$max]['productid']=$pid
                
    $_SESSION['cart'][$max]['qty']=$q
            } 
            else{ 
                
    $_SESSION['cart']=array(); 
                
    $_SESSION['cart'][0]['productid']=$pid
                
    $_SESSION['cart'][0]['qty']=$q
            } 
        } 
        function 
    product_exists($pid){ 
            
    $pid=intval($pid); 
            
    $max=count($_SESSION['cart']); 
            
    $flag=0
            for(
    $i=0;$i<$max;$i++){ 
                if(
    $pid==$_SESSION['cart'][$i]['productid']){ 
                    
    $flag=1
                    break; 
                } 
            } 
            return 
    $flag
        } 

    ?>
    I REALY need this so if there is enyone that can help me that will be nice , i hope there is someone that understand what i wanted to say , sorry for my bad ENG

  2. #2
    Join Date
    Feb 2014
    Posts
    11
    Quote Originally Posted by somazvanica View Post
    i bild litle webpage and seling some staffs there but in my shopingcart when visiter enter some big number shoping cart calculate price for it even there is no that much products in DB ... so i need just a litle part of code that will "take a look in DB in fild lager" and if there is no that much what visitor enter to get message that there is no that much products right now ! here is code of shoping cart

    PHP Code:
    <?php 
        
    include("includes/db.php"); 
        include(
    "includes/functionss.php"); 
        include(
    "languages/frontend.ch.php"); 
            
    //$db = $_SESSION['database']; 
        
    if($_REQUEST['command']=='delete' && $_REQUEST['pid']>0){ 
            
    remove_product($_REQUEST['pid']); 
        } 
        else if(
    $_REQUEST['command']=='clear'){ 
            unset(
    $_SESSION['cart']); 
        } 
        else if(
    $_REQUEST['command']=='update'){ 
            
    $max=count($_SESSION['cart']); 
            for(
    $i=0;$i<$max;$i++){ 
                
    $pid=$_SESSION['cart'][$i]['productid']; 
                
    $q=intval($_REQUEST['product'.$pid]); 
                if(
    $q>&& $q<=500){ 
                    
    $_SESSION['cart'][$i]['qty']=$q
                } 
                else{ 
                    
    $msg='Some proudcts not updated!, quantity must be a number between 1 and 999'
                } 
            } 
        } 

    ?>
    this is functions .... i add a function to get how much products are in DB but i dont know how to inplement it on shoping cart

    PHP Code:
    <?php 
        
    function get_product_name($pid){ 
            
    $result=mysql_query("select Art from druckfederi where artnr=$pid") or die("select Art from druckfederi where artnr=$pid"."<br/><br/>".mysql_error()); 
            
    $row=mysql_fetch_array($result); 
            return 
    $row['Art']; 
        } 
        function 
    get_price($pid){ 
            
    $result=mysql_query("select cena from druckfederi where artnr=$pid") or die("select art from products where artnr=$pid"."<br/><br/>".mysql_error()); 
            
    $row=mysql_fetch_array($result); 
            return 
    $row['cena']; 
        } 
        function 
    get_stanje($pid){ 
            
    $result=mysql_query("select stanje from druckfederi where artnr=$pid") or die("select art from products where artnr=$pid"."<br/><br/>".mysql_error()); 
            
    $row=mysql_fetch_array($result); 
            return 
    $row['stanje']; 
        } 
        function 
    remove_product($pid){ 
            
    $pid=intval($pid); 
            
    $max=count($_SESSION['cart']); 
            for(
    $i=0;$i<$max;$i++){ 
                if(
    $pid==$_SESSION['cart'][$i]['productid']){ 
                    unset(
    $_SESSION['cart'][$i]); 
                    break; 
                } 
            } 
            
    $_SESSION['cart']=array_values($_SESSION['cart']); 
        } 
        function 
    get_order_total(){ 
            
    $max=count($_SESSION['cart']); 
            
    $sum=0
            for(
    $i=0;$i<$max;$i++){ 
                
    $pid=$_SESSION['cart'][$i]['productid']; 
                
    $q=$_SESSION['cart'][$i]['qty']; 
                
    $price=get_price($pid); 
                
    $sum+=$price*$q
            } 
            return 
    $sum
        } 
        function 
    addtocart($pid,$q){ 
            if(
    $pid<or $q<1) return; 
             
            if(
    is_array($_SESSION['cart'])){ 
                if(
    product_exists($pid)) return; 
                
    $max=count($_SESSION['cart']); 
                
    $_SESSION['cart'][$max]['productid']=$pid
                
    $_SESSION['cart'][$max]['qty']=$q
            } 
            else{ 
                
    $_SESSION['cart']=array(); 
                
    $_SESSION['cart'][0]['productid']=$pid
                
    $_SESSION['cart'][0]['qty']=$q
            } 
        } 
        function 
    product_exists($pid){ 
            
    $pid=intval($pid); 
            
    $max=count($_SESSION['cart']); 
            
    $flag=0
            for(
    $i=0;$i<$max;$i++){ 
                if(
    $pid==$_SESSION['cart'][$i]['productid']){ 
                    
    $flag=1
                    break; 
                } 
            } 
            return 
    $flag
        } 

    ?>
    I REALY need this so if there is enyone that can help me that will be nice , i hope there is someone that understand what i wanted to say , sorry for my bad ENG
    No one here cant help? I make this with tutorials over internet but i didnt kknow that no one here dont know what is all about..
    Or just no one want to help with

  3. #3
    Join Date
    Feb 2014
    Posts
    3
    So let me get this right.

    The user has a product, say "Cup" in their basket. You are talking about when looking at the basket the users changes the quantity of "Cup"'s they have in their basket?

    What you need is to make sure that when the user chooses for instance 35 "Cup"'s that you have at least 35 "Cup"'s in stock?

    Is this what you mean?

    I'll do my best to help but you've named some functions and table columns using a language I don't understand. Perhaps if you exported your MySql table and added some comments explaining or giving a translation to English of function names etc.

  4. #4
    Join Date
    Feb 2014
    Posts
    11
    Quote Originally Posted by Josh Connerty View Post
    So let me get this right.

    The user has a product, say "Cup" in their basket. You are talking about when looking at the basket the users changes the quantity of "Cup"'s they have in their basket?

    What you need is to make sure that when the user chooses for instance 35 "Cup"'s that you have at least 35 "Cup"'s in stock?

    Is this what you mean?

    I'll do my best to help but you've named some functions and table columns using a language I don't understand. Perhaps if you exported your MySql table and added some comments explaining or giving a translation to English of function names etc.
    BIG thxan for replay. Yes you understand right ... in my SQL table i have collums something like this
    d | dE | e | price | stanje ( this means how much items i have ) | artnr ) last is artnr that is mu item ID ..
    When use click add to cart .. artnr(item id) and price go to shopingcart , under that tehre is fild where user can enter how much items hi want to bay .. hi enter for exemple 55.. and go update cart.. now script need to take a look in DB of selekted item (artnr) and alow updating for 55 items if there is that much items in 'stanje' (avable items) .. if you understand if need i will copy you all my shoping cart and function script ? I share part of shopingcart and fumction ..

  5. #5
    Join Date
    Feb 2014
    Posts
    3
    If you could provide your scripts and export your shopping cart table structures that would be of a great help.

    Also if you could try and translate what you can to help me understand how it's all set up.

  6. #6
    Join Date
    Feb 2014
    Posts
    11
    i will try to explain again there is page that look like this
    http://144.76.64.35/~urbanbas/images/Untitled.jpg

    there you can see a page that peoples visit and bay items from there , under that is shopingcart i drow and explatin what is what there

    here is a code from shopingcart script
    PHP Code:
    <?php
        
    include("includes/db.php");
        include(
    "includes/functionss.php");
        include(
    "languages/frontend.ch.php");
            
    //$db = $_SESSION['database'];
        
    if($_REQUEST['command']=='delete' && $_REQUEST['pid']>0){
            
    remove_product($_REQUEST['pid']);
        }
        else if(
    $_REQUEST['command']=='clear'){
            unset(
    $_SESSION['cart']);
        }
        else if(
    $_REQUEST['command']=='update'){
            
    $max=count($_SESSION['cart']);
            for(
    $i=0;$i<$max;$i++){
                
    $pstanje=get_stanje($pid);
                
    $pid=$_SESSION['cart'][$i]['productid'];
                
    $q=intval($_REQUEST['product'.$pid]);
                if(
    $q>&& $q<=$pstanje){
                    
    $_SESSION['cart'][$i]['qty']=$q;
                }
                else{
                    
    $msg='Some proudcts not updated!, quantity must be a number between 1 and 999';
                }
            }
        }

    ?>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Shopping Cart</title>
    <link rel="stylesheet" type="text/css" href="images/main.css">
    <script language="javascript">
        function del(pid){
            if(confirm('Do you really mean to delete this item')){
                document.form1.pid.value=pid;
                document.form1.command.value='delete';
                document.form1.submit();
            }
        }
        function clear_cart(){
            if(confirm('This will empty your shopping cart, continue?')){
                document.form1.command.value='clear';
                document.form1.submit();
            }
        }
        function update_cart(){
            if(confirm('Gewünschte Stückanzahl überschreitet unser Lagerbestand! Bei Überschreitung Formular (Link "Federn nach Kundenbedarf" anklicken) ausfüllen und senden oder per E-Mail bestellen. Danke!')){
            document.form1.command.value='update';
            document.form1.submit();
            }
        }

    </script>
    </head>
    <body>
    <form name="form1" method="post">
    <input type="hidden" name="pid" />
    <input type="hidden" name="command" />
        <div style="margin:0px auto; width:600px;" >
        <div style="padding-bottom:10px">
            <h1 align="center"><?=$jfrontend['shopingcart title']?></h1>
        <input type="button" value="<?=$jfrontend['shopingcart continue bohringe']?>" onclick="window.location='bohringe/filterpretraga.php'" />
        <input type="button" value="<?=$jfrontend['shopingcart continue druckfederi']?>" onclick="window.location='druckfederi/filterpretraga.php'" />
        <input type="button" value="<?=$jfrontend['shopingcart continue konishfedern']?>" onclick="window.location='konischefedern/filterpretraga.php'" />
        <input type="button" value="<?=$jfrontend['shopingcart continue springfederi']?>" onclick="window.location='springfederi/filterpretraga.php'" />
        <input type="button" value="<?=$jfrontend['shopingcart continue zugfedern']?>" onclick="window.location='zugfedern/filterpretraga.php'" />
        </div>
        <div style="color:#F00"><php echo $msg></div>
        <div class="shopping_table">
            <table border="0" cellpadding="5px" cellspacing="1px" style="font-family:Verdana, Geneva, sans-serif; font-size:11px; background-color:#E1E1E1" width="100%">
            <?php
                
    if(is_array($_SESSION['cart'])){
                    echo 
    '<tr bgcolor="#FFFFFF" style="font-weight:bold"><td>'.$jfrontend['shopingcart artnr'].'</td><td>'.$jfrontend['shopingcart price'].'</td><td>'.$jfrontend['shopingcart lager'].'</td><td>'.$jfrontend['shopingcart qty'].'</td><td>'.$jfrontend['shopingcart amount'].'</td><td>'.$jfrontend['shopingcart options'].'</td></tr>';
                    
    $max=count($_SESSION['cart']);
                                   
    // print_r($_SESSION);
                    
    for($i=0;$i<$max;$i++){
                                            
                        
    $pid=$_SESSION['cart'][$i]['productid'];
                        
    $q=$_SESSION['cart'][$i]['qty'];
                                            
    $db=$_SESSION['cart'][$i]['db'];
                                            if(
    $db=='springfederi'){
                                            
    $sum_spring+= $q;
                                            }elseif(
    $db=='bohringe'){
                                            
    $sum_boh+= $q;    
                                            }elseif(
    $db=='druckfederi'){
                                            
    $sum_druck+= $q;     
                                            }elseif(
    $db=='honisfederi'){
                                            
    $sum_honis+= $q;     
                                            }elseif(
    $db=='zugfederi'){
                                            
    $sum_zug+= $q;        
                                            }
                        
    $pname=get_product_name($pid);
                        if(
    $q==0) continue;
                
    ?>
                            <?//$db?>
                        <tr bgcolor="#FFFFFF"><td><?php echo $pid?></td>
                        <td ><?=$jfrontend['shopingcart valuta']?><?php echo get_price($pid,$db)?></td>
                        <td ><?php echo get_stanje($pid,$db)?></td>
                        <td><input type="text" name="product<?php echo $pid?>" value="<?php echo $q?>" maxlength="6" size="2" /></td>                    
                        <td><?=$jfrontend['shopingcart valuta']?> <?php echo get_price($pid,$db)*$q?></td>
                        <td><a href="javascript:del(<?php echo $pid?>)"><?=$jfrontend['shopingcart remove']?></a></td></tr>
                        <input type="hidden" name="productPID[]" value="<?php echo $pid?>" />
                        <input type="hidden" name="productQty[]" value="<?php echo $q?>" />
                        <input type="hidden" name="productPrice[]" value="<?php echo get_price($pid,$db)?>" />
                        <input type="hidden" name="productStanje[]" value="<?php echo get_stanje($pid,$db)?>" />
                        <input type="hidden" name="productPriceAll[]" value="<?php echo get_price($pid,$db)*$q?>" />
                            <?php    
                
                    
    }
                
    ?>
                            <? 
                           
    /* echo 'spring'.$sum_spring.'<br/>';
                             echo 'boh'.$sum_boh.'<br/>';
                             echo 'druck'.$sum_druck.'<br/>';
                             echo 'honis'.$sum_honis.'<br/>';
                             echo 'zug'.$sum_zug.'<br/>'; */
                          
                                    
    <?if($springfederi_cena){?><tr><td colspan ="3"><b>Wellenringe:<?=$jfrontend['shopingcart msg']?><?php echo $sum_spring?><?=$jfrontend['shopingcart msg2']?><?php echo $sum_popust?>%<?=$jfrontend['shopingcart msg3']?></b></td><td colspan ="2" ><b><?=$jfrontend['shopingcart newprice'].$jfrontend['shopingcart valuta']?><?php echo $ukupno_springfederi.'-->'.$springfederi_cena?></b></td></tr><?}?>
                                    <?if($druckfederi_cena){?><tr><td colspan ="3"><b>Druckfedern:<?=$jfrontend['shopingcart msg']?><?php echo $sum_druck?><?=$jfrontend['shopingcart msg2']?><?php echo $druck_popust?>%<?=$jfrontend['shopingcart msg3']?></b></td><td colspan ="2"><b><?=$jfrontend['shopingcart newprice'].$jfrontend['shopingcart valuta']?><?php echo $ukupno_druckfederi.'-->'.$druckfederi_cena?></b></td></tr><?}?>
                                    <?if($bohringe_cena){?><tr><td colspan ="3"><b>Bohrungringe:<?=$jfrontend['shopingcart msg']?><?php echo $sum_boh?><?=$jfrontend['shopingcart msg2']?><?php echo $bohringe_popust?>%<?=$jfrontend['shopingcart msg3']?></b></td><td colspan ="2"><b><?=$jfrontend['shopingcart newprice'].$jfrontend['shopingcart valuta']?><?php echo $bohringe_ukupno.'-->'.$bohringe_cena?></b></td></tr><?}?>
                                    <?if($zugfederi_cena){?><tr><td colspan ="3"><b>Zugfedern:<?=$jfrontend['shopingcart msg']?><?php echo $sum_zug?><?=$jfrontend['shopingcart msg2']?><?php echo $zugfedern_popust?>%<?=$jfrontend['shopingcart msg3']?></b></td><td colspan ="2"><b><?=$jfrontend['shopingcart newprice'].$jfrontend['shopingcart valuta']?><?php echo $zugfederi_ukupno.'-->'.$zugfederi_cena?></b></td></tr><?}?>
                                    <?if($honisfederi_cena){?><tr><td colspan ="3"><b>Honisfederi:<?=$jfrontend['shopingcart msg']?><?php echo $sum_honis?><?=$jfrontend['shopingcart msg2']?><?php echo $honis_popust?>%<?=$jfrontend['shopingcart msg3']?></b></td><td colspan ="2"><b><?=$jfrontend['shopingcart newprice'].$jfrontend['shopingcart valuta']?><?php echo $honisfederi_ukupno.'-->'.$honisfederi_cena?></b></td></tr><?}?>
                                    <tr></tr>
                                    <tr><td><b><?=$jfrontend['shopingcart total discount'].$jfrontend['shopingcart valuta']?><?=$sve_ukupno?><?=$jfrontend['shopingcart 9']?></b></td><td colspan="5" align="right"><input type="button" value="<?=$jfrontend['shopingcart clear']?>" onclick="clear_cart()"><input type="button" value="<?=$jfrontend['shopingcart update']?>" onclick="update_cart()"><input type='submit' value='<?=$jfrontend['shopingcart order']?>' onclick='this.form.action="billing.php";' />

    </td></tr>
                <?php
                
    }
                else{
                    echo 
    "<tr bgColor='#FFFFFF'><td>There are no items in your shopping cart!</td>";
                }
            
    ?>
            </table>
        </div>
        </div>
    </form>
    </body>
    </html>

  7. #7
    Join Date
    Feb 2014
    Posts
    11
    that was shopingcart here is functionss file
    PHP Code:
    <?php
        
    function get_product_name($pid){
            
    $result=mysql_query("select Art from springfederi where artnr=$pid") or die("select Art from springfederi where artnr=$pid"."<br/><br/>".mysql_error());
            
    $row=mysql_fetch_array($result);
            return 
    $row['Art'];
        }
        function 
    get_price($pid,$db){
            
    $result=mysql_query("select cena from $db where artnr=$pid") or die("select cena from $db where artnr=$pid"."<br/><br/>".mysql_error());
            
    $row=mysql_fetch_array($result);
            return 
    $row['cena'];
        }
        function 
    get_stanje($pid,$db){
            
    $result=mysql_query("select stanje from $db where artnr=$pid") or die("select stanje from $db where artnr=$pid"."<br/><br/>".mysql_error());
            
    $row=mysql_fetch_array($result);
            return 
    $row['stanje'];
        }
        function 
    remove_product($pid){
            
    $pid=intval($pid);
            
    $max=count($_SESSION['cart']);
            for(
    $i=0;$i<$max;$i++){
                if(
    $pid==$_SESSION['cart'][$i]['productid']){
                    unset(
    $_SESSION['cart'][$i]);
                    break;
                }
            }
            
    $_SESSION['cart']=array_values($_SESSION['cart']);
        }
        function 
    get_order_total($tabela){
            
    $max=count($_SESSION['cart']);
            
    $sum=0;
            for(
    $i=0;$i<$max;$i++){
                
    $pid=$_SESSION['cart'][$i]['productid'];
                            
    $db=$_SESSION['cart'][$i]['db'];
                            if(
    $db==$tabela){
                
    $q=$_SESSION['cart'][$i]['qty'];
                
    $price=get_price($pid,$db);
                
    $sum+=$price*$q;
                            }
            }
            return 
    $sum;
        }
        function 
    addtocart($pid,$q,$db){
            if(
    $pid<or $q<1) return;
            
            if(
    is_array($_SESSION['cart'])){
                if(
    product_exists($pid)) return;
                
    $max=count($_SESSION['cart']);
                
    $_SESSION['cart'][$max]['productid']=$pid;
                
    $_SESSION['cart'][$max]['qty']=$q;
                            
    $_SESSION['cart'][$max]['db']=$db;
            }
            else{
                
    $_SESSION['cart']=array();
                
    $_SESSION['cart'][0]['productid']=$pid;
                
    $_SESSION['cart'][0]['qty']=$q;
                            
    $_SESSION['cart'][0]['db']=$db;
            }
        }
        function 
    product_exists($pid){
            
    $pid=intval($pid);
            
    $max=count($_SESSION['cart']);
            
    $flag=0;
            for(
    $i=0;$i<$max;$i++){
                if(
    $pid==$_SESSION['cart'][$i]['productid']){
                    
    $flag=1;
                    break;
                }
            }
            return 
    $flag;
        }

    ?>
    i need just in this part of code in shopingcart
    PHP Code:
    ?php
        
    include("includes/db.php");
        include(
    "includes/functionss.php");
        include(
    "languages/frontend.ch.php");
            
    //$db = $_SESSION['database'];
        
    if($_REQUEST['command']=='delete' && $_REQUEST['pid']>0){
            
    remove_product($_REQUEST['pid']);
        }
        else if(
    $_REQUEST['command']=='clear'){
            unset(
    $_SESSION['cart']);
        }
        else if(
    $_REQUEST['command']=='update'){
            
    $max=count($_SESSION['cart']);
            for(
    $i=0;$i<$max;$i++){
                
    $pstanje=get_stanje($pid);
                
    $pid=$_SESSION['cart'][$i]['productid'];
                
    $q=intval($_REQUEST['product'.$pid]);
                if(
    $q>&& $q<=$pstanje){
                    
    $_SESSION['cart'][$i]['qty']=$q;
                }
                else{
                    
    $msg='Some proudcts not updated!, quantity must be a number between 1 and 999';
                }
            }
        }

    ?> 
    when script call for function that take a look in DB under selected Artnr ( item ID ) and if quantity is bigger then number in DB to fail to update shopingcart .. i hope that you undestand me now..
    here is table structure

    PHP Code:
    CREATE TABLE IF NOT EXISTS `druckfederi` (
      `
    Artint(10unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
      `
    infovarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    dvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    Devarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    Lovarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    Rvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    ntvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    Lnvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    snvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    Fnvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    rdjvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    stanjevarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    cenavarchar(100COLLATE utf8_unicode_ci NOT NULL,
      `
    artnrvarchar(100COLLATE utf8_unicode_ci NOT NULL,
      
    PRIMARY KEY (`Art`),
      
    UNIQUE KEY `a` (`Art`)
    ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Informacije of stanju' AUTO_INCREMENT=35 
    and if you have some email or something to give me so ai can contact you that will be good pliz and thx for helping me

  8. #8
    Join Date
    Feb 2014
    Posts
    11
    here is link for rared files that i show here if its eazyer to you

    http://144.76.64.35/~urbanbas/images/shopingcart.rar

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles