Tagged Questions

-1
votes
1answer
29 views

HTML Table rows for updating DB

Pretty much a basic question in terms of understand what I want, but I can't seem to find a solution, Basically, I'm pushing a dynamic HTML table to a page using PHP like such <form action="" ...
0
votes
1answer
26 views

while loops inside an email (PHP)

I am trying to email the details from a shopping cart upon completion of payment. I have a confirmation page which successfully displays this information but when trying to email I cant get the item ...
0
votes
3answers
40 views

Why wont MySQLI INSERT work?

My MySQLI INSERT query wont work. Nothing is getting passed to the database in the query. Everything else is working great, so I don't know why the query wont work. This is all part of an AJAX ...
0
votes
2answers
49 views

Mysql COUNT, not counting as expected

I am using the following script to count records, the way I think it should be working should be. 'some heading' x4 but instead it is outputting 'some heading' 1x 1x 1x 1x ...
2
votes
1answer
28 views

PDO returns integer columns as String in PHP5.4

First of all, I am aware that there are various similar questions on SO such as this and this. However, when I fetch values from a table, integers are always fetched as string. I am using PHP5.4 ...
-3
votes
2answers
33 views

How to display first & last name by using phone number of the user in the same database

I have created a table with columns as FNAME- NAME LNAME- LASTNAME PHONE- PHONE NUMBER BIRTHDAY- BIRTHDAY I have successfully created HTML-form which passes the values to the database. Everything ...
0
votes
1answer
25 views

Can't change DATETIME format

How do I change the format of date + time in a database when calling it? Currently it's: YYYY-MM-DD Days:HH:MM But I need it to be: DD-MM-YYYY Days:HH:MM I tried this approach FORMAT(s.date, ...
0
votes
1answer
40 views

PHP Fatal error: Uncaught exception 'PDOException'

I am trying to make a directory list using jQueryUI tabs and menu widgets. I have got the following code for obtaining the directory. <?php $db = new ...
0
votes
0answers
9 views

mysqlnd_ms is not appearing as extention in php.ini

i am trying to use mysqlnd_ms plug in i have compiled the mysqlnd_ms and added the following line in php.ini but the extension is not appearing as mysqlnd or soap or other extensions appear. ...
0
votes
0answers
8 views

Drupal creating staging site from production site

I have a requirement to create staging site (there was no previous staging site) from production site (this site is pretty old) it contains huge database . Can any one explain me the steps .. I have ...
0
votes
2answers
18 views

Inserting data and/or Updating database using CSV

So I've been working on this for some time, but i cant seem to figure out how to get it to work. I want to update the prices of a product in the database if the product id is there, if it's not ...
2
votes
1answer
29 views

Keeping track of online users and the pages (without mysql?)

I needed to track online visitors so I create a MySQL table - online_users having fields; id (primary key), user_name, last_activity (DATETIME), page_url On every page load a script inserts a new ...
0
votes
2answers
28 views

mysql LOAD DATA INFILE fails with Euro sign '€'

I'm using php and mysql LOAD DATA INFILE from a .csv file. Some of the cells contain a '€' sign and a number and some a '$' sign and a number, like: 2.13€, 5.4$ When I load the csv file to the table, ...
0
votes
2answers
31 views

How can i combine these sql queries' results?

I want to combine two queries' results. I used select union but it imposed my web-site. (for the records my php memory limit is 128M) How can i combine these queries' results without imposing server? ...
-3
votes
1answer
16 views

What User am i logged in as by default in Mysql?

Ok.... I'm new to Mysql and php....So when I query select user(),current_user(); from CMD I get odbc@localhost and @localhost. What does that mean? What user am i logged in as? When I query SHOW ...

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