10,946 Topics
 | |
| | Hi All, I am having an issues with an SQL query and I can't quite work out how to resolve it. I have searched Google for the answer but can't seem to find the solution there either. Basically I have a database andin one of the tables it has a …  |
 | // To protect MySQL injection for Security purpose $stmt = $conn->prepare($SQuery); $stmt->bind_param("i", $user_id); $stmt->execute(); $stmt->bind_result($fullName); $stmt->store_result(); if($stmt->fetstmt->store_result() ch()) //fetching the contents of the row |
| | I'm utilizing phpMyAdmin to deal with my information bases, I have 2 tasks that utilization 2 diverse data set the first uses 'root'@'localhost' and the second is 'root'@'127.0.0.1' I don't have the foggiest idea how I wound up utilizing 2 distinctive worker however it was working fine until I attempted …  |
 | Hi all,` The below code is giving me problems. <?php $ddaa = $pdo->query("SELECT id, stockname, stockno, producer FROM storemaster order by stockname");; while ($data = $ddaa->fetch(PDO::FETCH_ASSOC)) { echo '<option value="'.$data['stockno'].'" data-producer="'.$data['producer'].'"> '.$data['stockname'].'</option>'; } ?> This is the script: <script> $('#stockname').on('change',function(){ if($(this).val() !=0){ $('#stockno').val($(this).val()); $('#producer').val($(this).attr('data-producer')); } }); </script> All I wanted … |
| | Hello Guys, I'm a beginner in web developing and currently building a website for my assignment.In the website,i have to create a form that allow user to upload multiple images in multiple field. My problem is when user upload the first images,they can't proceed to upload the second images and … |
 | Hello i have a Mysql statement that supposes to return to results. The statement is SELECT c.user_one,c.user_two,c.c_id,r.reply FROM conversation_reply r JOIN conversation c ON r.c_id_fk = c.c_id WHERE c.user_one = '3' OR c.user_two = '3' GROUP BY r.reply I have only two records in the table so the result should … |
| | Hello, I wanted to make a unique UI for My website, which should be look like https://www.beyoung.in/ This website. provide me a valuable suggestion. |
| | <?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); session_start(); if (isset($_POST['delete_account'])){ require 'conn.php'; global $conn; $password = $_POST['delete_password']; $email = 'delete@gmail.com'; $user_id = '5'; $sql = "SELECT * FROM user_acounts WHERE e_pasts=?;"; $stmt = mysqli_stmt_init($conn); // Inicializācija if(!mysqli_stmt_prepare($stmt, $sql)){ header ('location: userpanel.php?error'); exit(); }else{ mysqli_stmt_bind_param($stmt, "s", $email); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); } … |
 | I have the following query which has died after running over an hour on my local mysql 8 server: UPDATE download LEFT JOIN lookup ON download.ip_address between lookup.start_ip AND lookup.end_ip SET ref = ( SELECT lookup.id FROM lookup WHERE download.ip_address between lookup.start_ip AND lookup.end_ip); All ip fields are IPV4 and … |
 | Hi. I'm trying to write a game in PHP. Now a weird item shows up in my database. http://www.leondegroot.nl/files/mysql_nieuw.png "Nieuw" means "New". Do you have any idea what this is and how to delete it? Thanks, Leon |
| | hi guys hope you are well, i on progress for making website but i have a problem with array and looping, how to stop looping when all data has been output. <form method="POST" action="storedata_g6b.php"> <table class="table"> <thead class="thead-dark"> <tr> <th class="col-3">id</th> <th class="col-7">nama</th> <th class="col-3">rank</th> </tr> </thead> <tbody> <?php $rank_b … |
 | ERROR 1054 (42S22): Unknown column 'Firstname' in 'field list' I'M gettin the above error when I enter: mysql> insert into people (fname, lname) -> VALUES (Firstname, Lastname); Here's the table: mysql> desc people; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | fname …  |
 | Hi all, I have been confusing myself for days over this so bear with me if it gets a bit confusing. I have a table called tags with columns id, name which list all unique tags (linux, php, mysql, etc.). And I have an array that includes some tags that … |
 | $stmt = $dbconn->prepare("SELECT * FROM `members` WHERE username=? AND password=?"); $stmt->bind_param("ss", $username, $password); Is what I have. Database is connected etc. How can I set variable called `$dbresult` with array of SQL result? I don't want to set individual variables. I really need an entire array as answer. There's couple …  |
| | I have two MySQL tables, which I want to SELECT using a single PDO query and positional placeholders. I've been going through similar questions here to find a solution, but none seems to match the issues I'm having. The following code is the section of my script: <?php // query … |
| | I have created a php form that connects to a MySQL database. This is working fine however I have added validation and this doesn't appear to be working correctly and still posts to the results to the database regardless of if they are validated or not. Any ideas? |
| | please if anyone could tell me, how it would be possible, i want to save the content of a uploaded word document in database field with php, no problem with encrypted file like ( ´V z2Ö<Ö<ôÿÿÿÿÿÿ·üü?????ÿÿÿÿSSS8‹DÏLS¥9à1) as it shows if you open a word document in a browser. just want … |
| | Peace be with you! I have been developing apps with VB.NET (old fashion??), upon deployment, all my apps connect to a mysql database server by also installing a mysql database server and of course, mysql db connector to other computers together with the app. But, I can see there a … |
| | I have set up for users online but some users showing always online . can you help anyone this my code  <?php if ($Row->logged_in == '0') { if ($Row->last_login != '0000-00-00 00:00:00') { ?>Last Login : <?php echo date('d M Y ,H:i A', strtotime($Row->last_login)); } else { echo "<span …  |
| | Hi all. I am having one chat script which I used for my site. It was working fine with mysql database. Then after updated PHP 7 with mysqli then suddenly stopped for working. I need to make the code work with PHP 7 + mysqli. Please help me it was … |
| | I'm trying to redirect user to "**userinfo.php**" after successful registration, but the browser terminates the redirection because it goes into endless loops. Moreover, I need your insight on if the script is secure or not. I need your help, please. Thanks. The following is the "**register.php**" script: <?php // include … |
| | I'm struggling to build a PHP registration script using PDO prepared statements with positional placeholders. But the MySQL queries don't execute. `var_dump();` doesn't display any error. Please, I need your help to fix this. Your time and input are much appreciated in advance. Thanks. **register.php:** <?php // include configuration file … |
| | images = [createProductForm.productImageModel.data, createProductForm.productImageModel.data] for image in images: if image.filename == '': print('Image must have a filename') return redirect(url_for('createProduct')) if not allowed_image(image.filename): print('Image extension is not allowed') return redirect(url_for('createProduct')) else: filename = secure_filename(image.filename) file_path = image.save(os.path.join(app.config['IMAGE_UPLOADS'], filename)) print(mysql.format(file_path)) mysql.connection.commit() print("Hello yes!") print("images saved") If i were to convert the image … |
| | Hi, How do i store files into blob datatype into mysql via user input with python? def read_file(filename): #Convert digital data to binary format with open(filename, 'wb') as f: photo = f.read() return photo @app.route('/createProduct', methods=['GET', 'POST']) def createProduct(): createProductForm = CreateProductForm() msg = '' if request.method == 'POST' and …  |
 | Greetings to everyone, I am working as a freelance web developer, i have more than 4 years experience in osclass scripts. I am working in the osclass scripts for the past 4 years and have created nearly 67 sites in osclass, and have created many plugins, cuztomized themes, plugin cuztomizations … |
| | I am a nyophyte to PHP, and I've seen this answered so many different ways that it is confusing. I have a combobox that is dynamically populated from a MySQL table ACTIVE in a database AIRCRAFT. Based on the selected AIRCRAFTREGISTRATION value from the combobox, I want to find and …  |
| | I have being passing across this word above without knowing the meaning, please someone should come up with an answer. |
| | Php Seniors, I still on OOP and mysqli. Not on pdo or oop yet. So, kindly show samples to that level, if you must. Can you tell me if this query is ok to get row count ? It works on my side but I need your confirmation. [code] $query_2 … |
| | Hello guys i'm using [batflat](https://github.com/sruupl/batflat/blob/master/inc/core/lib/Image.php) for a small project. The thing is want to save/display webP images too, How can it enabled/possible?. I try **imagecreatefromwebp** without luck. Any idea/help will be awesome. Gracias! /** * Saves image * * @param string $path Path to location * @param string $type Filetype … |
| | Hi all I'm trying to put together a room hire site, to be used by the lettings clerks, for our local Quaker meeting house and I've hit a couple of problems. I have an HTML form that, using data from a MySQL database and some JSON and JavaScript, when a … |
| | I'm struggling to add a course to a MySQL database table using PDO prepared query with positional placeholders. When the form is submitted, the database table is not updated, as expected and no error is displayed. Please, where exactly do I place `var_dump()` to display the error? And how can … |
 | Hello, kindly look at my php code to insert registration data into a MySQL database. Here is the code below and further below, the error response I keep getting. <?php error_reporting(E_ALL); ini_set('display_errors', 1); $servername = "localhost"; $username = "emiola"; $password = "emmybaba2020"; $dbname = "tutors"; // Create connection $conn = … |
| | please help me. below chart.js works very well but here show all date data from database but i want only last fifteen days data to show. How can i show last 15 days sale reports. i am attach code below. thanks  I an developed an chart.js for my daily …  |
 | How to create a synchronized Online/Offline data application with php/mysql |
| | I am just getting this mistake **" Parse error: syntax error, unexpected 'if' (T_IF) in C:\wamp64\www\genius\install\run_install.php on line 48" **is there anyone to solve?** ** <?php define('GENIUSOCEAN','https://geniusocean.com/verify/'); ini_set('max_execution_time', 300); if (!isset($_POST['web_name']) || $_POST['web_name'] == ""){ echo "Please Enter Website Name"; }else if (!isset($_POST['web_url']) || $_POST['web_url'] == ""){ echo "Please Enter … |
| | |
 | $select = "SELECT * FROM `success-stories` where id='$id'"; $result = $conn->query($select); $row = $result->fetch_assoc(); $file = $row["download_pdf"]; $file_arr = explode("/", $file); $path = $file_arr[0] . "/" . $file_arr[1] . "/" . $file_arr[2]; header('Content-Description: File Transfer'); header('Content-Type: application/pdf'); header('Content-Disposition: attachment; filename="' . basename($file) . '"'); header('Expires: 0'); header('Pragma: no-cache'); header('Content-Length: ' … |
 | I have to make a program that reads the number of seats and stores it in a two dimensional array. The empty seats is hashtag and if the user buys a seat it becomes *. The odd rows have 15 seats and even have 20. When I purchase a seat, …  |
| | Hi, could you please let me know what should I learn first about programing? I mean, may be I need to learn HTML, C++, Java, read a specific book, I don't know where to start and hope you can show me the way, please!! I would really appreciate it |
| | I need to improve my English communication skill, but I am very boring to use language learning tools/methods, but instead of this I would like remote working on some real PHP/JavaScript/Node.js/DevOps project (where I feel strong) and as a side effect would be practicing English communication. I have max 10 … |
| | I have a MySQL table that lists delivery records (customerId, date, quantity, productId, cost). I have a requirement to log certain items from the delivery table into a separate table to track items being sent to quarantined areas. All quarantined products must have a serialized tag affixed for tracking with … |
| | Hi all, I have assigned a column called "friendshipstatus" as a default value =0 in addfriends table that user can add other users to it to be friends as the code bellow which will give any users added as friend in addfriendss table the "friendshipstatus" value of 1 <?php include … |
 | I have a website, got it developed from someone, Need help in redirecting back after login in php. After Login it redirects to Home Page. But i want user to go back where he came from. logincontroller.php public function checklogin(Request $request){ $phone = DB::table('users')->where('contact','=',$request->input('code').$request->input('contact'))->get(); if(count($phone)>0){ $user_data = array( 'email' => … |
| | I'm trying to create a trigger that does two things, first take an ip that's in dot notation and run inet_aton on it and put the result in another field. Second, checks a lookup table to identify an ip range that the result of the first action falls into and … |
| | My code has a query that looks like: INSERT INTO table VALUES (...) ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), ... id is a PRIMARY KEY. My question is that I can't for anything remember why I have id = LAST_INSERT_ID(id). I wrote it years ago and it's not commented. … |
| | I want to be able to update my database in order to change some dynamic content on my site which contains movie reviews. First Step I need to be able to select which movie review I want to update by selecting it from a dropdown menu which is dynamically populated …  |
 | Notice: Undefined index: ID in C:\xampp\htdocs\tugas\phpdb\ubahsimpan.php on line 10 im tired ,,, how i can fix that? My ubahdata.php <html> <body> <?php $koneksi=mysqli_connect("localhost","root","") or die ("Koneksi Gagal".mysqli_error()); if($koneksi){ mysqli_select_db($koneksi,"buku") or die ("Database gagal dibuka".mysqli_error()); $ID=$_GET['ID']; //Mejalankan Querry $sql="select * from anggota where id_anggota='$ID'"; $qry=mysqli_query($koneksi, $sql) or die ("Querry gagal".mysqli_error()); $data=mysqli_fetch_array($qry); … |
| | a) Write MARIE code to: 1. Input a number and store it in X . 2. Y will be equal to “ |
| | hello daniweb members i have added custom post type in Wordpress that works like slideshow, all slides are clickable and open in products slug. how can i query posts subcategories that match with the slide clicked? code for custom post type is this add_action( 'init', 'products_post_type' ); function products_post_type() { … |
| | Dear sir, Please help me about below query. here is two table sale and purchase. i want product wise result in output table like below picture. please help me  |
The End.