Explore our sites

Stack Exchange
tour help careers 2.0

Tagged Questions

0
votes
1answer
11 views

Special Characters from MySQL after using mysqli_real_escape_string

I'm using mysqli_real_escape_string function to avoid sql hacking issues but when I fetch that data from mysql using php, ', " & ’ characters are shown as a question mark sign (�) in output. I'm ...
-3
votes
0answers
21 views

Forms PHP + Mysql

I have one php file that displays one forms. I want that form displays data of the customer when he clisck on the button submit and in the same (corfirmation) page give permition to delete and update ...
0
votes
0answers
21 views

PHP - How to store the time in mysql with datetime format

I want to store the time in which the user logins in datetime format into mysql using insert into function At the first part the select condition checks whether any user with that password and ...
0
votes
0answers
14 views

Passing a variable containing spaces and an ampersand into a function argument in PHP

I have 2 queries that query the same table in the same database with the only difference between them being that one query has a WHERE clause in it while the other does not. Query 1(Working): ...
0
votes
1answer
12 views

If there is same email address in more than 1 row, hold all messages to be sent, then send them once

Ok, I had given up playing with my code and I had used up all ideas. I have simple code here that email users about the status of the domain that they sent me. Sometimes, a user sends multiple ...
0
votes
1answer
11 views

Nested select statement in MySQL for updating field based upon max value of another field gives error

I want to execute the following SQL statement in PhP. I have simplified it below. I would like to know the MySQL modifications to make it work. I tried a few like giving aliases to the tables but it ...
0
votes
3answers
25 views

“No database selected” issue

My developing environment is based on EasyPHP 12 and PHPdesigner on windows XP SP3. I am working on a registration / login solution, and I successfully completed the "sign up" part of it with a very ...
1
vote
2answers
34 views

How to perform insert and select operation simultaneously on a same table in MySQL query?

I've a table called 'questions' in my database. For your reference I'm specifying below the structure of table 'questions': question_id bigint(12) AUTO_INCREMENT (Primary Key) ...
0
votes
1answer
8 views

Import/Export XLS-MySQL

I deal with export and import with XLS and MySQL. About import. U used this library, but I need edit it and I don't know how to do it. Result of this script are strings separated by commas, but lines ...
0
votes
1answer
21 views

Why my subscribe page doesn't put the fields in MySQL database?

I'm with a doubt, I'm trying sending data to my database but it doesn't insert it them. How can i put them to send it? index.php (script part): <div id="wel"> <p ...
1
vote
1answer
26 views

Maintain a mysql connections between calls to php files

How can I have a mysql connection maintained between calls to external .php files? I lose like, almost 2 seconds everytime to reconnect to the database, which is way too much. Btw, I heard persistent ...
-4
votes
0answers
34 views

SUM and Subtract

I stopped in this example and to be honest I have no idea how to do...can help me with this, please? here is something like I need: I need to show in the user profile if this user have a debt and ...
0
votes
2answers
27 views

Submit button not working in Chrome but working in Firefox

Hi the logout button is not working in chrome. It is working fine in Firefox. However if I press F12 and keep the developer console open then the button works. The button also works when I press ...
0
votes
2answers
28 views

Function call is returning MySQL Syntax Error 1064

MySQL keeps returning an error 1064 whenever i call a function to query my database, yet i cant seem to find my syntax error. The error message is Syntax error or access violation: 1064 You have an ...
1
vote
0answers
17 views

PHPExcel; Exporting data from MySQL to an .xlsx template

I'm new to PHPExcel, obviously.. I'm also pretty new to PHP in itself. The website has multiple levels of authority for viewing/editing. I've been working on a page for a website that gathers ...
-1
votes
1answer
26 views

Trying to link tables with SQL

I'm trying to link two tables on phpMYadmin using sql so that the "cuisineid" is the same on both tables at the moment this is the code im using at the moment INSERT INTO`recipename` ...
0
votes
1answer
17 views

MySQL select query inner joined tables with 2 regexp targeting different tables

Im using PHP MySQLi prepared statements for the querying $stmt = $dbconnect->prepare(" SELECT COUNT(r.review_id) , p.postid , p.title , p.tags , p.ltags ...
0
votes
0answers
15 views

Joomla 2.5 ordering sidebar menu alphabetically

I have tried looking everywhere, but can't find a right direction from where to start. Actually I have inserted menus in joomla menus from component using mysql trigger. Menus are built nicely, but ...
1
vote
4answers
50 views

Why doesn't my online users page work correctly?

I want to check whether a user is online. I've got a status column in my members table. That column logs the last timestamp of the users activity. If the user wont do anything within 5 minutes ...
1
vote
3answers
25 views

PHP/PDO how to insert a FOR loop in the execute(array) definition?

I am developing an Android App and I have to write my own API in php. Unfortunately, I have very little experience in PHP/mysql and API's so Im struggling. I dont know how many pictures Im going to ...
-1
votes
0answers
28 views

This may cause unpredictable behavior

I have installed Centos 6.4 64bit. I have installed PHP 5.5.7 and mysql Ver 14.14 Distrib 5.6.14 When I loggin to the phpmyadmin I received below error " Your PHP MySQL library version 5.1.72 ...
0
votes
1answer
16 views

How to create a new table and import CSV to mysql with column names in csv first line [duplicate]

I want to know how to use mysql "LOAD DATA" function to import csv to a new table, the csv has columns in the first line.
0
votes
2answers
18 views

retrieving and then updating the same row in mysql with while loop

I am reading data from local database and then doing some calculations with the information and then rewriting it back. That all works fine, but I don't know how to associate what I have done, with ...
-1
votes
3answers
45 views

How with javascript for loops write variable in the php?

I have this code: <?php require_once("conection.php") ?> <html> <head> <title>Title</title> </head> <body> <script ...
0
votes
0answers
26 views

How to update add/replace an entire database using Doctrine or Mysql

I'm working on a web-app project, for a trading company, which would like to have an offline access to the web App and possibility to update when connected to the net again. The interface is easy to ...
0
votes
0answers
41 views

order by rank , priority and date in php mysql

i am using the following query for sorting the rows according tot he rank defined select properties.id, properties.agency_id, properties.created, IF(@prev <> properties.agency_id, ...
0
votes
3answers
38 views

How do I create an object with custom attributes in PHP? [on hold]

I am using PHP and MySQL. My database have two tables: product and product_attr Each product may have different attributes. Like this: PRODUCT ID name ---------- 1 Table 2 Car PRODUCT_ATTR ...
-2
votes
0answers
20 views

MySQL to HyperTable [on hold]

I am working on search engine written in PHP, using MySQL database. I have highly optimized OOP code, but is time to remake database. I want to replace MySQL with HyperTable, but I can't find any ...
0
votes
2answers
35 views

Trouble when passing a php variable as an argument in mysql query

I'm trying to use a php variable as a search term when querying a mysql database, first I get the variables from the HTML form: <?php //Create variables $vals = array($_POST["id_number"], ...
0
votes
0answers
49 views

Select duplicate records by IN() clause of mysql

I am having issue with IN() clause in MySQL. Query: SELECT * FROM my_table WHERE 1=1 AND id IN (36,36) ORDER BY find_in_set(id, '36,36') Here 36 is my primary key of the table. Now if I run ...
-3
votes
0answers
30 views

Can't Update passcode in MySQL [on hold]

I'm trying to do some code for the user to retrieve his passcode. But, since the passcode is md5 codified, my option is to send a new passcode for the person's email and changing automatically in the ...
0
votes
6answers
36 views

error when i call function that contain mysql connection

---------------conn.php----------------- <?php session_start(); function conn{ $hostname = "localhost"; $userDB = "root"; $password = ""; $databaseName = "forum"; ...
0
votes
0answers
24 views

How to make Twitter Typeahead autosearch with php and mysql with template?

I am try to use twitter's TypeAhead with a php file instead of a json file. With the json file approach the data are fetched from a single json file called repos.json $('.example-twitter-oss ...
0
votes
3answers
48 views

mysql_fetch_array() expects parameter 1 to be resource, boolean given [duplicate]

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta ...
-7
votes
0answers
41 views

PHP Fatal error alert [on hold]

I am developing a Document Management System in PHP & MySQL. I am testing in the local machine which has Capacity : RAM : 3GB CPU Core 2 DUO 2.9GHz My Records needed is over 1 millions : when ...
0
votes
1answer
19 views

Retrieve parent-child hierarchy from a self-referencing mysql table

I have a mysql table structured like this (removed other columns, not relevant to the question): id parent_id ----------- ----------- 1 0 2 0 3 ...
1
vote
2answers
32 views

How to change my mysql table prefix via htaccess file? [on hold]

I have a website in php and mysql. I have updated the table prefix in mysql. Here I need to change all table names with prefix code without changing the source code in php. How can we do this via ...
1
vote
1answer
43 views

Big database vs multiple databases [on hold]

I have new produces about 9 products every product have something shared with another on database for example : 1- users databases content : users information table(email,username,...etc) users ...
-1
votes
1answer
29 views

Attendance for Employees with Checkboxes in php [on hold]

I am building an application, wherein the Manager takes attendance of his employees. And the design is something like in a table there would be two columns, one having list of "Employees" and the ...
1
vote
3answers
32 views

mysql insert values select not exist

How to make this work I'm preventing INSERT in a loop? INSERT INTO kelengkapan_berkas (id_buyer, nama_berkas) VALUES ('1', (SELECT jenis_berkas.nama_berkas FROM jenis_berkas WHERE id_job = '1' AND ...
0
votes
2answers
31 views

Executing 1000s of mysql queries using php and maintaining queue to avoid data failure

I have a PHP and MySQL application which I have tested with few hundreds of users, now recently I got the opportunity to run my application live with around 8 thousand users.... So its kind of quiz ...
0
votes
1answer
22 views

Reset password lime survey

i have a problem with lime survey. i forgot admin password. and I tried to update via mysql with md5 encryption. but not successfully login. update lime_users set password=md5('password'); or ...
-4
votes
1answer
27 views

how to validate drop box and text box alternativly?

<form class="" method="post" name="form1" action="addpersondroptext.php"> <table align="center" > <tr> ...
0
votes
1answer
39 views

what is the proper way of figuring out if an sql statement returns true or false?

So what I am trying to do is filter my apps that are in a folder through a permissions DB Table to decide weather or not the current user is able to access that app. In the beginning of this file I ...
0
votes
1answer
34 views

MySQL UPDATE query - dealing with empty inputs

This is my first UPDATE query, I have checked using jQuery for any empty fields. I want the user to input at least one field and then update the field(s). Doing a query with all the $_POST names might ...
1
vote
1answer
60 views

php/mysql how to select items by date in multiple date fileds?

Post fields: in, out my table: id, title, in1, out1, price1, in2, out2, price2, in3, out3, price3 I have 3 periods with 3 prices, is for hotel booking, I try to select item by date, but have 3 ...
0
votes
0answers
47 views

How to avoid duplication during the matching process?

How do we match the students with the company by looking at the student's choice of jobscope keeping in mind the no of vacancy available and to avoid duplication? For example, if the student chose IT ...
-2
votes
0answers
20 views

Android/PHP/MYSQL pull data from the web

Hello I want to pull something from the web. This is basically what I want to achieve: I'm going to select records from the web server's database where a certain field is equal to a record that is ...
0
votes
2answers
35 views

how to compare two field with same value with different effect in one table in mysql?

i need to compare the value of two fields with the value of a textbox. i have one table called CITY. name and zip are the other two fields that are from this table. Now my problem is that i want to ...
0
votes
2answers
28 views

PHP - Application with multiple databases

I am currently working on a large application that will be used by many people each having a large amount of data. I thought to manage these multiple users through a single database but I am asked to ...

1 2 3 4 5 … 1691
15 30 50 per page