I went through the process of converting mysql_* code into PDO code. I’ve run it and checked that it works and everything. I just want Stack Overflow’s review of it, to make sure that I’m killing …
Tag: mysql
Rooms & Availability Dates PHP/MySQL
So, I’m desinging a web application that is going to work for a Hotel and it should eventually become an easy way to install for every hotel website with some extra code. The application is working with php and mysql. So, as you probably guessed, I’m pretty confused with the database structure. Th…
How should I got about setting up a local LAMP stack with switchable PHP and MySQL on OS X?
I’m moving house in a few weeks and am taking the opportunity to update my tech setup, switching from a MacBook Pro and a MacBook Air to a MacBook Air (which will be my day-to-day computer) and a Mac Mini Server (which will be a media hub and be used for heavy lifting). As part of this process, I’…
Using PHP/MYSQL book but get no output from PHP when trying to access the database
I’m currently working my way through “PHP and MySQL Web Development.” I’ve successfully created databases and been able to make tables and use the database. I’ve also successfully completed all the …
Using time zones in a PHP web application
I’ve been looking around for a few hours now about what’s the best way to use timezones in a PHP/MySQL web application, finding a definitive answer is hard. From what I’ve learnt so far it is best to store everyones stuff in the database in UTC (correct me if I am wrong). When a user registe…
Using pdo in php with stored procedure
I have a simple stored procedure in MySQL database: When calling this procedure in mysql-workbench it returns the data I put in: Now when I call it from PHP using pdo I get an error: Here is my php code: Answer You need to use bindValue instead of bindParam. When you use bindParam, it binds the variable provi…
submitting the form after successful paypal money transaction using php
I’ve made a form. Currently this form does the following operations: customer fills up the form (creates an order) clicks on “Submit” button all form entries are entered into a database. I’d like to change it to do the following operations: customer fills up the form in the end of the …
Resize textarea based on lines of text that comes from php/mysql variable
I dont need it to resize automatically as you type, I just need it to be the correct size when the page loads the variable is $row[‘text’]; <? echo $row['text']…
PHP MYSQL $row[$variable]
I am trying to work around with dynamic table creation and data fetching. I am trying to get the data using following code : But, I am unable to get any data back. I checked printing the query and running it in php my admin and its working as I want. But I guess variable in array might not be
PHP issue about sending mail message
I am having an issue when sending e-mail using php code. I have a form which sends an attachment to a folder and the name of the attachment to the database, in order to then send the link of the file inside the message. The problem is that the file and all the rest go the way it should but