Tagged Questions

0
votes
1answer
18 views

Hide column of sql results and and show below table onClick

I have a table that displays sql results, however I would like the table to display certain results, and display more upon a click, below the table in a div tag. So far I have this code that ...
0
votes
0answers
9 views

Using gettext and database driven translations simultaneously

I am currently developing a website in PHP and I decided to go with gettext to manage the translations. I set up a nice Pootle server so that I can easily manage the translations and a bash script ...
0
votes
1answer
23 views

try catch in php not found

I have a try catch in PHP. try { $name =$this->sql_query(array("date" => "date", "provider" => "content_provider_id"),"table_name", null, ...
0
votes
1answer
9 views

MySQL /PHP- Selecting Members Based on Chosen Service(s) Updates

So basically there are 4 services offered by a Resort: services (Table with all resort services) ser_id ser_name 1 Breakfast 2 Dinner 3 Towels 4 Taxi Members can ...
0
votes
2answers
17 views

Inserting 2 different array values into database does not work

I'm trying to insert 2 values from arrays into a database. There's nothing wrong with the connection, the fields where $fullArr and $thumbArr get inserted are longtexts, and when I try to insert 1 ...
0
votes
0answers
34 views

Why does 'false' match all records in an SQL query?

Maybe this is an obvious one but why is it that the query SELECT * FROM articles WHERE slug = false; returns all rows? I ask because I made the mistake of accidentally having PHP set the variable ...
0
votes
1answer
19 views

mysql insert into DB not working

I cannot seem to get the new_id and id to update/insert into the DB but it is showing in the console log correctly so I know its posting that far correctly AJAX: $('body').on("click", ...
0
votes
0answers
17 views

Creating a multidimensional array from query with PDO

I am wondering if this is possible. I have a table with three columns (there's an id column too, but irrelevant here): [year] [month] [price] How do I generate an array that consolidates year and ...
0
votes
1answer
11 views

Joining Multiple Rows From Within

The Problem I have four tables I need to pull info from, two are just simple joins. My query is returning nothing. Basically, there are forms I need to make sure I tied to my patient from one ...
1
vote
3answers
36 views

Check to see if a variable exists in an array

I have an array and I am trying to see if it contains a certain value that is represented by a variable. The value will always be numeric The array is created from a MySQL select query Variable: ...
0
votes
1answer
26 views

MySQL returning rows that don't equal values in a PHP array

$query = $this->db->query("SELECT * FROM default_albums da INNER JOIN default_album_hc_connect d ON d.albums_id = da.album_id_da ...
1
vote
1answer
18 views

MySQL: Check If Table's Data Has modified Without trigger and UDF?

Is there a way to know if a MySQL table's data has been modified?
1
vote
3answers
34 views

How to change order of substrings inside a larger string?

This is fairly confusing, but I'll try to explain as best I can... I've got a MYSQL table full of strings like this: {3}12{2}3{5}52 {3}7{2}44 {3}15{2}2{4}132{5}52{6}22 ...
0
votes
0answers
30 views

PDO and Database Class - Getting Table Schema

I've got this class "Database", it extends PDO, and I can do searches and find all perfect like this: public function select($sql, $array = array(), $fetchMode = PDO::FETCH_ASSOC){ $sth = ...
-2
votes
4answers
42 views

using php to bring up content from mysql

I'm attempting to create a simple admin page for a website. Where the content from the form below, will populate within the p tags in the html doc <html> <body> <form ...

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