2,735 Topics

Member Avatar for
Member Avatar for rahull.singh098

The term SQL stands for Structured Query Language, it's a programming language that's used to update and communicate with the database. SQL skills are indispensable and are in demand as with the boost in technology, data is piling up. And, In today's world this data has become a necessity for …

Member Avatar for pritaeas
0
89
Member Avatar for jagathg

I want to split my data in 3 partitions training, validation and test: 70% training, 15% validation and 15% test for regression. Python provides a way to do that only for training and testing by cross_validation.train_test_split. Any Ideas?

Member Avatar for rproffitt
0
27
Member Avatar for les_5lesabrams

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 …

Member Avatar for Dani
0
36
Member Avatar for Drake_2
Member Avatar for ms_654

Please I have a problem in vb.net. The problem is this, I have a combobox, cboSearchBy, with four column names (FileNo, Lessee, Location and TFNo). I need a code that when i select any of the four items in the combox then the data under that column in the sql …

Member Avatar for pritaeas
0
60
Member Avatar for Marty_3

It has been a few years since I actually did real coding... well a few years since i had a job for that. Just dumping about 1000 photos from a directory and want to display them. No magic of fancy stuff. Thanks

Member Avatar for Dani
0
42
Member Avatar for Ayna_1

Hi! When I am running this code, the output looks how I expected it to be, but the problem is that I cannot go back to home page whenever I want to. I dont know why but when I tried to go back to home page after visiting the tips …

Member Avatar for rproffitt
0
59
Member Avatar for rosh988

<?php $firstname = $_POST{'firstname'}; $username = $_POST{'username'}; $emailaddress = $_POST{'emailaddress'}; $password = $_POST{'password'}; $contact = $_POST{'contact'}; //Database connection $conn =new mysqli('localhost','root','','registration'); if ($conn->connect_error) { die('connection failed : '.$conn->connect_error) }else{ $stmt = $conn->prepare("insert into users(firstname, username, emailaddress, password, contact) vlaues (?, ?, ?, ?, ?)") $stmt-> bind param("ssssi",$firstname, $username, $emailaddress, $password, …

Member Avatar for Dani
1
33
Member Avatar for Muskan_9

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

Member Avatar for rproffitt
0
33
Member Avatar for HitNSplit

Good day! I am new in vb.net and I want to detect if there is a duplicate of the record that a user will try to add. If the user adds an existing username from the database then it will show an error that the username has already been used. …

Member Avatar for Dani
0
200
Member Avatar for Hafiz_6

<?php if(isset($_POST['submit'])){ $kategori = $_POST['kategori']; $nama = $_POST['nama']; $harga = $_POST['harga']; $deskripsi = $_POST['deskripsi']; $status = $_POST['status']; $filename = $_FILES['gambar']['name']; $tmp_name = $_FILES['gambar']['tmp_name']; $type1 = explode('.', $filename); $type2 = $type1[1]; $newname = 'produk'.time().'.'.$type2; $tipe_diizinkan = array('jpg', 'jpeg', 'png', 'gif'); if(!in_array($type2, $tipe_diizinkan)){ echo '<script>alert("Success")</script>'; }else{ move_uploaded_file($tmp_name, './produk/'.$newname); } } ?> **Error …

Member Avatar for rproffitt
1
247
Member Avatar for domandidomandi

I am new for PHP. I tried to display text box value based on drop down selection. it seems code working. no error display here. But when i change the drop down, text box value shows empty. Even print the data it will display only null. HTML:- <select name="cat" id="cat"> …

0
58
Member Avatar for Phillip_8

Hi guys im using VisualStudio2017 to make a chat program from a youtube video i keep getting an error and wondered if one of you might be able to help me out. Exception thrown: 'System.InvalidOperationException' in MySql.Data.dll The code: Imports System.Security.Cryptography Imports System.IO Imports MySql.Data.MySqlClient Module Con_Add Public usernamefriend As …

Member Avatar for rproffitt
0
292
Member Avatar for Greg_11

I have a fillin form , which has a submit button. In order to get to the fillin form, the user has already been authenticated and a session has been created, and variables have been added to the session. In order to process the information, I have another 'insUpSel.php' file …

Member Avatar for Greg_11
0
238
Member Avatar for johnnysnowman38

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?

Member Avatar for rproffitt
0
442
Member Avatar for Hazyan

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"); // …

Member Avatar for AndreRet
0
424
Member Avatar for nishita_1

please provide me sql query for below output sum query please help me ![93852217_246197733117734_2443195689677619200_n.jpg](/attachments/large/4/5009c5b4125b294842ffd7cf1d839caa.jpg)

Member Avatar for Santanu.Das
0
315
Member Avatar for Lek_Plepi

hi guys i have one issue with apache mod_ssl, not showing on directory i have installed via cmd "dnf install mod_ssl" and i get -> Operation aborted. :( also ssl configuartion is missing from /etc/httpd/conf.d/ssl.conf i have tried to reinstall procedure but without success what is the issue :(

0
10
Member Avatar for mr.matrix251

a) Write MARIE code to: 1. Input a number and store it in X . 2. Y will be equal to “

Member Avatar for rproffitt
0
117
Member Avatar for nishita_1

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 ![22222.jpg](/attachments/large/4/f8a1f4cfc8eaaad4bde70a850826b310.jpg)

Member Avatar for drmrkrch
0
1K
Member Avatar for Barbra_1

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 …

Member Avatar for pritaeas
0
213
Member Avatar for Mike Bishop

I have a nested query that is counting how many invoices have been raised for a customer between a daterange which is working fine EXCEPT..... I am getting null in the Invoice_Count field and I would like to change this to 0. I have tried isnull(SUM(CASE WHEN Inv1.ih_credit = 1 …

Member Avatar for pritaeas
0
188
Member Avatar for MagnusTheRed90

I have to get an instance of Oracle XE running on my laptop. This is so I can test a plsql package I have been working on at my house. Currently out of the job. I seem to remember when I did this the last time I had to configure …

Member Avatar for MagnusTheRed90
0
181
Member Avatar for MagnusTheRed90

I am crafting a code generator for something, and I have encountered some things that I do not know yet. Excuse the scambled eggs in this code, but could you please tell me what a job is, and how to get it to run a stored procedure for me? I …

Member Avatar for pritaeas
0
289
Member Avatar for MagnusTheRed90

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.

0
139
Member Avatar for nimz143

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 …

Member Avatar for Purvi_1
0
302
Member Avatar for misstj555

Hello. I have a quick question. I am making a database as a personal project (I am using Microsoft SQL Server therefore I am using its SQL syntax). All it does is that it keeps track of singing groups and bands, the members in these groups, albums they made, songs …

Member Avatar for Reverend Jim
0
328
Member Avatar for Madhava_2

Hi , i have two jsp forms ,one is student1.jsp and student2.jsp in student1.jsp name ,fathername,mothernames are input fields and student2jsp brothername and sistername's are there one database student(name ,fthername,mothernames,brothername ,istername's) what i want is to store two forms data into onedatabase . is it possible?then how?.

0
166
Member Avatar for Vin vin

So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect …

Member Avatar for damonmoats
0
561
Member Avatar for dongtrien

My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional …

0
205

The End.