Member Avatar
Hello i have a question about the security of my website, does my website can get hacked somehow if im updating it directly from my database? (ex. images, posts, links...). I have few pages on my website which have PHP code to read info from the database and i do …
by Stefan_1 -3 in Web Development ()
Member Avatar
Hi, i'm trying to enable users to upload to my db. at the moment i've just got a folder called 'uploads' in my root directory... (i'll worry about getting them into the db once i can uplaod to there!) here's my php... <?php $target_dir = "http://www.XXXXXX.com/uploads/"; $target_file = $target_dir . …
by Andy_10 in Web Development ()
Member Avatar
Hello, I am trying to save the date field into mysql table. The date field in my jsp form is in format MM/DD/YYY and in database as YYYY/MM/DD. How can I retrieve the date from form and insert into the table with YYYY/MM/DD format ?
by Sushmitha_1 in Web Development ()
Member Avatar
hi all , Am doing event management project. In jsp page am using javascript date picker. Then i passed that to servlet page by the following code. DateFormat formatter ; formatter = new SimpleDateFormat("dd-MM-yyyy"); Date date=formatter.parse(request.getParameter("date")); now I want to insert date in mysql database , How can I achieve …
by anand01 in Web Development ()
Member Avatar
Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))
by Drew-Shawn in Databases ()
Member Avatar
My Error info isnt being clear enough for me to understand the problemIs there anything worng here so i can continue on lookng for the probelm: $sql = "INSERT INTO boards ( title, genre, creator, tagline, intro, remessage, visability, recruitment, reqsheet, reqdice, reqgroup, ppweek) VALUES ( $title, $genre, $creator, ". …
by CreatorZeus in Web Development ()
Member Avatar
Hello, I have two tables in mysql using php> 1) Consumers 2) Monthly Billing In Consumers that table contains about 100s of Consumers , and it increase monthly. 2) Monthly Billing for Billing. What i want to do ? Is there are any way that i can generate monthly billing …
by spluskhan -2 in Web Development ()
Member Avatar
Dear Developers, This is the part of my blog.While adding new post to my blog the category option not updating to database add_post.php <h2>Add Post</h2> <?php //if form has been submitted process it if(isset($_POST['submit'])){ $_POST = array_map( 'stripslashes', $_POST ); //collect form data extract($_POST); //very basic validation if($postTitle ==''){ $error[] …
by Faisal_13 in Web Development ()
Member Avatar
Hi. I have tried to save the Json data retrieved below in vain. When I connect the database and try to insert the post data, the script no longer retrieves or decodes the data. When I leave it, the API tells me the data was reconciled or decoded. How can …
by Eddy_1 in Web Development ()
Member Avatar
How can I convert (move) individual HTML webpages in bulk into mysql forum? What I have is just the 1000s of html pages which consist of question and answers. Now how can I move then into into mysql forum. This is how my question/answer html pages looks like this:- drive.google.com/file/d/0B4RFn3PmjNy9YTNkbE5mejBfV1U/view?usp=sharing …
by Mani_7 in Web Development ()
Member Avatar
I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. I used Form1 to add data to database using OLeDb command and used Form2 to show data in datagridview by using dataset I used following code: FFORM1 CODE is as following [code] Private …
by jazzyb in Software Development ()
Member Avatar
Dear all I am a beginner in web development. Please help to resolve the below problem. Right now I am creating a Workers Directory with sql database. This is including worker name, Location, Work and mobile numbers. > When customer select the specific job we need to filter particular job …
by Faisal_13 in Web Development ()
Member Avatar
Dear devolepers, I have problem with my sql database, I want acces my sql database in my <LI> list plaese help to resolve this problem Here is my html sql database : my_db table : info_list Table columns : id,name,job,town,mobile1,mobile2,phone,adress i want to display town list in this <li> list …
by Faisal_13 in Web Development ()
Member Avatar
Hello. I am new to PHP/MYSQL. My array looks like this: Array ( [1] => item1 [2] => 1tem2 [3] => item3 [4] => item4 [5] => item5 [6] => item6 ) Array ( [7] => item1 [8] => item2 ) Array ( [9] => item1 [10] => 1tem2 [11] …
by Gurjit_2 in Web Development ()
Member Avatar
Dear developers How to show contact details while clicking the particular name from <li> list Contact_list.php <?php $con=mysqli_connect("localhost","user","pass","nilambu1_mydb"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM n_info "); while($row = mysqli_fetch_array($result)) { echo "<li><a href='contact.php' data-transition='slidedown'> <img …
by Faisal_13 in Web Development ()
Member Avatar
Hi! Having a hard time figuring out how to solve this problem at hand. basically i have several tables that are inter connected in some manners but i need to full all this data and format it in a manner that it will show the total number of trips and …
by skullscript in Web Development ()
Member Avatar
Hello, i am a new php and html developer. kindly assist me for my querys thanks in advance raj
by Raj_18 in Web Development ()
Member Avatar
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …
by Oxley_1 in Databases ()
Member Avatar
Customers pick When finished If on the book, such as the selection of Van Dyke VT01 from 1/07/59 - 2/07/59-day period, you will not be able to book your car again. It is based on the availability of the vehicle. I made a separate table Storage booking Van table separately …
by Goddy_1 in Web Development ()
Member Avatar
Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …
by doncwilson_1 16 in Databases ()
Member Avatar
sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …
by _1_36 in Databases ()
Member Avatar
I am working on projects in Visual Studio 2015 using the ASP.Net Identity with Entity framework. Entity Framework creates tables in embedded SQL Compact, when the first user is created. My question is: When comes time to roll out into a "live" environment (i.e. Dev, Test or Prod), is there …
by Greg_10 in Web Development ()
Member Avatar
How to retrieve data from another database using PHP, mySQL?
by AntonyRayan 15 in Web Development ()
Member Avatar
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …
by cereal 1,078 in Databases ()
Member Avatar
Hello, I almost forget. Last time someone recommend me a software that I could use repeatedly for sql database management that real web developer must have in exchange of the free one like xampp that often shows error. Can anyone help me fix this error? Thanks in advance, Davy
by davy_yg 16 in Web Development ()
Member Avatar
Hi Guys, I'm new to vb.net programming. I'm finding it really hard printing selected columns in a datagridview. there are 12 columns and i would like to print just a few in a landscape view. Please, can someone help me.
by Daniel_57 in Databases ()
Member Avatar
$stmt = $dbconn->prepare("SELECT * FROM `members` WHERE username=? AND password=?"); $stmt->bind_param("ss", $username, $password); Is what I have. Database is connected etc. How can I set variable called `$dbresult` with array of SQL result? I don't want to set individual variables. I really need an entire array as answer. There's couple …
by Aeonix 39 in Web Development ()
Member Avatar
i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …
by xuexue 15 in Databases ()
Member Avatar
I'm sure I've mentioned this type of wrapper class for accessing databases in a provider-agnostic manner before, but never posted a functional implementation. So here it is. Questions, comments, and suggestions are welcome as always. :)
by deceptikon 1,711 in Software Development ()
Member Avatar
Hey new to JDBC SQL DERBY and Java so I don't know why but my Jtable only shows the columns. Here are my codes for my LeaderboardDAO class. public class LeaderboardDAO extends Dao { private static final Logger LOG = LogManager.getLogger(PlayerDAO.class); public static final String TABLE_NAME = "leaderboard"; private static …
by Ronnie_2 in Software Development ()