[table] Forum Topics

Write PHP Script to insert data into STUDENT TABLE with fields (roll,first_name,Last_name,city,contact,gender).

Hello, I want to use the checkbox to update the status of a row in mysql using php. If it is checked and submitted, the status will change from 'collect' to 'received'. I tried many ways but I am not sure where the problem is :( please help! <?php include(config.php); …

Hi everyone here, I'm trying to show information about the material according to the year of meeting(is a meeting when they decide to buy a new material) so I use a drop-down list and the information will show according to the year chosen by the user, but it shows the …

Hey , I am a begginer in vb.net and I want to retrieve my data from access database as well as manipulate indivial record according to my choice..Can you help me with this Thanks & Regards

Create database with the name of "university". You have only two table with the name of "signup" and "student". In Student table you will collect all data of student like cms, name, address ,age, mob and cnic. Perform Multiple Task which are given below. 1) Create Login and Signup page …

I want to this project for a few days, so execusem send for a short in the time.

Hello, As the title says, my question is: how I can get the values for specific ID? For example, my plugin creates a PDF that automatically fills in with information that I get using API from my CRM platform. So, what I am trying to do now, is that in …

i want to store 2 column value in multi rows like if i paste a value in textarea like (12.50,25.100,5.30,78.500,98.2000) and this value insert in my table with 2 column like col1 col2 12 50 25 100 05 30 78 500 98 2000 so sir can you please help

Hello, Hope all doing well, I'm very new to this coding and this place. Was preparing for the questions from this [source](https://www.interviewbit.com/html-interview-questions/) . Just had a query is there are any other ways you can display HTML elements? Q No - 23 TIA!!

I have a database where there is an table `wm` for water meters : +------+---------------+ | Code | name | +------+---------------+ | wm1 | water meter 1 | | wm2 | water meter 2 | | wm3 | water meter 3 | +------+---------------+ and another table c`ounters` where there are …

I am attempting to update my accounts table for the current session ID with the data posted from a form. My first prepare statement is functioning fine and can be seen functioning through the placeholder variables in the form. It is my second prepare statement that doesnt seem to be …

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 …

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?

Hello guys, I am using a Bootstrap grid with 6 element (As articles). 5 come directly from the database, and I need to add one more article element at the beginning, just for aesthetics. This is what I have so far. Any help is welcome. Thank you! Here's the idea …

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 …

I have 5 items listed within a 200x200 box, and would like for the details of the clicked item to appear as either an overlay that spans only that box or as a div that completely replaces the original 5 options. Kinda like an accordion menu, but with the nav …

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 

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 …

<?php include "database.php";?> <?php session_start();?> <?php // Getting total rows there in table $query="SELECT * FROM questions"; $results=$mysqli->query($query) or die($mysqli->error.__LINE__); $total=$results->num_rows; $row=$results->fetch_assoc(); //Reading the rows next by next and vice versa $offset=$row["question_number"]; // when button next is clicked it will fetch the next row if(isset($_POST["NEXT"])){ $offset++; } // if previous …

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 **"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 want to make this table with HTML and CSS but somehow the image cant appear in the browser... Can you help me? https://prnt.sc/rmo2xl .box-border { display: inline-block; border: 1px solid; height: 80px; width: 100%; } .image-position { display: inline-block; } <div class="box-border"> <div class="image-position"> <img src="igniteLogoImage.png" alt="asdasd" width="42" height="42"> …

Hi. im developing a loan processing system using mvc c# asp.net. One of the requirements of the system is to perform a credit history check on the customer applying for a loan. so this is how it works: -the customer applies for a loan. the customers id number gets stored …

I need a simple external table definition for preforming loads from FIXED WIDTH files. I don't remember how to do External tables in oracle. This would be a Fixed width, not CSV. I am creating a generator and I need the external table definition.

problem How to make row that have different value with color red font to full row ? I have html dynamic table not static meaning i dont know how many rows or column inside table because it changed based on data show from back end . I need to give …

I'm using phpMyAdmin to manage my databases, I have 2 projects that use 2 different database the first one uses 'root'@'localhost' and the 2nd is 'root'@'127.0.0.1' I don't know how i ended up using 2 different server but it was working fine until i tried to edit codes with the …

Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key …

This is a partial of the code I have on my script. I have tried to make the backgrounds change color depending on the values and can't get it to read the arrays correct. Placing the conditions outside the while or inside the while returns same results when printed. If …

after i key-in the form, the function change the whole column with the same value for example if i put first name JOHN it will update whole column with JOHN <?php session_start(); require_once("connection.php"); if (isset($_POST['edit'])) { session_start(); $s=mysqli_query($con,"UPDATE user SET first_name ='" . $_POST['first_name'] . "'"); $row = mysqli_fetch_assoc($s); if …

Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel …