6,934 Topics
 | |
| | I am trying to get user's information and show them in user's profile. And i found this query but it is in PDO and my work is in sqli here the query : if(isset($_SESSION['user'])){ $getuser=$con->prepare("SELECT * From users where username=?"); $getuser->execute(array($sessionuser)); Sinfo=$getuser->fetch(); And here the whole code <?php session_start(); $sessionuser=''; … |
| | I have a project where I need users to be able to save their work, then at a later date select the session/data from their previous work and continue. I have completed all of the coding (and it works) to save the current session under their userid, and populates a …  |
| | <?php error_reporting(0); require 'conn.php'; global $conn; $tablename = $_SESSION['user_id']."_LIETOTAJU_ATIBLDES"; $sql = "CREATE TABLE ".$tablename." ( id INT NOT NULL AUTO_INCREMENT, ATBILDE varchar(255), PATIES varchar(255), PRIMARY KEY (id) )"; if (mysqli_query($conn, $sql)) { } else { } $val = $_GET['QUESTONS']; mysqli_set_charset($conn,"utf8"); $sql = "SELECT * FROM Jautajumi_Prof where TEMAS_NOSAUKUMS = ? … |
| | i want to know how to create qr cde in php |
| | hello, i have a probelm where i want to update my image in database using unlink(). The error is **Warning: unlink(images/481933.jpg): No such file or directory**. I try search the solution but nothing can solve my probelm. anyone can help me? thank you in advanced. this is my code: $upload_dir='images/'; …  |
| | 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 …  |
| | Hi everyone! Do you know how to create Pizzeria Program using Python and PostgreSQL where it can keep track of the pizza orders and view the order information using Python and PostgreSQL? Technology needed: -Django for the program -Postgresql for database How it can be used: Every time there is …  |
 | // 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 |
 | Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by ID: My idea is: oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; but it does not … |
 | Hlo Plz anyone give a coading of classic asp i want to save my csv and excel file in databse |
| | 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 … |
 | Hello to all, I am trying to execute a mysql query for selecting * rows from the table where user name = [one of the usernames stored in an array]. Ok. Sorry if I am not clear. Now I have an array naming $users[]. I want to select all the …  |
| | 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 …  |
| | Hello, I'm new here and I have experience in using PHP with MySQL but right now, I need to convert my code so that it can be used to connect to my DB in my SQL server. I have try out the code as follows db.php <?php date_default_timezone_set ("Asia/Kuala_Lumpur"); // … |
 | 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? |
| | I've just started working with PHP and MySQL, and I'm trying to create a table in MySQL. If I've got this right, I'm trying to do so by going to my host's SQL MyAdmin page and typing in mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), … |
| | I have Apache2, php 7.2, and mysql installed. At the top of my index.php I have the following script: <?php session_start(); // start of script every time. // setup a path for all of your canned php scripts $php_scripts = '/home/larry/web/test/php/'; // a folder above the web accessible tree // …  |
 | I have created a table in a mySQL DB where users are going to a form and entering ratings on 6 Categories (5 Specific and 1 Overall) for a particular item_id. On the item table, I have a column that calculates the total number of ratings this particular item_id has … |
 | I Have **"user_chat"** table name his 4 columns "msg_id" Auto Increament "chat_from_id" "chat_to_id" "chat_msgs" SELECT `chat_msgs` from `user_chat` where chat_from_id='2'AND chat_to_id='10' LIMIT 0,10 Also I have used **DESC** using above queary but not worked I want to fetch last **5 recent records** from **"chat_msgs" columns** Suggest me. Thank you |
| | I have the following two tables: TABLE 1: +-----------------------------+--------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+--------------------------------------+------+-----+---------+-------+ | patient_id | bigint(20) | NO | PRI | NULL | | | patient_wpid | int(11) | NO | PRI | NULL | | | age_at_visit | … |
| | to make our project finish, i need to get the data from the user who just log in(only his/her data) but i dont have any idea how, can someone help me...thank you very much! well appreaciated :) so this is the part where i need to add something so i … |
| | $sql="SELECT * FROM `customer_information_table` WHERE `email`='{email}'"; $result = $db->query($sql); if($db->error) { exit("SQL error. <a href = './register.php'>return</a>"); } if($result->num_rows!==0) { exit("email address already exists. <a href = './register.php'>return</a>"); } |
The End.