let me explain what I mean on the subject. I have a query to db like this: "SELECT * from partners WHERE idioma=’$lang’ OR idioma=’EN’ ORDER BY id_partner ASC"; This query will return several results, some of them may be repeated because my database has the translations and we have a multilingual webpage in which ..
Category : mysql
I have some hard times to save a blob (image file) to my sql-database. I have three files: a html form (form.php), an ajax script (ajax.js) and a php-file (save.php). I think i have some errors in my ajax.js, but after a long google search i couldn`t find a good solution. There must be a ..
I have this piece of code that i want to execute on page load. The code works well but i want to display a success message TEMPORAILY and only when the code is executed. The problem i am having is that the success message displays permanently even when the code has not been executed. I ..
I do have a form where the user can retrieve the data depending on the dates selected. Here’s what I have: <form class="form" method="post"> <div class="form-row"> <div class="form-group col-md-2 col-5"> <label class="col-form-label col-form-label-sm" for="From">From</label> <input type="date" class="form-control" id="fromDate" name="fromDate" value="<?php echo (new DateTime(‘first day of this month’))->format(‘Y-m-d’);?>"> </div> <div class="form-group col-md-2 col-5"> <label class="col-form-label col-form-label-sm" ..
I am having some questions in Docx. I want to read the docx and insert into my table along with the questions and options. Could you please help me out how to do it in PHP and MYSQL? Adding the sample docx link in google drive. https://drive.google.com/file/d/1ug9x9t6LBl5M0nAJNTXmt6nKNAfcuQz8/view?usp=sharing Thanks Sourc..
I’ve pieced together some code I’ve gleaned from the internet: I’m trying to scan a directory to insert file names and index into MariaDB table. My last hurdle it seems is this PDO error: PDO::exec() expects exactly 1 parameter, 2 given on line 55. I’ve tagged line(55) with ‘//error thrown here’. My novice guess is ..
I’m trying to create in a website in codeigniter a functionality to always that someone fill a Form it will create an entry in my database and send an email with that information. Now I already have everything so it goes to the database but i need to know how to sent the email. <div ..
When i try to use : sudo mysql -u root use mysql; SELECT user, plugin FROM user; UPDATE user SET plugin = "mysql_native_password" WHERE user = "root" ; exit service mysql restart` it seems an error–> ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to ..
so i’m new to developing an eCommerce site in general, trying this out for a personal project. so i have my products displayed on the home page under category "all products". i have it "href" to my product page where it gets the item code and displays it on the single page, this works fine ..
I am trying to build a registeration form. I tried to follow many instructions from Youtube and the whole internet but I can’t resolve my issue. Changing hostname from localhost to digitalocean server ip xx.xxx.xxx.xx also did not work. here is a snippet from the register.html <form class="cont_form_sign_up" action="registeration.php" method="post"> <a href="#" onclick="ocultar_login_sign_up()"><i class="material-icons"></i></a> <h2>SIGN ..