Tagged Questions
0
votes
0answers
9 views
how to make a variable select all when querying a database
Hey all im trying to query a database using if if/else statement and I want one option to select all results from a specific column in the database (in this case location) an the other option to only ...
0
votes
0answers
11 views
Default input value being set to “Array” after attempting to pull value from database
Some background:
Recently I began messing around with creating a theme options panel in wordpress using 'Options Framework.'
One of the options allows typography to be added to the selection of ...
0
votes
0answers
6 views
Database Driven Travel Tracker - Possibilities
I am looking to create a dynamic global map that shows the travels of an "object". All I'm looking on how to do this is how I can use the database table to record the real global coordinates, plot to ...
0
votes
1answer
11 views
PHP MYSQL XML ERROR
I have a PHP file which reads the credentials from
require("phpRequireInfo.php");
And, my problem is that it keeps giving me error whenever i were to compile it. My php file looks like this:
...
-5
votes
0answers
35 views
POST 500 (Internal Server Error) when trying to get data from the database [on hold]
I really hope someone can help me, i have no idea how to solve this problem.
first of all i got this code:
My function:
function GetReviewData(){
$.ajax({
type: ...
0
votes
0answers
19 views
Edit File Image Upload
I've been having issues with file upload. After help on this site I managed to upload the files successfully to the db and can pull them back to show the images.Part of my assessment is the fact I ...
0
votes
2answers
15 views
Random String for transaction code
I would like to ask, I'm developing a website using PHP and currently looking for a better approach.
I want to generate random string for the transaction code.
For example: Customer purchased a ...
0
votes
2answers
39 views
Database connectivity error
In the below code when I pass $id_num to check the id field in database it accepts but when I want to pass user id to check with database it shows the following error;
Warning: ...
0
votes
0answers
25 views
How to left join two tables form two different databases using Zend framework(1.1.1.1)
I have already found this question: ZEND FW : Joining two tables from different databases. But the answers below did not solve the topic.
I used Zend Framework(1.1.1.1) in my project. And it used to ...
1
vote
3answers
36 views
Adding filters to dynamic search engine php
i'm working on adding filters to my database but i have no knowledge and google didnt really help so i appreciate all the advice =)
I would like to add filters like name and price and arrange by asc ...
-2
votes
1answer
38 views
Writing a mySQL database from the ground up
I recently got an internship involving the writing of an sql database and don't really know where to start.
The database will hold the information of a ton of electrical products: including but not ...
0
votes
4answers
34 views
Pulling data from a fairly large table multiple times is going slow
I currently am offering a free test taking feature on my site that each user may take one of the tests and see their high score or whatever.
I have a foreach that goes through each test and checks to ...
-2
votes
0answers
23 views
Enter a value in the database having two links [on hold]
I have two link in my page:
Link1 and Link2
I want to write "Hello" in its respective record in Db when I click it.
How can I do without $_GET?
0
votes
0answers
25 views
“snapshot” of MSSQL Fastest/Most efficient way [on hold]
I have a fairly large MSSQL database (+- 200GB) sitting on SQL Server 2005. It has around 250 tables each of which contain several thousand rows.
The current methodology (yeuch) is to duplicate the ...
-1
votes
3answers
45 views
php not writing info to database
<?php
$email = $_POST['email'];
$first = $_POST['first'];
$last = $_POST['last'];
$business = $_POST['business'];
$home = $_POST['home'];
...
-7
votes
0answers
37 views
PHP script return Warning: PDOStatement::execute() [on hold]
Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in /Applications/MAMP/htdocs/ricaAndroidAdm/TableEmpresas.php on line 106
...
0
votes
2answers
22 views
Outputting user status' from a database, but occationally output a users profile picture instead
My website pulls out user status updates one after another.
[status] [status] [status] [status] [status] [status] [status] [status]
But I would like it to sometimes output a users profile image ...
0
votes
4answers
28 views
how do I look an array to extract data
Hi all Im trying to query a database and store the results ($searchResults[]) as an array :
<?php
if(isset($_POST['indexSearchSubmit']))
{
foreach($_POST['industryList'] as $selected)
{
...
-1
votes
0answers
16 views
Special Characters uploading to db incorrectly
Echoing out my code up until the actual query is ran to put the string into my db it displays as ®.
Once it's in my database it shows up as ®.
How can I prevent this from happening? I am using ...
0
votes
1answer
34 views
0
votes
0answers
25 views
arrange N circle with no overlapping with javascript
there is a library that can arrange circles with no overlapping that called processing.js
This is a demo:
http://www.m-i-b.com.ar/letters/en/
I have a database that have a table called "data" it ...
0
votes
2answers
37 views
MySQL Query returns the Object rather than Array
I'm trying to get the Array so i can loop it through and get the category_id from it. Its output is in Odd behavior, 1st it comes in Public Row, then Public Rows, and then Num Rows. I'm not able to ...
1
vote
2answers
81 views
How to show all the rows in my faq page from my faq table?
This is a FAQ page. The page is only able show the last row of question with respect to its answer in the database. I want it to collapse and show the answer with respect to its question when I ...
1
vote
1answer
36 views
delete physical file after deleting the record of a table in database
what i want is to delete the image file after deleting the record of a table in database
my database consisting 4 tables, linking with primary keys and foreign keys.
the 4 tables are : Brand, ...
0
votes
2answers
21 views
Multiple Users Accessing my website
okay so I'm developing this website for my capstone class, it's a ticket reservation system. I'm using phpmyadmin on wamp server. My question is, at any point of time many users will be on my website. ...
-2
votes
0answers
43 views
Q: PHP/MySQL - Multiple database connections [on hold]
I have just a little question. Which one is the fastest? Connect multiple times to the same database with PDO (open -> do the prepared query -> close) or open the connection to the database at the top ...
0
votes
2answers
51 views
single html form insert into multiple mysql tables with one to many relationship
So i know that this is a popular question and has a lot of responses already.However, my challenge is slightly different which has been bugging me for days now.I have an html form,which is meant to ...
1
vote
1answer
34 views
Insert Degree Symbol in database through PHP
Hi StackOverflow friends,
I am storing temperature in my database but I cannot add the degree symbol. My code is:
$que = "Insert into tblTempForecast (DateTimePosted, Now, Tomorrow) ...
0
votes
1answer
22 views
Laravel- change database used by queues
I have created custom environment called production that have database.php and other configuration file in it. When running under production environment, the database that is being used is the one ...
-1
votes
0answers
13 views
making a drop downlist a function of another field
in my table their is column for available rooms when selecting from a drop downlist i want the no of rooms to be a function of the rooms available for the type of room selected
i have three types of ...
0
votes
1answer
18 views
laravel 4 - validation says column not found
This is my first time using laravel 4. I am sending some input. There is an email in the input. I am trying to check whether that already exists or not. If it does than it should send some error. But ...
0
votes
1answer
23 views
var_dump return bool(false) and @mysql_ping() return true, why ?
Problem with mysql connection via php. I have simple database as follows:
CREATE TABLE test (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
val INT
);
And when I do select in ...
0
votes
1answer
23 views
how to retrieve mysql database information
i want the user to be able to view the reservation details after entering an email address
the code below shows all data in the database, what do i add to make only the user's reservation details ...
-2
votes
0answers
16 views
Multiple files upload and insert names in database
This is my php code:
function get_extension($mime_type){
$mime_types = array(
'txt' => 'text/plain',
'htm' => 'text/html',
'html' => 'text/html',
...
0
votes
0answers
16 views
the option does not have a matching setter method
following this zend database and model tutorial
when trying to set up a relationship between your model and database
it tells you to configure the ServiceManager so that it knows how to get a ...
-2
votes
0answers
22 views
Embed youtube video via database? [on hold]
I have a question regarding how to add different videos to a unique URL?
So, we're talking youtube videos to be embedded.
E.G: I have three suggestions. Each suggestion must have 3 youtube videos ...
0
votes
2answers
25 views
Entering multiple selections into database from <select multiple> box
I have the bit of code below and I would like uses to select multiple options in the "select multiple" box and for these all to be added into the database. At the moment only 1 of the values that is ...
0
votes
3answers
44 views
mySQL how to change date format
the date format in mySQL have type (yyyy-mm-dd), now I try to reverse it (dd-mm-yyyy).
I got table user
CREATE TABLE USER
(
USER_ID INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
DOB DATE,
);
...
0
votes
2answers
21 views
Display multiple results with INNER JOIN
I have these three MySQL tables:
companies services auxiliary
id_company name_company id_service name_service id_company id_service
1 ...
0
votes
1answer
19 views
How to add all in one seo pack tags to the post from a php?
I am using a php file like "sitename.com/folder/file.php" to post everyday automatically in wordpress. The code is something like that;
$my_post = array();
$my_post['post_title'] = '<title>';
...
0
votes
0answers
11 views
Creating default object from empty value in my custom_functions.php
I don't know how but my theme is showing me this error:
Warning: Creating default object from empty value in /custom_functions.php on line 792
I found the code in custom_functions.php on line 792 as
...
2
votes
1answer
19 views
How to show answer respective to its ID from database once the ID is clicked?
This is a FAQ page. I am currently having problem to show the answer with its respective question. The page is able to show all the questions in the database as I have already placed them in the loop. ...
0
votes
4answers
47 views
PHP - Connect to Multiple MySQL Databases
So I have a PHP page that connects first to my database and does a bunch of stuff using the information from there. Now I want to connect to another database within the same PHP page and access data ...
0
votes
2answers
33 views
trying to post $_SESSION['username] in database table
I am close to finishing a class project. I have to create a calorie tracking website. I already coded the login forms and php files. Take into account that I somehow semi-learned to code in php in a ...
0
votes
1answer
25 views
How to return all rows, even if they don't have rows in a joined table
I have three tables, Users, Profiles and Requests. Only users that have created requests, will have a row in the requests table. But I still need to get all the users back and display the total number ...
-3
votes
1answer
28 views
edit.php is not working [on hold]
Can someone help me to fix this problemmm pleasee.
Notice: Undefined index: id in C:\xampp\htdocs\draft3\Edit.php on line 4
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean ...
0
votes
1answer
59 views
PHP SELECT * FROM not working correctly
I am having trouble with the following code:
# Connection:
require('config.php');
$MyConnection = new PDO('mysql:host=x;dbname=x', $dbusername, $dbpassword);
...
-2
votes
0answers
22 views
How to store a server wide config PHP using JSON in a database [on hold]
So I want a config that will only be loaded once and it will be loaded for everyone who accesses that site (server wide). What would be the best way to do that?
0
votes
0answers
25 views
MaxMind GeoIP API: fseek() [function.fseek]: stream does not support seeking in geoip.inc
I'm using MaxMind's GeoIP service as such:
<?php
include("geoip/geoip.inc");
include("geoip/geoipcity.inc");
include('geoip/geoipregionvars.php');
$gi = ...
0
votes
2answers
36 views
How to play a video in a database BLOB using php?
I have managed to upload a video (<2MB) to my table as a LONGBLOB type. The table name is test2 in database 'test'. But i cant play an mp4 video. This is my code.
<?php
echo 'h';
$arr=array();
...
Community Bulletin
Related Tags
mysql × 5269sql × 1317
html × 425
pdo × 329
codeigniter × 316
mysqli × 261
database-design × 254
javascript × 237
table × 226
forms × 206
arrays × 196
phpmyadmin × 191
jquery × 172
ajax × 172
wordpress × 157
insert × 135
cakephp × 121
session × 107
security × 106
zend-framework × 105
android × 100oop × 98
image × 96
sql-server × 95
json × 88
