11,093 Topics
 | |
 | Hi All, So I an creating an online store just to play around with code and learn from it. I am building a store and on the confirmation page, I am trying to update the QTY of items in a cart by using the '-' or '+' buttons. However I … |
| | Hi All, I am trying to create some search functionaltiy for my website, but for some reason when I search any word, even if its not in my database it will display all the results from a particular column. Here is my code <?php error_reporting( ~E_DEPRECATED & ~E_NOTICE ); define('DBHOST', … |
| | I am working on a anouncement system. the announcements are displayed everywhere in the website, every anouncement has a acknowledge button, basicaly to mark it as seen. what i have: Table: announcements: annId, annTitle, annContent, annDatetime Table: annComplete: annCompletedId, annId, userId, annCompleteDatetime I first pull all the announcements from the … |
 | Hello i have a mysql statement and i want to add more parameters to get different results. SELECT DISTINCT M.message,F.friend_one,F.friend_two, F.role,U.uid,U.username FROM users U,friends F, messages M WHERE ( U.status='1' AND F.friend_one = '88') OR (F.friend_two='88' ) AND F.role='friend' 88 is the users id so i want to show M.message … |
| | Hello i have a database which users make groups or send messages to other registered, in our project, users. So you have messages as M,users as U, groups as G. So you want to show all updates that happen in these tables WHERE (uid - thats the user id column … |
 | Hello php community, Could you help me in my research? I just cannot find what I am looking for. I am working on a website with PHP and MySQL. I am trying to get a filter option on my website to fetch the information from database. Here are the filter …  |
| | I have one table with questions and another table with correct answer If any user attempt question then I need result with marks.  I want result:-  Thanks in advance! |
| | Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim str As String = "Server=localhost;Port=3306;Database=testdb;Uid=root;Pwd=password" Using con As New MySqlConnection(str) Dim …  |
 | What's the difference between LCASE() and LOWER() in MySQL? I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?  |
| | I'm doing both SELECT and UPDATE queries using named placeholders. But course data from the database doesn't populate form, as expected. The database table row records don't populate, each time I try to edit a course in the browser. I connect to the database usining PDO. And I do SELECT … |
 | i am facing some issue in PHP. i have some records against blood report. That are simple some are possitive and some are Negative. i just want to now that from total records. What is the percentage of total Possitive records in my database in Php. Thanks in Advnace. Regards …  |
| | *Hello** This has been a question for a long time / Request for help for a PHP script. A year ago I created a homepage for a friend (online tutoring website) and installed a finished script for an occupancy calendar and did not consider / knew that the server will … |
| | I'm trying to upgrade my script from PHP 5.5 to PHP 7.2. And that came with the script not able to modify a selected table row as before. The records don't even populate whenever I try to edit a course in the browser. Please, note that I'm connecting to the … |
 | $query = "INSERT INTO 'user-profiles' ('name', 'avatar', 'description', 'votes', 'pay_methods', 'location', 'user_id') VALUES ('sadj', 'qwesad', 'sadqwdqw', '0','sadsad', 'sadasdsad''4')"; $resultprof = $this -> conn -> query($query); votes and user_id are INT columns, and user_id is a foreign key. Making this insert on mySQL directly it works perfectly, but on my PHP … |
| | I need help with implementing MySQL transactions with PHP. Specifically, I'm confused between the flags `WITH CONSISTENT SNAPSHOT`, `READ WRITE`, and `READ ONLY`, what their differences are, and how they relate to table locking. I already read the MySQL reference manual but I'm still confused. |
| | hi all , i have the Following CSV generated by a third party software, i need to be able to read the first row and see what month and year it is. what i would like to do is generate a MySQL Table using the "<monthyear>" so november2018 and place … |
| | If a bulk MySQL insert takes 5 minutes to complete, and one of the columns in the table is a TIMESTAMP column with a default value of CURRENT TIMESTAMP, will the timestamps of the rows that were inserted be reflective of the entire 5 minutes, or will they all default … |
 | How to downgrade mysqldump tools: I am using mysql bench and when trying to export online databases from mysql bench to sql file I am getting this error: mysqldump.exe is version 8.0.13 but the MySQL Server to be dumped has version 5.7.21. Because the version of mysqldump is not the … |
 | Hello everyone! I'm new here and I really need some helps regarding my php coding. I'm trying to do an Update page and the error keeps popping out "Undefined adminid". I've been trying to fix it but to no avail. Can you help me? //my database connection <?php $host = … |
 | Hi there I am new at this website thanks for every one that help me I have this output appear on the link below: [Click Here](https://ibb.co/fe8Cvf) I want to while I choosing a **Time** **value** this value must be send for these useres that **absence** row the checkbox is **checked** …  |
 | I want to create a php function that i can use to get a particular user details and display the info gotten in my ProfileActivity when a user profile is been clicked in my app. so i wrote this php code to get user details from my database but when … |
 | Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, … |
 | <?php $msg=""; $image1=""; $image1_err=""; //if upload button is pressed if(isset($_POST['upload'])){ $target="images/".basename($_FILES['image']['name']); $db=mysqli_connect("localhost","root","","categories"); $image=$_FILES['image']['name']; $text=$_POST['text']; if(isset($_POST['electro'])){ $sql="INSERT INTO electronic(image,text) VALUES ('$image','$text')"; mysqli_query($db,$sql); } //move image to a file if(move_uploaded_file($_FILES['image']['tmp_name'],$target)){ $msg="Image uploaded successfully"; }else{ $msg="There was a problem uploading image"; } } ?> <!DOCTYPE html> <html> <head> <title>Image Upload</title> <link rel="stylesheet" type="text/css" … |
 | I want to protect my site from hacking. Currently I know about XSS and SQL injection. Do I need to use mysqli instead of mysql? And why? When should I use `htmlentities()` and `striptags()`? I also don't want users to upload melicious files and since I accept file uploading, is … |
 | Hi, In my application two fields are the user id and user name,i want to show the user name and user id along with other details in a html table. user id is a numeric dropdown menu and user name is text only.How can i show the specfic record in …  |
 | <html> <head></head> <link rel="stylesheet" type="text/css" href="style.css" <body> <?php $db = mysqli_connect('localhost', 'root', '', 'formdb'); $formId = ''; $LastName = ''; $FirstName = ''; $Email = ''; $Birthday = ''; $Birthplace = ''; $Comment = ''; if (isset($_GET['upd'])){ $formId = $_GET['upd']; $results = mysqli_query($db, "SELECT * FROM tbl_form WHERE formId=$formId"); } …  |
 | hi i make a page for registration and login after that i uploaded image ..i want to show those image by own user id..plz help me..thanks in advance :)  |
 | I have a Table that displays titled and first name columns and delete link on the 3rd column. Unfortunately for a reason i don't understand, records are not deleting when the Delete link is clicked. Please friends, help me figure out what's wrong here. Table <?php $user_id = $_SESSION["user_id"]; //brought … |
 | Hello, I can't display images from database. I have folder called "images" next to index.php where I keep images. I suppose I have wrongly defined folder path with images or sth else. <?php $connection = new mysqli("localhost", "root", "", "crud"); $sql = "SELECT * FROM test"; $res = $connection->query($sql); if(@$res->num_rows … |
| | i am creating an app with android studio and i'm using mySQL.and i want to implement friends feature in my app to enable users send and recieve friend requests, i have created tables and writen the server side php code for that, i have also created an add as friend … |
 | Hi, i have a plugin called wp deposits and a template called automotive, i need the client to be able to pay a non refundable fee of 5% which is working fine through wp deposits, the thing is wp deposit is picking price from woocommerce, i want it to pick … |
 | I'm a newbie in php and I want to create a single login page for Admin and user.When admin log in it should go to an admin page and when user log it shoult go to index page.I want help with my code, it works fine login normal users but … |
| | Hello i have a project that uses firebase but i want to make connect to my MySql database on xampp. Any idea what to do? |
| | hi, I am stuck trying to figure out how to build a table to display agents names, (that I already have, mysql table etc...) but now I need to add columns dynamicaly. I need to add (programs in witch agents are enroled, and a status of the program ( in-progress, … |
| | I have a database of pictures, and votes. The pictures database has up_votes and down_votes culomns. I want to create a system using MySQL to get hot and trending pictures just like 9Gag. How can I do that? |
| | I send payments to my users regularly. But sometimes the user enter a PayPal email address that cannot receive money from other PayPal users. They just can receive money from their website. How can I check for this and show an error to the user? Do I need to use … |
 | Hey, I'm looking to learn more back-end managing as I'm primarily a front-ender. So, maybe you could suggest some learning resources? Idealy free, but I know it's not always possible. I've already completed a couple of courses on the internet mainly https://www.bitdegree.org/course/sql-course and been on YouTube, Google (that's how I … |
 | <?php $db = new Db(); $mysqli = Db::$_mysqli; if (isset($_POST['name'])) { $name = escape($_POST['name']); $email = escape($_POST['email']); $phone = escape($_POST['phone']); $password = escape($_POST['password']); $result = array(); /*check email is unique*/ $email_num = $db->GetNum("user","email='$email'"); if ($email_num == 0) { /*insert into database*/ $md5password = md5($password); $insert = $db->Insert("user","'','$name','$email','$phone','$md5password'"); /*success*/ if ($insert) … |
| | This the code in products <?php require_once("inc/header.php"); require_once("inc/navbar.php"); /* if user is logged in then only allow the user to view the page */ if (!isset($_SESSION['id'])){ echo "<h1 class='text-center text-upper text-bs-primary'>please login to view your cart <a class='text-black' href='login.php'>Login</a></h1>"; exit(); } else{ $user_id = $_SESSION['id']; } $carts = $db->FetchAll("*","cart","user_id='$user_id' AND … |
| | Hello everyone. I want to build a special form. It has different kind of input types text, radio,select and combo boxes. Specility of my need is this. *I need to insert one element value as one record to database. Let's assume there are two textboxes and radio button group. It … |
| | Recently I'm trying to pass text boxes , radio buttons and checkboxes vaues to database. For that for the clear understanding I'll provide simple way of form. <form method="post"> <input type="text" name="KKK"><br> <input type="text" name="val[]"><br> <input type="text" name="val[]"><br> <input type="text" name="val[]"><br> <input type="radio" class="form-check-input" value="new" name="val[]">New <input type="radio" class="form-check-input" value="recondition" … |
| | How i do remove duplicate questions from my excel file??? There are more then 150 questions in my excel file  |
 | $table = "<table>\n"; for ($i = 0; $i < sizeof($rounds); $i++) { $table .= "<tr><th>Week #: " . ($i + 1) . "</th><th>Match</th><th>Away</th><th>Referee</th></tr>\n";//table headers foreach ($rounds[$i] as $r ) {//iterate through an array $table .= "<tr> <td> Day :</td> <td> $r </td> <td>".$r["Away"]."</td><td> </td></tr>\n"; //i want to store values of …  |
 | I am trying to select all rows from all tables in the database when a column equal a given name. I have like many tables with same structure and columns. I have written this piece of code but it throws an error. SELECT GROUP_CONCAT(qry SEPARATOR ' UNION ') INTO @sql … |
| | heY guys :) recently I'm on web project which I use MySQL, bootstrap, PHP and Javascript. For this I have generated successfully dynamical forms using PHP. I'm using mysqli commands. I used dynamic forms if it not used I have to create hundred of html pages. So by doing this … |
 | I have a table on my web page that is currently updating with random Data, see below: function changeContent(){ var i = 1; var len = numberRows; var random1 = Math.floor( Math.random() * 90 ) + 10; var random2 = Math.floor( Math.random() * 90 ) + 10; var x=document.getElementById('myTable').rows; var … |
 | Hello Everyone, I need an information about how to join in query in MYSQL. |
 | I have a simple MySQL database keyword search that is functional. However results for the search are not being returned if the keywords are not in the same order as entered in the database. For example searching for "dog cat mouse" will return a result, becuase this is the order … |
 | Hello, Iam getting an fatal error " PHP Fatal error: Cannot redeclare class MysqlConnect " It was my connection file and the website was working from the past two years. Yesterday on of my friend said my website was down so that time i noticed this issue I got the … |
 | I have a script for product Invoice which save details of sold product, but it do not update stock quantity when any product sale. Product quantity in stock remain the same which should decrease.. here is the code to save invoice details using for each loop : <?php function saveInvoice( … |
The End.