[sql] Forum Topics

Hello I create project based on c# , and i make roles like admin and users , so that i want to give special premission to users to perfom tasks . if anyone know how i can make or write this code , please help me . and in advance …

I want to insert the deleted data into another table (Like table history) in sql server database using visual basic 2008 by scanning QR Code data. What I have done in my source code program is like this; Private Sub btnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDel.Click …

Write a C++ program that asks the user to enter the number of rooms in a house. For each room, the user must be prompted to enter the following details of each room to be stored as attributes of the class Room. • width length colour Declare 'name' as a …

I am trying to come up with an SQL query to return all the records earlier than a certain year with SQLite using DB Browser. I can't seem to come up with the right regex expressipn to use for filtering only the year from a row for comparison, below is …

hi, i have some problem with my php code. when i run the php, the page keep loading and no output displayed. here is my code: $dayBeforeNew = $_GET['daybefore']; $dayAfterNew = $_GET['dayafter']; $sql = "SELECT reference.LOCID, reference.Region, Sitename, (SELECT `Data Total Traffic` from 4g_statistic where reference.LOCID = 4g_statistic.LOCID AND 4g_statistic.Day …

I am using intellij for the java coursework which is related to clients and databases. I am receiving the following error Exception in thread "main" java.lang.NullPointerException: Cannot invoke "java.net.URL.toExternalForm()" because "location" is null at java.desktop/javax.swing.ImageIcon.<init>(ImageIcon.java:232) at client.Interface.$$$setupUI$$$(Interface.java) at client.Interface.<init>(Interface.java:54) at client.Application.main(Application.java:317) This is the code: ` ` package client; //region …

**There are 2 tables as orders$ and 'order items$'** orders$ Table have 4 columns as order_id, customer_id, status, order_date 'order items&' Table have 4 columns as order_id, item_id, product_id, quantity I want to modify the SQL statement to show an average number of products each customer had on their orders. …

How do you print repeated digits from 1 to n after asking a user to enter a int8 number n.The printed digits should be random.say for example a user enters enters n=5 then the program prints randomly 11223412345.You can see the maximum is 5.Also how do you sum up these …

I am using phpmydirectory and am having problems logging in. We had a power outage yesterday and this morning i cannot access my Control Panel. I am just getting teh error message that i have used so many login attempts and when i get to 5 attempts i will need …

So far, we have gotten lots of innovative social media models. I am not too sure if this has already been tried, but I want to innovate on ownership model. Basically, I envision a Reddit that is owned by its mods and users. Maybe a hybrid FB and Reddit. It …

I posted this the other day and by and large people responded with predictable lack of imagination. I will add additional explicit requirements for the prototype stage. I want to create a prototype of a different type of social media - call it "pro social" media. It would be owned …

how to barcode scanner in xamarin.form and connect sql server DataBase

I'm new to this site and still fairlu new to PHP so not sure if this is were I need to place my question but here goes. I am currently trying to create a filter for my table using PHP. The filter options are already in my database; e.g I …

Hi Am new at programming . I ask about how I but button that onclick it's guide me to form this form had submitted page I need to make this form when fellup the data that the user it's sind to my java SQL . Can any one help me …

Do you think that the structured programming is still useful now on day (for developing)?

So i have multiple web pages containing multiple episodes, what I'm trying to implement is a search box in the nav bar which will bring up the episode/category your looking for, nothing too over complicated. If anyone would be willing to point me in the right direction that would be …

c++ sql phyton javascript html

statement: write a code in which user first select what type calculator they want to use. Simple or scientific and on that basis they do the calculations. I have written the following code but it is not running. I am unable to figure out the problem. Please anybody help!! #include …

Display instruction for the respondents to answer the survey using function displayInstruction(). -------------------------------------------------------------------------- |Survey of Student's Perception on Online Learning in Kolej Seri Sarawak | -------------------------------------------------------------------------- Dear Respondents, You are invited to answer this survey. Please respond to the following questions that corresponds to your response. The survey is divided …

$unpaid1="SELECT t.id, t.year, t.property_id, COALESCE(t.amount,0) AS amount FROM tax_amount t WHERE t.status = 'unpaid' ORDER BY t.year"; $resultpropertyunpaid1 = $db->query($unpaid1); while($row = $resultpropertyunpaid1->fetch_assoc()){ $PropertyUnpaid1 = $row['unpaid']; } > When I'm making a new property and put the amount the error will show but after I paid the total amount the …

is having created a webpage using Html and css the page is laidout (has header, side panel, main content area and a footer) as well as (a table of appx 2 by columns and rows); I will create a very small SQL table with data; BUT how do I transfer/export …

Hi I have this PHP Code - <?php require_once ("../include/initialize.php"); if (!isset($_SESSION['ACCOUNT_ID'])){ redirect(web_root."index.php"); } $action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : ''; switch ($action) { case 'add' : doInsert(); break; case 'edit' : doEdit(); break; case 'delete' : doDelete(); break; case 'photos' : doupdateimage(); break; case 'checkid' …

Hello. I want to start studying the Golang language but I can't find any IDE that I can configure well, can you tell me an IDE that is good for Go and how to configure it (explained for fools in Spanish), please? I have tried with Sublime, Visual Studio Code …

Parse error: syntax error, unexpected variable "$sql" in C:\xampp\htdocs\ProjectIT12\LR\controller.php on line 38 <?php include_once ("connection.php"); // connection created succesfullly session_start(); //store all erros $errors=[]; //When sign up button clicked if(isset($_POST['signup'])){ $fname = mysqli_real_escape_string($conn , $_POST['fname']); $mname = mysqli_real_escape_string($conn , $_POST['mname']); $lname = mysqli_real_escape_string($conn , $_POST['lname']); $street = mysqli_real_escape_string($conn , $_POST['street']); …

if (count($_FILES) > 0) { if (is_uploaded_file($_FILES['userImage']['tmp_name'])) { $imgData = addslashes(file_get_contents($_FILES['userImage']['tmp_name'])); $imageProperties = getimageSize($_FILES['userImage']['tmp_name']); $sql = "INSERT INTO trial (imageType ,imageData,uploaded_on, user_id,tax_payer_id) VALUES('{$imageProperties['mime']}', '{$imgData}',NOW(),'".$_SESSION['id']."','".$_GET['id']."')"; $current_id = mysqli_query($db, $sql) or die("<b>Error:</b> Problem on Image Insert<br/>" . mysqli_error($db)); $current_id = mysqli_insert_id($db); if (isset($current_id)) { echo "Upload Succesfully"; }else{ echo "There is a …

Is it necessary to have computer or laptop to test the code? Did you ever seen anyone who can be perfect or master in coding whit cell phone?

<?php if (count($_FILES) > 0) { if (is_uploaded_file($_FILES['userImage']['tmp_name'])) { $imgData = addslashes(file_get_contents($_FILES['userImage']['tmp_name'])); $imageProperties = getimageSize($_FILES['userImage']['tmp_name']); $sql = "INSERT INTO qr(user_id,file_name ,QrCode) VALUES('".$_SESSION['id']."','{$imageProperties['mime']}', '{$imgData}')"; $current_id = mysqli_query($db, $sql) or die("<b>Error:</b> Problem on Image Insert<br/>" . mysqli_error($db)); if (isset($current_id)) { header("Location: preview.php"); } } } ?> <form name="frmImage" enctype="multipart/form-data" action="" method="post" class="frmImageUpload"> …

Do you think blockchain will replace the traditional database

<?php if(isset($_SESSION['id']) ) { ($_SESSION['id']) { //echo "you're login"; } echo "<form action='upload.php' enctype='multipart/form-data' method='post'> <br>Qr Code: <p><input type='file' name='file' > <p><input type='submit' value='Upload' name='submit'> </form>"; } ?> <?php $statusMsg = ''; // File upload path $targetDir = "qr_code/"; $fileName = basename($_FILES["file"]["name"]); $targetFilePath = $targetDir . $fileName; $fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION); …