0
votes
1answer
34 views
show data from database in html file
I have a project for school. I have to create a website, connected to a database.
Now, I have a problem with displaying data from my database in/on my webpage.
My database runs/is on a server of my ...
1
vote
5answers
35 views
Most efficient way to change the hash type of a password (md5 to sha1)
I have a system using MD5 to hash passwords from my users and store it into my database.
Now, I'm changing to another system that uses SHA1 (and a unique system SALT, not user-unique) to hash the ...
1
vote
0answers
14 views
WebMatrix 3 not showing MySQL databases
I am new to WebMatrix and MySQL, and I need some assistance with an issue.
I'm trying to code with PHP and MySQL in WebMatrix 3. I am experimenting with scripts in a site file called "Starter PHP ...
0
votes
2answers
34 views
Populating selection based on previous data
I have some PHP/SQL written to populate a selection list with data from a database with the option being populated based on a prior entry in a text box. At the moment i gave it a go but i really don't ...
1
vote
2answers
28 views
Dynamic Forms—Proper way to Setup Database?
A client for which I'm working on a web app needs various applications for some services they offer. They'd like to be able to manage/create these applications themselves. I'm having trouble figuring ...
-3
votes
2answers
32 views
Retrieve value database
Is it possible to retrieve a value from a database and use it as a value in the current form? For example i have a form with a field "family" which is a text box and is it possible to populate that ...
0
votes
0answers
33 views
mysql php code to mssql php code
Currently I have this form set up on my server submitting data to mysql, everything works perfectly and functions correctly. I used visual form builder to do this. More info on that here.. ...
0
votes
1answer
79 views
Why won't my PHP MySQLi Query insert to Database?
PHP Version: 5.4.3
MySQLi Version: 5.5.24
I've been staring at this code for a few days now, fixed a lot of minor errors and still can't figure out why it won't successfully add to my database.
...
0
votes
1answer
34 views
Datatables with SQL Server Database
So I am struggling to connect my SQL Server dsatabase to Datatables. I am using the .php code from here: http://www.datatables.net/development/server-side/php_mssql_odbc . However, I am getting the ...
-7
votes
3answers
47 views
How to save image in database using mysql and php [closed]
Hi guys is there any way to save image in database using mysql and php.
I dont want to save it in file system.
If you know can u plz give me reference for that code. or simple explanation about it
0
votes
3answers
36 views
Loading of products to shop from more databases, how?
I need advice.
I have multiple vendors to shop and everyone has a different structure of the tables, so I thought for each vendor to create a new database, but I have a little trouble reading the DB ...
1
vote
1answer
24 views
Call from Database to display the questions and answers
I have been wanting to display the questions and answer as from the database and display them like a normal questionnaire.
However, I am only able to display the last row. Any changes of the codes ...
-1
votes
0answers
30 views
Learning multiple languages/core competencies simulatenously [closed]
I'm planning on studying independently each of the following:
C, as a first 'real' programming language. I attempted Python and BASIC many many years ago and fell out of it, but I'm still familiar ...
0
votes
1answer
25 views
MySQL taking two values, getting a new value and sorting by it
I have two columns in MySQL table (x and y). What I want to do is to subtract x from y making it z and then sort the resultset by z.
Sample data:
| ID | NAME | X | Y |
...
0
votes
1answer
36 views
Error when calling the same function more than once
I wrote a php function which should return the Highest Primary Key value. It works fine when i call the function once but i get error when I call it twice.
Following is my output:
0 //Correct answer ...
1
vote
1answer
27 views
Big amounts of data in Amazon RDS
Currently I'm trying to store a big amount of e-mails (100M+) in mysql in Amazon RDS. I've made a seperate emails_bodies table but it's getting way to big.
With around 40k e-mails the table size just ...
-2
votes
1answer
35 views
PHP Delete button giving error but worked in other example [closed]
I followed this question to do a delete query PHP: Delete button for each table row
But I am having an issued with mine, this is the code for the main page http://pastebin.com/PEQAUJwF and this is ...
0
votes
5answers
29 views
Inserting data to table (mysqli insert)
I've been looking at this code for a while now and I cant see where the problem is... been reading the whole stackoverflow and still cant see where my error is.
<?php
...
0
votes
1answer
37 views
MySQL/PHP How do I set up and fill a relational database to insert a couple of rows at a time?
So I have a page website where a HQ user can fill out a form to give details about one of its 25 locations around the country (called Units). There is also a page where they HQ user can fill out a ...
1
vote
1answer
60 views
Search through database doesn't work
Anyone can help me...
I want to search by name or agreementNum but it doesnt work, it only search by name
mysql_select_db("aruba", $con);
$a1=$_POST['u_Name'];
$a2=$_POST['u_Agreement'];
$sql=" ...
0
votes
1answer
18 views
Cakephp HasOne() table relationship not working
Well, I dont see anything wrong with the code and with the tables but im having trouble displaying the data i need.
given that the tables are already created and populated, here's what i got:
class ...
-1
votes
0answers
34 views
Best Way to Store/Replace data in Database [closed]
My questions is fairly general.
I have an application I'm writing (in php) that will have several different parts, each which have layers to them, that I need to store in a database (Mysql as per ...
-6
votes
1answer
50 views
How to build a real time Application? [closed]
I don't know it is the right place to ask this question, I need some to which language is best for server side and which language is good for client side ,How can implement this work in real time .
-6
votes
1answer
26 views
Can't connect to database from example [closed]
I can't connect to my database. I don't know which part should be changed or replaced.
if($_SERVER['HTTP_HOST']=="localhost")
{
#DATABASE CONNECTION VARIABLE FOR LOCALHOST
...
0
votes
2answers
32 views
Automatic database updates for real-time website
I am trying to build a website that will display real-time (or close to it) data from an XML feed on another website. I know how to use jquery, AJAX, and PHP to pull the data from the MySQL database ...
0
votes
1answer
30 views
How to upload a PNG, add transparent pixels to it, and write it to a database?
I am looking for information on how to retrieve a PNG file sent to the server via POST. Subsequently, I want to increase the height of the image to make it equal to the width by adding equal areas of ...
0
votes
0answers
30 views
database structure - complicated requirements [migrated]
I have a project to build a website but it's complicated and I'm having trouble figuring out what the best way to build the database would be to handle these particular requirements.
The site is for ...
-1
votes
1answer
26 views
Having issues with my database? I am trying to have a section in my site where you can add a new neighborhood?
I am trying to add a section in my site where you can fill out a small form and it will add the neighborhood in for you. When I try to fill in the form and add the new neighborhood, I get the error ...
-1
votes
3answers
33 views
How can I select a row that may contain swapped fields?
How can I select one row from that table http://i.stack.imgur.com/27cu9.jpg where values of 'user_1' and 'user_2' may look like
user_1 user_2
1 2
2 1
In other words I want to select a ...
0
votes
1answer
38 views
How to strip out width and height attributes on hard-coded image from database
The following code comes in from the database and the mw and mh values are messing everything up. How can I strip those out?
Here is my code:
<a class="wgt_ListingsSpread_thumblink" ...