Tagged Questions
0
votes
0answers
8 views
Very slow MySql queries Joomla 2.5
My website is experiencing very slow queries like the one below. It is Joomla 2.5.
# Query_time: 19.797091 Lock_time: 0.000561 Rows_sent: 12 Rows_examined: 4127
SET timestamp=1385467501;
SELECT ...
0
votes
1answer
15 views
PHP MySql user account bypassing cookies
Right, I've been tinkering with this for a while and got it all to work except for the user account page, my question is; can anybody spot on typos I have made here or give me a little help in making ...
0
votes
0answers
8 views
Creating a book marking app with php and Mysql?
I am trying to make a site similar to Delicious. When you login you can add and delete links. I want to post the title and link but only the title displays. What php code do i need to display posted ...
0
votes
0answers
4 views
Jqgrid json data with codeigniter - query in controller
I am trying to set up a jqgrid and I am having difficulty in constructing the controller that generates the json data to populate the grid. I am using codeigniter 2.0+ and I am not sure how to build ...
0
votes
1answer
13 views
How do you get Javascript to see tinyint(1) data pulled via AJAX request as boolean?
I am having a problem and after hours of searching for answers and playing around with it I cannot get it to work.
My problem. I have a MYSQL database. When I pull my "boolean" data from the database ...
0
votes
1answer
19 views
I can´t test php in nginx
Hello I have problems try nginx with php. For requirements for the course I can not use installers to use Wemp (nginx, php and mysql).
Clarify that the service works correctly MySQL
I just want to try ...
0
votes
1answer
20 views
MySql using Like to find the highest value of a string
I don't think this should be all that complicated, but I'm having an issue building a query to pull the higher lower value from a table, where the identifier is higher.
So basically, I have a table ...
0
votes
1answer
13 views
I want to return data form a table depending on whats in another table?
I have a table passenger_table and a table users!
passenger_table
user_id j_id
1 1
34 1
54 1
users
user_id Firstname Lastname
1 Patrick Connell
34 ...
0
votes
2answers
12 views
Array to string conversion error while outputting single variable
I have a funny error while I'm trying to output a single variable assigned from database.
I'm querring a top id from database and assigning it to a variable. Here:
$ID_Query = "SELECT DISTINCT ...
0
votes
1answer
27 views
SQL SELECT rows from one table using an array taken from another table
I need to do something like this:
$user_id = (int) get_logged_in_userud();
**$thread_ids** = $wpdb->query( "SELECT thread_id FROM $tableName1 WHERE user_id = %s), $user_id);
$iterateRows = ...
0
votes
0answers
14 views
Some values are not showing up in phpMyAdmin mySQL database
I'm using phpMyAdmin to store a database. The problem is when I make the insert query only 3 fields are fullfilled and 2 of them are ignored.
Yes, I have read other answer but no luck so far. If I ...
0
votes
1answer
18 views
php register user type
Hi i try to make a 2 register form. First register form for normal user and second register page is for business user.
I am using one mysql table for users. this table for same like normaluser and ...
0
votes
1answer
12 views
ANDROID Updating a ListView via JSON with AsyncTask MySQL
Immersed in the development of my program, I encounter an error that seems to me not really speaking.
So here's my logcat in the order and the java code:
When I click on the item in my listview it ...
0
votes
0answers
27 views
SQL Database setup issues
I'm trying to setup a database for a simple shopping cart app. I have a create.php file that should establish the tables. I'm getting new syntax errors everytime I fix one and I don't know why. Here ...
1
vote
0answers
29 views
Display .jpeg files from MySQL gathered with PHP form
Currently I am working on an html/php page that will display a random image and piece of text taken from a table with two VARCHAR(200) fields.
The issue is that the script will not display files with ...
0
votes
1answer
15 views
Live Dynamic search of MySQL table using jquery and php
I am sure there are a number of articles covering this topic, but every piece of code I try just doesn't seem to work. If this has been answered somewhere else already, I am sorry that I could not ...
0
votes
0answers
14 views
Php Mysql Table Search/List
Solved my problem,
I was trying to figure out how to select a column from the nth row, put simply.
I've done that by doing the following,
Php->
$sql = "SELECT * FROM `table`";
$query = ...
0
votes
1answer
28 views
Most relevent results php/mysql
I am having trouble sorting results by relevancy.
I have something like:
$search = $_GET['search'];
$key_terms = explode(" ", $search);
$query = "SELECT * FROM sentence WHERE";
foreach ($key_terms ...
-1
votes
2answers
17 views
PHP Fatal error: Cannot use object of type mysqli_result as array in file.php
I have the following code:
$productQuery = "SELECT ean, name FROM products WHERE category = '$category'";
$productResult = $mysqli->query($productQuery);
while ($productRow = ...
0
votes
0answers
23 views
Use bound variables in LIKE query
just going through my site and testing the forms for sql vulnerabilities and forgot i hadn't get converted my search query to use bound variables.
The addon for firefox (Sql Inject Me) is excellent! ...
-1
votes
0answers
25 views
select and join on max only if like [on hold]
Solved:
This does work.
I did this query
SELECT
`J`.`jobNo`,
`J`.`dealerTagNo`,
`J`.`tagNo`,
`J`.`totalSize`,
`J`.`rugDesc`,
`J`.`amount`,
`L`.`TagNo`,
`L`.`Location`,
`L`.`fullDate`
FROM `Jobs` ...
0
votes
2answers
25 views
Order by descending and returning the record number to use for ranking
I'm trying to rank users very simply by their reputation, which is stored as an int column in a MySQL table of users. In order to find out which users have the highest reputation from highest to ...
-1
votes
1answer
40 views
PHP - First browser game, QUESTS [on hold]
Sorry for my english.
Please help me, im developing an browser game (my first bigger project) on my own, and i have a question.
I have table with users and in that table i have columns with questID ...
0
votes
1answer
16 views
php/mysql search results - filter result when type >1 while keeping results where other types not >1 - codeigniter
Apologies for the title, I'm still trying to work out how to explain this.
I have a codeigniter web app that has a decent search function that nicely tabulates the results. Let's call it an airbnb ...
0
votes
2answers
26 views
Can't get PHP to pull line entry from mySQL as array
Ok fellas, I've been working with a SQL database via PHP for a couple days here now at work and I cannot for the life of me get it to work I have someone else who worked on this project and they have ...
1
vote
1answer
12 views
Prestashop Edit Meta-Tag in Home Page
How do change a meta tag in Prestashop ver 1.5+
<meta name="description" content="Shop powered by PrestaShop" />
<meta name="keywords" content="shop, prestashop" />
<meta ...
0
votes
1answer
28 views
Filling an HTML drop down box from database using php, but I'm missing one record
I'm pulling rows from a mysql database to fill a drop down box. It works, but it misses out one option. I think it might be due to the fact I'm using the <optgroup> tag in the middle, where the ...
0
votes
1answer
11 views
Nginx proxy_pass to dynamic host
At the moment I have a PHP script set up with a chunk of code that reads a file from a dynamic location (which comes from a database) and echo's it out to the user in chunks. It's basically a file ...
0
votes
2answers
21 views
MySQL Cant connect.. details correct
Forgive me if this is a dumb question but this is really frustrating.
Im having issues trying to connect to my MySQL database. The details are correct as i can login via phpmyadmin and terminal, the ...
0
votes
2answers
40 views
Firing SQL query on click of button?
I have a simple PHP/MySQL counter which incrementally increases a value in my SQL database. Currently, this script fires every time the page refreshes meaning that the number increases by 1 every time ...
-3
votes
0answers
30 views
PDO + PHP + AJAX proper implementation [on hold]
I had asked a question a question here and was asked by @MonkeyZeus to repost the results since I apparently did a good job with it.
include '../../config.php';
include ROOT_DIR . ...
0
votes
2answers
15 views
Error with transfering MySQL database (connected via PDO) from localhost to hosted server
Okay, so this is my code:
try {
$pdo = new PDO ('mysql:host=127.0.0.1;dbname=db_name','user','password');
} catch (PDOException $e) {
exit ('Database error.');
}
I tried so many different ...
-3
votes
2answers
28 views
restricting access of php page till user logs in
Hi im trying to write a script that restricts the access of user to a page until he has logged in with username and password. I keep getting undefined index file for username and password? any one ...
1
vote
4answers
48 views
Handling data with 1000~ variables, preferably using SQL
Basically, I have tons of files with some data. each differ, some lack some variables(null) etc, classic stuff.
The part it gets somewhat interesting is that, since each file can have up to 1000 ...
0
votes
3answers
30 views
How to create table and insert data from PHP?
I'm pretty new in PHP, I wanna add some data from form in html ,
i created a table and add insert code to PHP,
this is my question : I want to create a table once and after that just insert data but ...
0
votes
1answer
22 views
How to display random image and text from MySQL Database with PHP
I'm trying to make this html page (display.html) display a random image submission and random text submission from my MySQL table labeled "submissions".
This is the current code for display.html:
...
0
votes
2answers
36 views
how to execute a query within a query?
After a query is done, on the basis of the result i want to make another result.how can i do that?
$sql="SELECT * FROM programme";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
...
0
votes
1answer
32 views
Update table using mysqli
I wrote a PHP function, that takes two input parameters and updates a database table.
function updateTable($a, $b){
$query = "UPDATE myTable
SET dataUpload=CURDATE(), ...
0
votes
2answers
29 views
MySQL SELECT with double quotes giving trouble printing in php
If anyone has any ideas on how to help me out with this, when I run it usually just creates a never ending table.
<?php
$link = mysql_connect('localhost', 'blah', 'blah') or die('Could not ...
0
votes
0answers
23 views
Group by, but display only one rows different value from 2 fields and display all other value is this possible?
Apologies for the strange subject, passed 50 and like php and mysql
Have a question that I can not find the answer to or if it's even possible to do.
I collect comics and want results like this on a ...
0
votes
0answers
33 views
MySQL Time differencials
Bare with me as I explain my scenario. I am using php and mysql to create an automated html email report. This report shows the total number of emails received and logged into our system by a ...
3
votes
2answers
56 views
How to stop automatic submission of a form on your website? [on hold]
Someone one is posting random comments on my website - http://computerinfo.in/lostandfound/searchlost.php.
You can have a look at it.
The only forum available for posting is ...
-3
votes
1answer
27 views
Get recently viewed posts by using PHP [on hold]
I want to store and display recently viewed posts. I don't want to use cookies because not only want to show what the visitor him/her self viewed posts but viewed by others as well.
I know I can ...
1
vote
1answer
41 views
PHP connect to mysql database
I'm trying to make a connection between my database and the login form that I'm using in my website, but I'm facing a problem with that, so every time I click on login, this message appears "No ...
2
votes
1answer
15 views
How to use a transaction query mysql to keep it on for a few page in PHP?
I know how to using a transaction query in mysql and also commit or rollback. I want to make a portfolio of an application in my website. Some guest could try to use it, but when it end (either they ...
-1
votes
2answers
37 views
Best way to paginate query result without GET method PHP
What is the the best way to paginate mysql results without refresh the page?
I'm using ajax to connect my html file to php. The php file has the query and i want to paginate the result.
I'm ...
0
votes
1answer
14 views
ios comparing memcache and core data
Currently in order to limit the number of mysql requests, each user has a folder with multiple empty files corresponding to updates made in the database. The last accessed date of a file is compared ...
-1
votes
3answers
51 views
Limit time user is allowed on website before forcing a login [on hold]
I'm not sure what language to use (php, Java or other) but I'll need to limit the amount of time a user is allowed to browse our website before forcing a login popup appears.
Example:
Unregistered ...
-2
votes
2answers
34 views
deletion from mysql through php
I am trying to delete a product listing from my shirt_types table (which is tee-shirt products). I have an administrator page that list all the items in the table along with there information. I have ...
-1
votes
4answers
61 views
undefined variable in php
Hi i'm new to php and I keep getting an error in my guestbook saying
( ! ) Notice: Undefined variable: errors
Call Stack
# Time Memory Function Location
1 0.0156 154584 {main}( ) ...
Community Bulletin
Related Tags
sql × 8693database × 5455
html × 4044
pdo × 3310
jquery × 2933
javascript × 2918
ajax × 2195
codeigniter × 2170
arrays × 2119
mysqli × 2037
forms × 1351
phpmyadmin × 1342
json × 1152
select × 1084
join × 970
table × 947
insert × 931
date × 928
wordpress × 885
search × 774
android × 669cakephp × 657
apache × 649
performance × 612
session × 603
