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 a lot of people are going to my website, like more than 20 people in a day, but here is the question or discussion? how and where do I begin learn about databases, I don't really care what language I am going to use, like sql or php, is sql …

Member Avatar
Member Avatar
+0 forum 5

I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing. BOOM, every database I had there - gone! GRR! Dang! - Fortunately I was proactive and copied all of the previously ( the DB dir Mamp ). The internet tells me to simply put them back in the dir and restart - which I do.... Now PhpMyAdmin "sees" the DB's but does not have index's for any of them …

Member Avatar
Member Avatar
+0 forum 7

Hi all, How to store data in two different tables when we click the button. Suppose I have a 2 tables named as team1 and team2. In table team1 have 2 fields teamid,teamname In table team2 have 3 fields team2id,team2name,teamid here teamid is foreign key. So when i click on insert button all the data will be inserted to respective tables i need jsp and oracle codes i dont know any idea of this how to do that task can you please help me any one its arjent for me please . Thanks

Member Avatar
+0 forum 0

Hello! I have a question and I don’t know whether the title is actually descriptive. For some background on the matter, we use Sage 50 as our merchandise information system and for our reporting and controlling tools we run Access queries. Since our database had been reset at some point I am missing some history data. I need to find the creation date for each article. But the only query covering the whole period since the beginning will return a table like that: `PK | ART | DATE` `3262 | 000 | 17.05.2013` `3262 | 000 | 23.01.2019` `3150 | …

Member Avatar
Member Avatar
+0 forum 5

Hi, I have a form which consists a dynamic dependent dropdown and I want to maintain the entered data into the fields after the form is saved or edited. For an example: <input type="text" name="serial" value="<?php echo $serial;?>"> Similary i need to get the value in my dropdown as well. Hope there is a solution for this. Below is my code. ## ajax.js ## $(document).ready(function() { $("#brand").change(function() { var Brand_ID = $(this).val(); if(Brand_ID != "") { $.ajax({ url:"SR.php", data:{b_id:Brand_ID}, type:'POST', success:function(response) { var resp = $.trim(response); $("#model").html(resp); } }); } else { $("#model").html("<option value=''>----Select Model----</option>"); } }); }); ## Dropdown …

Member Avatar
Member Avatar
+0 forum 2

I have storing major data in mysql and logs are stored in cassandra. Cassandra db getting heavier and difficult to do queries. So I want to migrate all my cassandra's table in mysql is it possible?

Member Avatar
Member Avatar
+0 forum 2

Hlo Plz anyone give a coading of classic asp i want to save my csv and excel file in databse

Member Avatar
+0 forum 0

In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and holidays (which I'll show in code snippet), then it shows about like that: +--------+---------+---------+-------------+---------+----------+----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE |LEAVE TIME| +--------+---------+---------+---------+------------+-----------+----------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 |838:59:59 | +--------+---------+---------+----------------------+-----------+----------+ Which time 838:59:59 is about... 35 days. I have a trouble with it. Is that possible to calculate …

Member Avatar
Member Avatar
+0 forum 1

Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the keyword 'FROM'." It's not clear to me what the error is. The code I've written is as follows: Dim strQ As String = String.Empty Dim datasource As String = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Don\Documents\Visual Studio 2019\SalesForm\DWHRPT.mdf;Integrated Security=True" conn = New SqlConnection(datasource) Dim searchID As String = tbxCompanyName.Text strQ = "SEARCH CUST_ACCT_NO, CUST_COMPANY_NAME, CUST_FIRST_NAME, CUST_MIDDLE_INITIAL, CUST_LAST_NAME FROM CUSTREC WHERE CUST_COMPANY_NAME LIKE '" & searchID & "%'" cmd = New SqlCommand(strQ, conn) da = New …

Member Avatar
Member Avatar
+1 forum 5

Please, why I got this error(SQL Error: ORA-00907: missing right parenthesis ) whats wrong in my code? CREATE TABLE DomeniuAB(ID_DOMAB NUMBER(10) constraint ID_DOMAB_PK PRIMARY KEY , DENUMIRE VARCHAR2(20) NOT NULL, DETALII VARCHAR2(20) NOT NULL, ISBNAB_CarteAB VARCHAR2(15), CONSTRAINT ISBNAB_FK FOREIGN KEY (ISBNAB_CarteAB) REFERENCES CarteAB(ISBNAB), CNPAB_AutorAB NUMBER(10), CONSTRAINT CNPAB_FK FOREING KEY (CNPAB_AutorAB) REFERENCES AutorAB(CNPAB));

Member Avatar
Member Avatar
+0 forum 3

Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record FAILED. Please contact your systems administrator." From the code below, do you see where my error may be? What corrections do I need to make to ensure a successful insert? Dim con As New SqlClient.SqlConnection con.ConnectionString = ("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Don\Documents\Visual Studio 2019\SalesForm\DWHRPT.mdf;Integrated Security=True") con.Open() Dim com As New SqlClient.SqlCommand("", con) com.CommandText = "INSERT INTO CUSTREC (CUST_ACCT_NO, CUST_COMPANY_NAME, CUST_LOCATION, CUST_TYPE, CUST_FIRST_NAME, CUST_MIDDLE_INITIAL, CUST_LAST_NAME, CUST_MAIL_ADDRESS1, CUST_MAIL_ADDRESS2, CUST_MAIL_CITY, CUST_MAIL_STATE, CUST_MAIL_ZIP_CODE, CUST_MAIL_ZIP_PLUS4, CUST_CREDIT_LIMIT, CUST_PRIMARY_PHONE, CUST_ALT_PHONE, …

Member Avatar
Member Avatar
+0 forum 4

Hi, I want to make online shop and I made most of it but I have problem on product page.I want for "customers" ( this is my personal project so ... ) to be able to choese and then what they choese to be store into table. I struggling with this more then 3 hour , I try everyhing , this is my last shoot. (I used the echo because I want to show it , so after that I would put insert into, but ... I was not able to do it ) <?php $con = mysqli_connect("localhost","root","","basic"); $query = …

Member Avatar
Member Avatar
+0 forum 1

hello every one please can any body do this task for me please becouse our instructor in the university uploaded it and I dont have enough time becouse im studying for my final exams please any one and i will be helpfull for him/her :) this is the task Create a car rental system where customers rent cars for a given period of time. Car – a class for all cars. Holds car information and an array of rents. Implement several types of cars as subclasses: Small car – 4 passengers, Motor 1200, air-conditioner Medium car – 4 passengers, Motor …

Member Avatar
Member Avatar
+0 forum 2

I'm writing stored procedure with dynamic sql having dynamic table name as, CREATE OR replace PROCEDURE Pr_get_result (p_table_name IN VARCHAR2, p_object_Id IN VARCHAR2) IS p_prop_code VARCHAR2(50) := 'pH'; BEGIN EXECUTE IMMEDIATE 'DECLARE ' || ' TYPE ObjCurTyp IS REF CURSOR; ' || ' v_obj_cursor ObjCurTyp; ' || ' v_stmt_str VARCHAR2(32000); ' || ' v_obj_record ' || p_table_name || '%rowtype; '|| 'BEGIN ' || ' v_stmt_str := ''SELECT * FROM ( SELECT * FROM '|| p_table_name ||' where CREATED_DATE<= ( SELECT CREATED_DATE FROM '|| p_table_name ||' WHERE object_id='|| p_object_Id ||' AND PROPERTY_CODE='|| p_prop_code || ' ) Order By CREATED_DATE DESC ) …

Member Avatar
Member Avatar
+0 forum 1

Which SQL data types can be used in SAP HANA?

Member Avatar
Member Avatar
-1 forum 1

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\Users\USER\Desktop\Final Year Project\XAMPP\htdocs\littleavenue\shop.php on line 320 <?PHP if(!isset($_GET['product_category'])){ if(!isset($_GET['category'])){ $per_page = 6; if(isset($_GET['page'])){ $page = $_GET['page']; } else { $page = 1; } $startfrom = ($page-1) * $per_page; $getproducts = " SELECT * FROM products OREDR BY 1 DESC LIMIT $startfrom, $per_page"; $runproducts = mysqli_query($connection,$getproducts); ////LINE 320 //// while($row = mysqli_fetch_array($runproducts)){ ////LINE 320//// $productid = $row['product_id']; $producttitle = $row['product_title']; $productprice = $row['product_price']; $productimgone = $row['product_img1']; echo "<div class='col-md-4 col-sm-6 center-responsive' > <div class='product' > <a href='productdetails.php?product_id=$productid' > <img src='admin/product_images/$proproductimgone' class='img-responsive' > </a> <div class='text'> <h3><a href='productdetails.php?product_id=$productid'>$producttitle</a></h3> <p class='price'>$ $productprice</p> …

Member Avatar
Member Avatar
+0 forum 1

Hi group, I'm attempting to write code to check to see if an existing account number exists. The user is to input a 10 digit account number. The code then is to query the database to see if that number exists. If it does, the message box displays the message that the number exists. However the code I've written isn't working as I wish. Can you offer some suggestions as to how to do this correctly? Here's what I've attempted: Private Sub tbxAccountNo_TextChanged(sender As Object, e As EventArgs) Handles tbxAccountNo.TextChanged If GlobalVariables.custpnl1 = 2 And tbxAccountNo.Text.Length = 10 And IsNumeric(tbxAccountNo.Text) …

Member Avatar
Member Avatar
+0 forum 2

Hi, I want to display the avearage row as images. Is it possible? function reviews_average(){ $avgproduct_id = escape_string($_GET['id']); $avgquery = "SELECT avg(rating) as average_rating FROM reviews WHERE product_id = $avgproduct_id"; $avgresults = query($avgquery); confirm_query($avgquery); while($row = fetch_array($avgresults)){ $avgratings = **--THIS IS THE ONE I WANT TO DISPLAY AS IMAGES--** "{$row['average_rating']}"; echo $avgratings; } } This is the image `<img src='../public/images/star.png' height='20px' width='20px'/>`

Member Avatar
Member Avatar
+0 forum 2

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Member Avatar
+0 forum 0

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Member Avatar
+0 forum 0

can we able to count how many number of resultset is returned by a stored procedure? i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters. so i need to count how many resultsets are returned by the sp

Member Avatar
+0 forum 0

I have a table where I want to update "time 2" row, in the user's last "time 1" entry. I was try this, but not function. UPDATE `temp` SET `time2`=NOW() WHERE user = 'kraso' (SELECT max(time1) FROM 'temp')

Member Avatar
Member Avatar
+0 forum 5

Guys, do you know if I can use SQL in Mobirise? As it's a pain to set all coming mail to separate file manually out of Mobirise's forms. I'm not sure that it's possible to bring any changes to the code of the forms at all. Thanks

Member Avatar
Member Avatar
+0 forum 1

I need to create a database from the messages, coming from the Mobirise website builder's forms. What code should I use? This doesn't work. Could you please help me. $link = mysqli_connect('localhost', 'root', 'password'); if (!$link) { $output = 'Unable to connect to the database server.'; include 'output.html.php'; exit(); }

Member Avatar
+0 forum 0

Hello everyone , I have find i script made in 2013 that use Mysql , Today the mysql has removed and remplaced by Mysqli or PDO Can any one help me please to convert the mysql code to mysqli Exemple : <?php $num_queries = 0; $total_time = 0; class ADO { function ADO($host,$user,$password,$database) { $this->connection=mysql_connect($host,$user,$password); if(!$this->connection) { echo "<br>Database Error!!!<br>".mysql_error(); } mysql_select_db($database); } function exec($sql) { // echo "<br />".$sql; //exit; // global $num_queries; // global $total_time; // $num_queries++; // $start_time = microtime(true); // echo "<br />".$num_queries." ".$sql; $result=mysql_query($sql,$this->connection) ; if(!$result) echo "<p>ERROR::".mysql_error()."<br><strong>".$sql."</strong></p>"; // $time_taken = round(microtime(true) - $start_time, 4 …

Member Avatar
Member Avatar
+0 forum 1

Hi, How can i make query for this: Table1 Column1 Column2 LS11111 0 LS22222 100 LS33333 10 LS44444 0 LS55555 25 Table2 Column1 Column3 LS11111 100 LS22222 80 LS33333 25 Result i need is Column1 Column2 LS11111 100 LS22222 100 LS33333 25 LS44444 0 LS55555 25 Column1 is same on both tables, Column2 is pieces number in table1, and column3 is pieces number in Table2 I need maximum piece numbers. If table2 doesnt exist column1 value then shows table1 column2, and if it exist and is larger than table1 column2 then shows number from table2

Member Avatar
Member Avatar
+0 forum 4

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original data and Result, where Original data is the original data sheet that is the result of the problem I need, when running the access issue, ask you to help me with the problem. http://www.mediafire.com/file/hkkw519bw2k3o9h/baitap_data2.xls/file

Member Avatar
+0 forum 0

How to insert data in sql server 2012 express using php pdo in wamp server 3? What connection string I need to use to connect in the database?

Member Avatar
Member Avatar
+0 forum 1

Hi All, I am building an eCommerce website and I really new to PHP and MYSQL but loving the challenge. On my website I have 9 different categories of products with each page having about 8 items to sell. Rather than duplicating the code from each .php/.html file into a new file and change the SQL query, is it possible to write a script that says when the user clicks on category1 in the navigation bar, show all the products in category1? Hope this makes sense. Thanks in advanced.

Member Avatar
Member Avatar
+2 forum 7

Hello please i have a download webpage which allow users to download mp3 files. I want to display the number of times a user has click the download button and display it on the webpage. The records are in a database and this is my code. This is my download button which will be click to update my record count... <a href="file.php?id=<?php echo $row['song_id']; ?>" class="btn btn-primary"><i class="fa fa-download"></i></a> My database looks like this... song_id song artist filename download xxx xxx xxxx xxxx xxxx I want the count to update the download column anyt time a button is clicked. Any …

Member Avatar
Member Avatar
+0 forum 1

The End.