2,570 Topics
 | |
 | I have two tables. MODELS and AUTOMOBILES. And procedure which export all models with name that user inputs and their price(stored in AUTOMOBILES). create or REPLACE procedure modelzz( VAR_MODEL IN MODELS.NAME_MODEL%TYPE, VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE ) as begin SELECT a.A_PRICE INTO VAR_PRICE FROM AUTOMOBILES a join MODELS m on a.MODELS_ID_MODEL=m.ID_MODEL where … |
 | Hi everyone I'm wanderring if their is any way to create a folder name user id when user upload a img And whenever he or she uploads another img It goes directly to that folder I'm new to php Any help is appreciated |
 | I am having a table with nvarchar feild in which values are entered like 1 4 8 25 I want a sql query to find the missing sequence of number in the above series... Thanks in advance...  |
 | Hi all - also new to PHP/SQL and have a different question on a similar question posted - I need to create a page in php that allows the user to select a date range to and from. Howver, the date stored in the database is unix such as 1494548767 …  |
 | I need a list of all 5160 name Indian cities by district name in xls/csv or sql format. Where can I find them?  |
 | Hello, When I try to import this sql into phpmyadmin I am getting this error message: Query SQL: CREATE TABLE `customers` ( `customerNumber` int(11) NOT NULL, `customerName` varchar(50) NOT NULL, `contactLastName` varchar(50) NOT NULL, `contactFirstName` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `addressLine1` varchar(50) NOT NULL, `addressLine2` varchar(50) DEFAULT NULL, … |
 | **how to automatically sum the scores that is being inputted in the textbox and display to the specific rows of textbox** > this is my code for inputting score while ($students = mysql_fetch_array($result)) { $total = $students['fld_quiz1'] + $students['fld_quiz2'] + $students['fld_quiz3'] + $students['fld_quiz4'] + $students['fld_quiz5']; echo '<tr>'; echo "<td>{$students['id']}<input type='hidden' …  |
 | Hi, I just need to fetch data from data base from search button on search page and get the result displayed on form in searchresult page.... For eg , if someone has signed up using his phone number or email then whe he enters his phone number or email in …  |
| | The second annual Imperva Hacker Intelligence Initiative report, this one entitled [Monitoring Hacker Forums](http://www.imperva.com/docs/HII_Monitoring_Hacker_Forums_2012.pdf), is out and reveals that the threat surfaces being discussed by the hacker community are very different from those that businesses are spending money on defending against attack.  The Imperva research analysed the content …  |
 | hi everyone i need help in my query while user login. <?php $username = $_POST["username"]; $password = $_POST["password"]; $con = oci_connect("user","pswrd","db"); if(! $con) { die('Connection Failed'.oci_error()); } $query = "SELECT username, password FROM users WHERE username=$username"; $stmt = oci_parse($conn, $query); $row = oci_fetch_array($stmt, OCI_NUM);; if($row["username"]==$username && $row["password"]==$password) echo"You are a … |
| | hi everyone hope you all are in good. i have query while login form in php with oracle database..... i want to simple login with database html code: <p> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> Username:<br /><input type="text" name="username" size="10" /><br /> Password:<br /><input type="password" name="password" size="10" /><br /> <input … |
 | hi, Am a newbie in php,i want to set a countdown timer for online quiz in php. when an student login,there wil be a home page and in home page there are two php pages like quiz.php and result.php, So When the studuent selects quiz.php,he will be redirected to quiz.php … |
| | |
| | hi everyone i need help in my query which is that: 1.which country name i selected from my dropdown list 2.when i select any country_name its show more info in new page.php like (this selected name show more information about country_name e.g. its captical, and cities through database in new …  |
 | I am creating a reporting engine, it is kind of novel. **The only question I have is what are some of the wierder scheduling related things you guys have seen for you cyclical computer programs to date**. I am trying to cover as many fringe cases as I can, and … |
| | I am trying to set a record back to null. I was able to change it from null and now I want to change it back to null. For some reason it is not working. This worked perfectly fine: UPDATE members set end_date = "2017-01-18" where player = 1 and … |
| | Is it possible to make a web page that takes up responsibility for backing up a web applications tables(Oracle DB, and perhaps SQL server I am trying to be multi db supportive)? Essentially I want to create a database backup script that is kicked off by pressing a button on … |
 | Hello ! I have a task from my university that bothers me and I definately need some help. I have to create a web app in which i can add locations from the world map by taking the coordinates and make route between two selected locations from the added. Also … |
 | Hi. I'm retrieving a record and populating the data into input fields. there is a column called fld_order_date type timestamp. How do i retrieve the date? i have the usual retrieval: $stmt = $conn->prepare("SELECT * FROM tbl_orders_a154287 WHERE fld_order_id = :oid"); $stmt->bindParam(':oid', $oid, PDO::PARAM_STR); $oid = $_GET['edit']; $stmt->execute(); $editrow = … |
 | Dear all, I have a scenario, where I have a single table with all my users listed in them. Each user also has a field indicating the user they report to. UserID UserDisplayName UserReportsTo ----------- ------------------------------------------------------------ ------------- 8 Anthony Karimi 3 9 naheed kassam 8 1 Administrator 1 3 Ramakrishna … |
 | Dear Friends, i Developed a C# Project with SQL Server Database (Database is not LocalDB) and i want to create a setup file to install on client system havin windows xp 32bit. Please suggest me how to do it ? |
| | So here is my problem laid out as simple as I can put it. I cant combine multiple entities together that have related data but are different (one database table has id number that is shared by database table 2 and table 2 has employee number which is shared with … |
 | hi frinds. hope you are well. as i writte this writting im thinking about a my [site](http://Iraniantranslate.com) .... how can i introduce my site to other people? and how can i popular it in google search? best regards,  |
 | What I'm trying to do is have a login type windows form to take a user name and password then compare these with data in the db then open an admin type form. I've been trying to get this to work for a few days now with no luck, about …  |
 | Hi, I am following a walkthrough of [Entity Framework Code First to a New Database](https://msdn.microsoft.com/en-us/library/jj193542(v=vs.113).aspx) Everything appears to go as expected right through to the end of step 4, where it says "We can now inspect the schema that Code First created." The database shows up under data connections in … |
 | i need to update when user i come on left or right side if colums in table when user come with register then count leftcount 1 , if user come right side then count , in colum rightcount . plz any person can help me? |
 | Hi guys, I'm fairly new to angularjs 2 (I've only used 2) and I have a small application with a form. Currently I'm able to get the form data as an objects and print it to the console.log, onSubmit(form: any):void{ console.log(form); } producing this: Object {author: "Author test", title: "Title … |
 | I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks. |
 | **USE SELECT...WHERE FOR TEXT FIELDS IMPOSSIBLE** I use SELECT search with WHERE fieldsname by VARCHAR imposible. But good use with INT fields. Why's that. Please tell me about it . My code as : <?php mysqli_select_db($connect ,'simple_login'); $sql = 'SELECT * FROM table where username= hai ' ; $retval = … |
| | I had a quick course of database few years ago and I forgot a lot from there. So you can say I'm starting from zero. I will try to explain to you on what I want to do and a picture with what I did so far. We have a … |
The End.