Tagged Questions

0
votes
2answers
19 views

Parse error: syntax error, unexpected '13' Error

So i was trying to get a login page that appears only to the members that are that level and them it says: Parse error: syntax error, unexpected '13' (T_LNUMBER), expecting ')' in ...
0
votes
2answers
11 views

In case of integrity constraint violation, how to tell the columns that are causing the violation?

When MySQL returns 23000 error code, it means that the update/insert query has triggered integrity constraint violation. However, the error, e.g. SQLSTATE[23000]: Integrity constraint violation: 1062 ...
0
votes
0answers
13 views

Get Deeper Category Items From Top Category

I need to list items from selected category(such as classified ads script). I have infinite category table. Like this; Category [ category_id, parent_id, name ] And I have a items table. Like ...
-2
votes
1answer
40 views

PHP Blocking SQL Injection

is there a code for check column_exists like file_exists ??? or my code is safefull or what should i do for block sql injection. index.php if(empty($_GET['page']) and empty($_GET['information'])){ ...
2
votes
5answers
24 views

Security escaping when md5'ing in MySQL

In this code UPDATE table SET field = MD5('{$_POST['variable']}') WHERE id = 1; Since the updated value is md5'ed, should I still take steps to prevent from injection? Like addslashes() or ...
0
votes
1answer
28 views

Most efficient way of calling mysqli_fetch_assoc

Recently, I have been moving all of my 'mysql specific' functions into a class, just so if in the future I decided to switch DB languages, I woudn't have to correct all of my scripts, but just one ...
-5
votes
3answers
42 views

mysql_query() expect parameter 1 to be string

I have the exact same code running on another script just with a different query in and it works fine but this one returns errors: The code is here: ...
0
votes
1answer
23 views

Image upload to folder by not DB

I have created a script in order for a person to upload both text information and a picture to a DB. The picture is hosted in a subfolder to the website called "images". The problem that I am facing ...
0
votes
2answers
19 views

Find nearest location from point always returning empty

I am trying to some results from my table geo_address I've followed this tutorial by google but the result is always empty. The $lat and $lng are taken from actual data in the table... so at least it ...
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
2answers
26 views

Using arbitrarily named php variable

My objective is to extract each value of 3 columns of a SQL table. Although, I want to extract these values from different tables deppending on the value of listtype that is chosen. The columns Name ...
0
votes
2answers
20 views

Retrieve values from multiple tables relationed

So, I have a table named clients, another one known as orders and other two, orders_type_a and orders_type_b. What I'm trying to do is create a query that returns the list of all clients, and for ...
0
votes
0answers
11 views

Duplicate rows codigniter

Im encourting a problem with my "add" function on the "subscriptions" model. 1% of the registerations is duplicated(2 or even up to 5 times) for some reason. this is the code im using: public ...
1
vote
3answers
19 views

how to filter set in search using mysql php

I have 2 category 1.worker 2.staff and i have 1 row of cardno w12 (this is worker id format) s109 and (this is staff id format) and i want to show only staff id which start with s ...
-2
votes
0answers
10 views

Is it possible to add OAuth to an existing PHP MYSQL Login System

I have a login system which uses PHP and MYSQL. Does anyone know if there is a tutorial on integrating OAuth with an existing login system. It needs to be generic OAuth 1 as opposed to Twitter or ...
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: ...
0
votes
4answers
34 views

PHP: checkbox-isset always returns true

In my form (which i'm submitting using jQuery's ajax() via POST) i've got the following checkbox (to check if the new user should have admin rights): <form action="../inc/new_user.php" ...
0
votes
4answers
41 views

Error connecting to MYSQL using PHP

I am working on an assignment that requires me to create a form that sends info to a database. I am having issues connecting to the server. I have tried using mysql_connect and mysqli_connect and ...
1
vote
2answers
36 views

Results of foreach loop prints multiple times

I am trying to split a delimited string of postcodes so that instead of it looking like this: before: row1: ST16,ST17,ST18,ST19,ST20 row2: AT16,AT17,AT18,AT19,AT20 row3: LL16,LL17,LL18,LL19,LL20 ...
-5
votes
1answer
20 views

Changing display order PHP MySQL

I developed a site in PHP using MySQL and everything is great except one thing. The site supports products (listing) and all of these products are a part of some category (product category). I use ...
0
votes
0answers
29 views

How can I put two search results statement as one and get the different results when queried

I need these two separate statements to be one statement using a conditional either if or elseif or even any other conditional statement which will execute any of the two queries and render results. ...
0
votes
1answer
19 views

Search for iframe replace with shortcode

I am trying to convert all the iframes from database to wordpress shortcode. Here is a sample string <iframe ...
0
votes
0answers
23 views

Special characters showing up in database

I'm saving a string to the db that contains a ® symbol. I need it in this format so it can be displayed in a pdf I'm creating. Everytime I submit the form and push it into the db it comes back as ® ...
0
votes
1answer
19 views

Get last 5 item of sql results with Propel

I want to get the last 5 items of my search action. An example: $quizzes = $user->getQuizs(); Now I would like to select the last 5 of that, is this possible with propel? I tried ->getLast(5) ...
0
votes
2answers
34 views

Connecting android with php and mysql using json : Not working

I'm trying to connect android with php and also mysql using json. This is apart of my coding which is to add data. Based on the coding private static String url_create_fixture = "http:// ...
0
votes
0answers
19 views

How to edit Full-text search to look for for exact word?

I am using a full-text search function to make searches in my blog site. I want to fnd the exact word that is used in my query. $results = DB::table('posts')->whereRaw("MATCH(title,content) ...
0
votes
2answers
49 views

How can I put two search results statement as one using a conditional statement?

I need these two separate statements to be one statement using a conditional either if or elseif or even any other conditional statement which will execute any of the two queries and render results. ...
0
votes
1answer
7 views

I cannot get Slickgrid displaying mySql data

When I run this it just displays the html table. Where am I going wrong. I have tried quite a few examples with no success and have read as much as I could on the net in the last week. I think the php ...
1
vote
4answers
45 views

Obfuscating database ID to customer facing number

I'm using mysql database auto-increment as an order ID. When I display the order ID to the user, I want to somehow mask/obfuscate it. Why? So at first glance, it is obvious to admin users what the ...
0
votes
1answer
39 views

Grabbing the correct price column from MySQL without having extra queries and php to do it

Following from this memory limit problem: Grabbing 190k rows from MySQL using PHP, blank page? Memory or buffer? One of the big reasons I reach memory limit today is because of this script: When I ...
0
votes
1answer
38 views

Form Upload Ajax

Here is my question i have a combobox <select id='addOPTION' onchange='fillADDid(this.value);'> <option value=0>Select</option> <option value=1>etc</option> <option ...
0
votes
0answers
11 views

SSL protected PDO connection not working - SQLSTATE SSL Error - Access denied for user (using password: YES)

I created a user via MySQL Workbench. CREATE USER 'fba_user'@'%' IDENTIFIED BY 'my_Pa$$word'; CREATE USER 'fba_user'@'localhost' IDENTIFIED BY 'my_Pa$$word'; FLUSH PRIVILEGES; GRANT ...
3
votes
2answers
58 views

Check is value inserted when update mysql

I want to check is same value inserted in this field when I update a field. ex: this is my table id region region_manager_id 1 test1 rm1 2 test2 rm7 3 test3 ...
0
votes
1answer
20 views

how to show retrived data from mysql table in sequential serial nos

i have to show the retrieved data from MySQL table using Php in orders like where the no should come link: sln0 data1 data2 1 data data 2 data data 3 data data ...
-2
votes
3answers
51 views

Grabbing 190k rows from MySQL using PHP, blank page? Memory or buffer?

I'm trying to grab all data from a table, to calculate some stats. There is currently 190.000 rows and counting, and I am selecting only the columns necessary. Using Kohana Query Builder, when I do ...
0
votes
1answer
22 views

Laravel - using mysql functions on where clause colmn

I have a database with encrypted field using AES_ENCRYPT the data is encrypted and should stay this way, so there is no way of changing the method it is encrypted with. Recently I started working on ...
0
votes
1answer
27 views

Using ajax with multiple selects

I'm building a portfolio page and created some filters to user organize the portfolio list. The filters are dropdown lists, like that: <select name="category" id="filter-category" ...
1
vote
1answer
28 views

php exception comming after login

I am new to android development i have server side php login and registration form attached to same config file, I am able to register my users in the same database but i am unable to login using same ...
0
votes
0answers
9 views

failed to load resource the server responded with a status of 500 (internal server error) in php

This my code to showing the image from the database i call the display.php ie time i got internal server error can u help me please this is my anthor page here i got image from the ...
0
votes
1answer
35 views

Switching from MySQL to MYSQLi - loop not working

I'm changing my site from using mysql to mysqli. So far the changes have been quite simple but I have a calendar page with for loops which doesn't work after the switch. I'm pretty sure it's the loop ...
0
votes
1answer
30 views

Displaying different data in different table columns by switching options in a select

My problem is the following: I have an ajax function that, according to the option (of a select) selected, associate a record in a database and populate another input, i.e. a p tag. I have two td ...
0
votes
0answers
20 views

Select last row to write graphic in MySQL PHP Program

Im changing a program in php that uses MySQL function.This program catch the row value(conexoes_total) in table where time is equal 00:00:% , and write this row in a graphic. But this program only do ...
1
vote
2answers
22 views

Dynamical add form elements, store them to MySQL and change/delete them in future

I found this solution for my problem but I need some additional help: How to use jQuery to add form elements dynamically I have a form (here I'll copy a short version), and it is used for entering ...
2
votes
0answers
27 views

How to manage session tokens among various client apps (android/iphone) from server side php and mysql?

I have a rest api developed using php and mysql. I need manage different client apps including android and iphone. I just want to allow only one user from one type of app. for eg at a time the same ...
0
votes
2answers
26 views

How to get the single record in table using codeigniter

Hi Friends I have two tables 1)user id name etc.. 1 xyz 2 pqrs 3 lmn 2)cart cart_id id etc.... 1 1 2 2 3 1 4 1 i want to get the cart data having user details ...
0
votes
0answers
29 views

Generate XML Page using PHP with Mysql

I want to generate an XML file something similar to this <mainnode> <node1 name="aaa"> <subnode name1="39576" /> 1<subnode/> <subnode><subnode/> ...
0
votes
2answers
30 views

How to improve performance of my Joomla based Intranet system?

I have a Joomla 1.5.10 based Intranet system. In this application, we have more than 80% custom extensions. Below is the configuration: Apache version : Apache/2.2.22 (Win32) mod_ssl/2.2.22 ...
0
votes
4answers
33 views

Page not redirecting correctly

I have set a redirect to happen and it isn't working here is the code: if($result){ $sql_result = mysql_query("SELECT * FROM `application` ORDER BY `application`.`app_id` DESC LIMIT 0, 1"); ...
0
votes
0answers
16 views

Codeigniter search in files uploaded on amazon s3

I'm creating project with CI. I'm uploading files to amazon s3 server through amazon api. Problem is with search in files function. What is best way to search in files that are store on amazon s3? ...
0
votes
2answers
16 views

Joined to creditmemo_flat_table

When joined to creditmemo_flat_table $collection = Mage::getResourceModel('sales/order_creditmemo_grid_collection'); $collection->getSelect() ->join( ...

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