Search the Community
Showing results for tags 'data base'.
-
Hello, I need your help for this. I like to add two buttons in CMS page. One is the link for product and another is the link for the page of CMS. I added two fields for the product link and the cms link in Admin of cms. But the system can’t save those two values after I inputted two IDs of product and cms. I designed to add ID of the product or the CMS page instead of the link. Probably I missed the code a lot, so please help me… I attached the screenshot of front and admin including the added code. Earnestly I want to get the support of two problems: First: the solution that the system can save the values of two new fields. Second: I created new functions to get the ID value of new fields from the data base. Where are these functions supposed to be called from? Thanks!
-
Bonjour, Sur PS 1.5.6.2, la TVA sur mes factures et sur mes avoirs est toujours aussi farfelue (à cause des arrondis ou des oublis de remises) et j'ai donc des modifications à faire dans la base de données pour générer des factures correctes en terme de TVA. Pour mes factures, je modifie les chiffres dans PS_order_invoice, PS_order_detail_tax, PS_order_invoice_tax, et PS_order_detail en fonction de ce que j'ai besoin.... Par contre pour les avoirs (order_slip), je ne sais pas où ils vont chercher leurs données parce qu'une fois générés, à part dans PS_order_slip qui contient le total TTC de la facture et des frais de port, on ne peux rien modifier d'autre... Qui peut m'aider à trouver comment est construit un avoir et surtout quelles données utilise t'ils pour s'afficher ? Merci Hermès
- 2 replies
-
- order slip
- tva
-
(and 5 more)
Tagged with:
-
Hello everybody thanks for reading. I was uploading a few days ago from v. 1.3 to 1.4.7.3 something is wrong may be I touched one table on the database too. So I have some problems now: I'm like administrator user and that's happen 1. Some tabs disappear I needed because i want to do the upload again for the last version and I can't reach the module for that. 2. When I tried change the customer information in his address say: access denied I hope you can help me thanks
-
- data base
- access denied
-
(and 2 more)
Tagged with:
-
Hi Everyone, Im trying to do an update on ps_stock_available table, i'm doing it this way. The first i do is read the xml file where i have the data i need foreach ($xml->children() as $products) { foreach ($products->children() as $product => $data) { $id_product = $data->id_product; $id_product_attribute = $data->id_product_subcategory; $stock = $data->stock; // STOCK DISPLAYS CORRECTLY $output .= $this->displayConfirmation($this->l($stock)); // DATA DISPLAYS CORRECTLY // $output .= $this->displayConfirmation($this->l($id_product)); // $output .= $this->displayConfirmation($this->l($id_product_attribute)); // $output .= $this->displayConfirmation($this->l($stock)); // IS THE UPDATE EXECUTED CORRECTLY? my module do not crash Db::getInstance()->update('ps_stock_available', array( 'quantity' => (int)$stock, ). 'WHERE id_product = ' . $id_product . 'AND id_product_attribute = ' . $id_product_attribute); } } Thanks a lot in advance
-
Bonjour, je cherche à lister les catégorie dans mon site dans une liste déroulante (combobox) et selon la catégorie choisie un deuxième combobox sera remplir par les sous catégorie. j'ai commence à développer cette idée mais je suis bloqué au niveau de 2 ème combobox (comment se faire la liaison entre les deux ?!) voila mon travail : fichier TPL: {capture name=path}{l s='Recherche'}{/capture} {include file="$tpl_dir./breadcrumb.tpl"} <h1>{l s='Recherche'}</h1> <div class = "rte"> <form action="notice.php" method="post"> <p> Bienvenue dans votre centre de télèchargement, vous y trouverez ... </p> <p><input type="submit" id="SubmitValider" name="SubmitValider" class="button_large" value="Valider"></p> <!-- depuis base de données --> <select onChange=" " name="id"> <option value="Select">Select</option> {foreach from=$categories item=categorie} <option value="id{$categorie.id_category}">{$categorie.name}</option> {/foreach} </select> </form> </div> fichier Controller.php: <?php class NoticeControllerCore extends FrontController { public $php_self = 'notice'; public function postProcess() { } public function process() { } public function setMedia() { parent::setMedia(); $this->addCSS(_THEME_CSS_DIR_.'notice.css'); $this->addJS(_THEME_JS_DIR_.'notice.js'); } public function initContent() { parent::initContent(); $categories = Db::getInstance()->ExecuteS(' SELECT * FROM Table where champs'); $this->context->smarty->assign('categories',$categories); /*$souscategories = Db::getInstance()->ExecuteS(' SELECT * FROM table where condition sur ID selectionné'); $this->context->smarty->assign('souscategories',$souscategories);*/ $this->setTemplate(_PS_THEME_DIR_.'notice.tpl'); } public function displayContent() { parent::displayContent(); self::$smarty->display(_PS_THEME_DIR_.'notice.tpl'); } } ?> j'ai essayé avec getXMLHttp() dans le fichier JS mais j'ai d'erreur There are a problem while using xmlhttp 1)not found 2)Internal server error Merci de me guider à développer cette idée ...
-
Hola, al querer instalar Prestashop, me bloqueo en la configuración de la base de datos. Eh instalado prestashop anteriormente sin problemas, pero con el nuevo servidor, no me reconoce el host Database server address: mysql.nixiweb.com Nombre de la base de datos: u466923323_seba1 Inicio de la base de datos: u466923323_seba2 Contraseña de la base de datos Tipo de base de datos: InnoDB Prefijo de las tablas: psd_ Como habrán notado, el host es nixiweb.com ya que me pareció la mejor opción de las gratuitas, y pude enlazar el dominio .com.ar sin costo Desde ya, muchas gracias por cualquier ayuda
-
Hi friends... i have a problem... i need insert a data into a new table from prestashop's db, but, where put the consult ? which files I have to change? when make a orden,, where is the insert? i appreciate your response..
-
Hi, I would like to migrate from v1.3.1.1 to v1.4.7.0. My plan was to migrate as follows : - save the database from the admin panel of v1.3.1.1 - install v1.4.7.0 - from the admin panlel of v1.4.7.0, import the database. My question is the following : Will the importation work ? Thank you in advance for any reply. Patrick
-
hello guys i have installed prestashop offline on local server " i have used wamp" then i have free host at funpic.org i have uploaded the site but i receive the following message : Link to database cannot be established so what would i do ? i have figured out that is a data base issue but then what ? thanks in advanced