10,940 Topics
 | |
| | 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 … |
The End.