php

Synchronising local and remote DB

Hi everyone, I have a general question about DB synchronisation. So, I'm developing a website locally (PHP + MySQL) and I would like to be able to synchronise at least the structure (and maybe the contents) of the two DB when one of the two is changed (normally I would change the local copy). Right now what I'm doing is to use mysqldu...

Search and Replace within a Text file using mySQL queries

How can I create PHP to search the testing.txt file for each name in the database table and replace the name with the database table id? So that the text file looks like this: 3 | 1 | 4 | 5 2 | 3 | 6 4 | 5 | 2 and so forth an so on... I have a mysql table called "nameslist" that looks like this: --------------------- id | name -----...

PHP: cannot matching string "<br />

hi, I'm having problems with string matching in PHP. I've 2 html elements in my page, I've copy pasted here the content with Firebug <div class="field-item odd"> <div class="field-label-inline-first"> Year:</div> 2009 </div> <div class="field-item odd"> <div class="field-label-inline...

PHP: How to know when exec() function is finish?

I have an exec function in php file that execs a bash script. It script calls fmpeg to transcode a video file. How can I know when transcoding is finish?? $script = "/opt/lamp../name.sh" exec("$script $videoIn $id") I will try using next code but it doesn't workd. if (exec("$script $videoIn $id")) { //print on screen that the vide...

PHP 1-liner each() with mysql_fetch_assoc()

Hey All. Trying to create a 1-liner to loop through a mysql result set. Example: $sql = "SELECT uid, role FROM usr WHERE uid = '$this->uid'"; $r = db::q($sql); if($r->rows()) { $q = mysql_fetch_assoc($r->result); while(list($k, $v) = each($q)) { // would like to omit line above and consolidate here $_SESSION['usr'][$k] = $this...

PHP: URL detection (regexp) includes line breaks

I want to have a function which gets a text as the input and gives back the text with URLs made to HTML links as the output. My draft is as follows: function autoLink($text) { return preg_replace('/https?:\/\/[\S]+/i', '<a href="\0">\0</a>', $text); } But this doesn't work properly. For the input text which contains ... http://...

PHP show image if post result equals

I have a form that posts to a page. I want to display an image if the value of the item posted equals "paypal". I need to write something that says; if $_POST['method'] equals "paypal" then show paypal.gif if $_POST['method'] equals "mastercard" then show mastercard.gif I hope I made a bit of sense, new to php trying to learn the ...

Is there a major downside to using .htaccess files in your svn/git repository?

If our .htaccess files are purely for mod rewrites, is there a security / development downside to committing .htaccess files alongside other files in your repository? For various reasons (our SEO optimisers like to add pretty urls as new promotions occur, etc) we need a fair few rewrite rules inside these files. Would I be better off pu...

Randomly select file in PHP

I'd like to use the 'include' keyword in php to randomly select a file from a folder and output the contents. How would I do this? Thanks. ...

php mysql search in 2 columns in 2 tables.

Hey, I have two tables in one DB, one called Cottages and one called Hotels. In both tables they have the same named fields. I basically have a search bar that i want it to search in both of the fields in both of the tables. (the two fields being called "Name" and "Location" SO far I have $sql = mysql_query("SELECT * FROM Cottages W...

problems with UTF-8 encoding in PHP

Hi guys, The characters I am getting from the URL, for example www.mydomain.com/?name=john , were fine, as longs as they were not in Russian. If they were are in Russian, I was getting '����'. So I added $name= iconv("cp1251","utf-8" ,$name); and now it works fine for Russian and English characters, but screws up other languages. :))) ...

Break up PHP Pagination links

I have the following method that creates and returns markup for my pagination links in PHP. public function getPaginationLinks($options) { if($options['total_pages'] > 1) { $markup = '<div class="pagination">'; if($options['page'] > 1) { $markup .= '<a href="?page=' . ($options['page'] - 1) . ((isset($op...

Does this mySQL Stored Procedure Work?

Hi, I got the following stored procedure from http://dev.mysql.com/doc/refman/5.1/en/functions-that-test-spatial-relationships-between-geometries.html Does this work? CREATE FUNCTION myWithin(p POINT, poly POLYGON) RETURNS INT(1) DETERMINISTIC BEGIN DECLARE n INT DEFAULT 0; DECLARE pX DECIMAL(9,6); DECLARE pY DECIMAL(9,6); DECLARE ls...

Can't retrieve an id through swfupload

I'm having trouble retrieving an echoed ajax response through SWFupload. Upon uploading a file, my account.php?action=uploadphotographs echos the number 37, the text field hidFileId should then be updated with this data. I'm not sure if the file is ever properly being submitted. Is there something wrong with my code? Heres a link to ...

how to have defined connection within function for pdo communication with DB

hey guys I just started trying to convert my query structure to PDO and I have come across a weird problem. When I call a pdo query connection within a function and the connection is included outside the function, the connection becomes undefined. Anyone know what I am doing wrong here? I was just playing with it, my example is below. i...

PHP and use of the Num_Of_Rows() function?

Below is some PHP code that i have written, the problem occurs when it gets to the use of the num_of_rows(), it just does not seem to work and i cant figure out why? <?php try { $divMon_ID = array(); $divMon_Position = array(); $divMon_Width = array(); $divMon_Div = array(); $db = new PDO('sqlite:db/EVENTS.sqlite');...

Force download working, but showing invalid when trying to open locally.

Hi, I wrote this function and everything works well till i try to open the downloaded copy and it shows that the file is invalid. Here is my function function download_file() { //Check for download request: if(isset($_GET['file'])) { //Make sure there is a file before doing anything if(is_file($this->path ....

Propel automatic form

Hi, I'm just starting with Propel and for more rapid development I'm curious if there is anything like automatic forms. Something like default administration in Django. I want to be able to output a form or to get all information I'll need. Even in the objects I didn't find all information which should be necessary to have everything for...

replace spaces with _ in php

i am trying to replace spaces in the following var $e_type = 'Hello World TEST'; ca anyone help me please ...

Google Contacts Data API and PHP

I'm developing a PHP application to retrieve the list of contacts from a GMail account. I'm looking for a solution which would enable the user of my application to provide the login and password to their Gmail account in my application (as opposed to getting redirected to Google) and then automatically do the retrieval. The retrieval pro...