php

Passing Data in and out of CKEditor / jQuery-UI Modal Dialog

Greetings, Overflowers! I am writing an application in PHP that will allow for editing various blocks of content via a button that loads a CKEditor Instance inside a jQuery-UI Modal Dialog box. I've got the button working to launch the Dialog, as shown in these screenshots: The example shows the 'Main Content' content inside the D...

Remove last character from a variable and then multiply against another variable

I have a whole bunch of percentages stored as XX% (e.g. 12%, 50%, etc..) I need to remove the percentage sign and then multiply the percent against another variable thats just a number (e.g. 1000, 12000) and then output the result. Is there a simple way to strip the percentage sign and then calculate the output with PHP? Or should I cons...

SQL left join automatic aliasing?

I just realized that I'm going to have to start aliasing my database calls due to repeating column names in my join tables. Is there a way to automatically tell SQL to alias all my column names so that they are returned with a prefix of the table name? Otherwise it appears to be quite confusing when only some of them are aliased. Just ...

Cannot output json from MySQL - getting null value

I'm using following code but cannot return data from MySQL. This is the output: <script type="text/javascript"> var somethings= [null,null,null]; </script> It does have three post, but I couldn't get the title(message) output. EDIT: this is the code I'm using: <?php $session = mysql_connect('localhost','name','pass'); ...

Looping through multidimensional array starting from second array in PHP, if exists

I am returning an SQL query from database using PEAR into an array. $db_results = $db->getAll("SELECT * FROM loans ORDER BY amount, length, true_interest_cost"); If the query return results, I would like to show the first result formatted in one way and then the rest of the results formatted another way. So, my end result would look ...

PHP: How to implement a __get-like method for local function variables

I'm no stranger to __get(), and have used it to make some very convenient libraries in the past. However, I'm faced with a new challenge (PHP 5.3, abbreviated and simplified my code for this question): <?php namespace test; class View { function __construct($filename, $varArray) { $this->filename = $filename; $this...

php printing and updation in to db

I have few values existing in data base,i need to update them but,i am unable to do it. UPDATE Phone SET dcno='1' WHERE number='1' AND date='12/03/2009' AND dcnodate='11/05/2009' AND yourorderno='1' AND orderdate='23/06/2010' AND vendorcode='2222 Couldn't execute query: You have an error in your SQL syntax; check the manual that co...

Redirect everything to index.php

I'm trying to do clean urls by exploding $_SERVER['REQUEST_URI'] and then switching between the results. However, once a user goes outside index.php, I'm assuming I need to redirect them back to index.php in order to process the URL they want to reach. How can I accomplish this? So for instance, user goes to www.domain.com/home/joh...

PHP Disabling ipv6

Hello, It seems that I need to somehow disable IPv6 on my php pages, but I am not sure how to do this. I think I have to add --disable-ipv6 somewhere into my INI file... this doesnt look like proper syntax though. I am trying to solve the following bug: http://bugs.php.net/45519 Does anyone know where to put this? ...

Permissions for Large Variables to Be Sent Via Stored Procedures (SQL Server)

I can't figure out a way to allow more than 4000 bytes to be received at once via a call to a stored procedure. I am storing images in the table that are around 15 - 20 kilobytes each, but upon getting them and displaying them to the page, they are always exactly 3.91 KB in size (or 4000 bytes). Do stored procedures have a limit on how ...

Track user's country in PHP & MySQL

Hi, I'm creating a URL Shortening website. I want to allow users to view the stats for the links. I planned to do Country stats. I think I should use a library similar to GeoIP for PHP to get the country, but, how can be the MySQL. My weakness is the design of the MySQL tables. Can you recommend me a table format, please? ...

make array from a list of images with jquery

i have a list of photos like this: <div class="upimage"> <ul id="upimagesQueue" class="thumbs ui-sortable"> <li id="upimagesKHGYUD"> <a href="uploads/0002.jpg"> <img src="uploads/0002.jpg" id="KHGYUD"> </a> </li> <li id="upimagesNCEEKI"> <a href="uploads/0003.jpg"> <img src...

Return via an abstract protected function?

I'm looking at the auth class in Kohana 3 as well as a login script. When the login page calls the login function of the auth class, it is returned via a protected abstract function _login. Why would you do that out of curiosity? I can't seem to understand what would really be the difference since you'd be returning the same data eith...

Getting Null value with JSON from MySQL, how to retrive data from MySQL to JSON correctly?

I'm using following code but cannot return data from MySQL. This is the output: <script type="text/javascript"> var somethings= [null,null,null]; </script> It does have three post, but I couldn't get the title(message) output. EDIT: this is the code I'm using: <?php $session = mysql_connect('localhost','name','pass'); ...

JQuery ajax request returns error and status 0

I use this pseudo-class to make ajax request to server: function RequestManager(url, params, success, error){ //save this ajax configuration this._ajaxCall = null; this._url= url; this._type = params.type; this._success = function(){ alert("ok"); }; this._error = function(){ alert("ko"); }; } RequestManager.prot...

Approve/Deny in PHP, with some minor javascript

Hi again. Another lame question So, I have a site that displays several students' requests to change advisors, with an Approve and Deny button for each student. Then I have a Javascript pop-up that confirms the decision when clicked on either button, and it will also e-mail the student about this decision. This should all be on one page...

RSS subscribers counter

Hello I'm trying to make an RSS subscribers counter using PHP and don't know where to start ? i'm not asking someone to write me the code, but do you know something good to read ? or you can tell me steps to do that ? Thanks ...

PHP Image Link in Function 404's

Hello, I have a valid link that goes to a picture located on my web server. It is a simple jpg image, I can copy and paste this link into my web browser and it loads fine. The issue comes in when I try to call a few php functions on the image... such as getimagesize or fopen... they both return 404 errors even though the image is ther...

Regex to match javadoc style comments

I have files having content like /** * Some Content * @param .. * @author .. * */ function a_sample_function ( $args = '' ) { I need to extract the text Some Content @param .. @author .. given a function name a_sample_function ( the * can be removed by a gsub later I believe) I'm writing this in ruby. ...

OS-related strtr problem

I have this funtion that converts all special chars to uppercase: function uc_latin1($str) { if(!defined("LATIN1_UC_CHARS")) define("LATIN1_UC_CHARS", "ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝ"); if(!defined("LATIN1_LC_CHARS")) define("LATIN1_LC_CHARS", "àáâãäåæçèéêëìíîïðñòóôõöøùúûüý"); $str = strtoupper ( strtr ( $str,...