2,570 Topics
 | |
| | Please Provide me the sub Query for the below table that the rows must be unique and make sum of it. This is the SQL QUERY THAT I AM USING SELECT Admission_Fee.srno, Stu_Data.clsname, Sum(Stu_Data.adm_fee) AS Gross, Sum(Stu_Data.Final_adm) AS Final, Sum(Balance.Admission) AS Paid FROM ((Stu_Info INNER JOIN Stu_Data ON Stu_Info.Regdno = … |
| | New to this forum and to programming in PHP, so apologies if I miss some detail. I have found some code which does almost everything I need, but I can't figure out how to get the 'selected item' from the results on an secondary page (reading in post) .. this … |
| | Hi, I am new to php and html, so I need some help with a problem: I am trying to make a form where you can select from a dropbox, but thae data from the dropbox should be retrieved from a sql database. If I save the code bellow as … |
| | Hi everyone, can someone please help me and give advice as to which software solution to use for the business process described below: Process description by person : Person1: RECORDING THE SPEECH, CREATING THE VISUALS 1 By using the PowerPoint software, create the background image file by updating the title, … |
| | am using a plugin name - pafe - https://pafe.piotnet.com/ which generates a pdf when someone fills a form. and this plugin use fpdf asset. http://www.fpdf.org/en/script/script92.php but currently, it is not supported Hindi font. right now Hindi not work. how can I use Hindi in the current plugin? plugin author does …  |
| | <?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 …  |
 | I am trying to get the last inserted id to be displayed in alert box. Can anyone help me out. I can echo it out but I want to display the ID in alert box and redirect once the user clicks ok. Thank you so much. I am a new …  |
 | I have a table with the following fields: CREATE TABLE text ( drawing INT NOT NULL, blockID INT NOT NULL, entityID INT NOT NULL, style INT, txt VARCHAR(255) NOT NULL, attrib INT); My csv file contains the data: 19 1CB2 E49 2 CLIENT MODULAR 1C2A 19 1CB3 E4B 2 CLIENT … |
| | Hi there, Not sure if I am in the right place, but I wanted to ask where I can access a csv file for all the streets in Belgium? |
 | Hi there, I've come across an issue while trying to get all the records from a SQL database in java. A bit of necessary introduction here. I'm not using any framework just JDBC and the getAllBooks method is part of a REST call. The failing method is essentially doing this: … |
| | Hi all, I have a question about updating two values in a sql table using a subquery. My database is called books and the below table books too: id title author location_id 11 Tera Netrear 4 14 Disser Bubu 1 15 Tenno Puoio 4 16 Oban Tyrone 5 18 Sisnobi … |
| | Please Help me. I am coding PHP using below code but out put is not perfect. i am also attach output picture below. <?php require_once 'core.php'; include_once("../fpdf182/fpdf.php"); $pdf = new FPDF(); $pdf->AddPage(); $pdf->setFont("Arial","B",16); $orderId = $_POST['orderId']; $sql = "SELECT orders.order_id, orders.order_date, customer.customer_name, customer.customer_mobile, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, …  |
| | Hi Guys, I am new here I found this forum very well managed this is very satisfactory. I am new in affiliate marketing as well and want to create affiliate website and was looking for solution with data API. Could anyone help me in this regard, I found a solution, … |
| | I would like to build a software career and am looking for the best software training institution. Can you please help me to find one? |
| | Hello all! I have an excel file that looks like this: Time of Day Lap Lap Tm Speed 14 - Stoicescu Dan - Regularitate Coupe 9:40:50.835 1 2:47.462 88.763 9:43:37.584 2 2:46.749 89.142 9:46:33.319 3 2:55.735 84.584 9:49:58.901 4 3:25.582 72.304 9:53:13.988 5 3:15.087 76.194 9:55:50.639 6 2:36.651 94.889 9:58:49.884 … |
| | I am a developer who recently started working on my own, and I've come across some projects that I can't handle by myself (mostly in React). What resources would you guys recommend for finding / putting together a team of remote developers to join me on these projects? |
| | 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 …  |
 | How to create a synchronized Online/Offline data application with php/mysql |
| | |
| | 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'm studying SQL with Oracle 11gR2 and I'm trying to write sql query to solve this problem. Q. Assuming that campaign's budget is divided by the number of ADs included in the campaign, show the campaign that contains the AD that consumes the largest amount of budget and the campaign … |
 | 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 have a table in and MSSQL DB that list period and week start dates for any date in a financial year but the page is only display the week numbers and period number none of the dates does any body have any ideas please. <?php $serverName = 'DESKTOP-R7RU80H\SQLEXPRESS'; $connectionInfo=array('Database'=>'WebPortal', … |
| | 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  |
| | my system is savings account system, in which i tried to redirect to another php page with the same user id that i want to manage his/her account yet , when i deposit all of the users have the same fk, here is my code, hope you help me with … |
| | Hi there i need help on how I am supposed to do this ER Diagram based on this question. I need to have entities, attributes, relationships and primary/foreign keys. here is the question You are given the following business scenario. SmartService is a newly setup car repair and servicing workshop … |
 | Is python used for web development? |
The End.