LRNPHP

Hi guys, I'm busy testing storing PHP variables in a MySQL table but I'm having difficulties using them as variables when pulling them from MySQL. When I pull the variables is displayed as a normal string and I'm not able to use them as a variable. Is it possible to …

Hi guys, I'm working on a project and wanted to know if there is a good / trusted way to break a string apart into words. I want to get all the words in a string that will be used in a mysql query. I tested with str_word_count but it …

Hi There, I'm checking if I can get all the occurrences of a variable in a php file. What will the best and easest method be? Any help is greatly appreciated. Regards

Hi Everyone, I haven't started coding or anything but I need to know if it's possible to read a file from last read position? I want to read a file and dump the content into a MySQL database but don't want to read the entire file from start to end …

Hi Everyone, I'm trying to import a ever changing CSV into MySQL on the fly, there is constant data being aded to the file and don't to everything every time. Is there a way to add new data only? Kind Regards

Hi Everyone, I'm building an app that inserts data into table A, then I want a trigger to kick off before new data is inserted into table B to confirm that the value exists in column string_Value and then take the data and add it into TABLE C. Is this …

Hi There, Hope everyone is doing well, I'm busy with developing a page but would like the user to be able to add rows Dynamically with PHP. This row will contain columns Example: <tr> <td rowspan="2" align="center" valign="top">Value A</td> <td height="24" align="center" valign="top">Value B</td> <td rowspan="2" align="center" valign="top">Value C</td> <td …

Hi All, I'm battling to get this query to work. I have a select form that allows user to select dates. When he submits it it needs to remove weekends from the request. $DateStart='2013-09-01'; $DateStart='2013-09-05'; $DateSTR=strtotime($DateStart); $DateSTO=strtotime($DateStop); for($i=$DateSTR; $i<=$DateSTO; $i++){ $NewDate=strtotime($i); $DateCalc=date('D', $NewDate); $TotalCount++; if($DateCalc == 'Sat' || $DateCalc == …

Hi Everyone Could someone assist me in a PHP / MySQL dropdown select menu. I want to pull info from my DB and display it, then when I select the option it need's to reload screen and add a second drop down select menu. When I select the 2nd one …

Hi There, I'm busy developing a PHP / MySQL billing system for our company but can't seem to get the following working for me. I need to have 1 page that will display the extensions billing period / month for local, national and international calls and it needs to be …

Hi There, I'm very new to Python. Is there a easy way of looping trhough a file and using the values in a grep command? [code] Value A Value B 2011-12-14 20:54:09, 797410378, 2011-12-14 20:55:52, 734451141, 2011-12-14 20:56:30, 796058907, 2011-12-14 20:59:51, 736280553, 2011-12-14 21:09:42, 729858848, 2011-12-14 21:12:02, 825895818, 2011-12-14 21:13:53, …

Hi All, I'm going crazy with this. I have a file called unique.txt with allot of values in. When I run my script it will add 1 value (1319613308.476855) to my value file but when I grep the value it displays nothing and I know the value is present in …

Hi There, MySQL is not my strong point so any guidance or advice will be greatly appreciated. I want to know what's the best way of linking multiple MySQL tables together. I have +-10 tables that will interact with each other. Example Tables : users, logins, communication, sightings etc. When …

Hi There, I would like to know if it's possible to use or what I could use to get the required results. The values [code] +2711 081 076 086 080 9011 6547082 9013 9039 9086 9041 +27084 substring(table,length(tbl_code),length(tbl_code))=trim(tbl_code) [/code] I have different values lengths in my MySQL table that's not …

Hi There, I have 2 tables, one with dst codes and one with fees. I want to match the fees with the dst code. I've been trying a for loop but it's not working 100%. What is the best way of matching dst code with the corresponding fee? If TABLE …

Hi Everyone, I'm looking for a nice menu, I have something like this in mind. [url]http://www.andrewsellick.com/examples/tabslideV2/[/url] I just need 2 menu's. One on the left and the other on the right. When I move my mouse over it it should drop down with a short description. Any help or pointers …

Hi There. Is it possible to use the LOAD DATA LOCAL INFILE command from a crontab or what will the best way be of importing a csv on a hourly basis. Regards

Hello anybody! I have some idea and I don’t know if it will work. I am planning to make a user management system using the mysql database but the problem is I don't know where to start because in MySQL database the password is encrypted with password() function and it …

Hi Everyone. Could anyone give me some pointers in creating a PHP, MySQL ShortCode system. I want to create a system where a user can SMS a keyword to a short code SMS number. [B]Example:[/B] [COLOR="Red"]SMS pizza to 33333[/COLOR]. Then the server checks pizza in MySQL DB and replies with …

Hi Everyone. I'm busy with a advanced search function, what I want to do is when a client clicks on a tab/button it should open a windows where he can define his search even more. If anyone could point me in the right direction of what I can use or …

Hi everyone. I want to add a advanced search function to a demo site I'm doing but have no idea where to begin on this. I'm using a MySQL Db for all the site and PHP to pull data from DB. Any suggestions are welcome. Regards

Hi everyone. Could some assist me? I have a link. [code] <a href="index.php?make=<?=$mead_make?>&model=<?=$model?>&veh_id=<?=$vehicle_id?>">Add to Cart</a> [/code] This HREF link is generated by a for loop from a mysql DB. All I want to do is add the veh_id to a array and keep adding them to a array until I …

Hi Everyone. Could someone assist me in the query. The table has type_of_vehicle field. In this field I have A, B and M. I would like to create a query where I can specify to select A and B, or A and M or A,B,M. Hope someone could assist me …

Hi Everyone. I have a page were I need to give the viewer the option to add their choice to a shortlist. Is it possible to do this in a pure PHP / MySQL environment? Regards

Hi Everyone. Can someone assist me? I'm pulling data from a DB, If the first value is empty it should check the second one and if that is also empty assisgn value. Hope it's understandable. Regards [code] if(empty($veh_img)){ $galpic="image.gif"; }elseif(empty($disk_img)){ $galpic="image.gif"; }else{ $galpic="$disk_img"; } [/code]

Hi Everyone. Can some please assist me. I'm trying to create a login script. This is what I've done so far. This works if user's input is correct. But when the user input is incorrect I get a blank screen. I think my problem lies in the $SQLPASS statments. Any …

Hi Everyone. I have a quick question. I have 2 checkboxes. One yes and other no. I want only one to be checked at a time. Example : if yes = checked uncheck no. if no = checked uncheck yes [LIST=1] [*]Is it possible with PHP or should I try …

Hi There. Does anyone have a php select option that will pull data from mysql DB and populate next select option with data. I need to have 3 select option. I also want to run mysql query with data from all 3 select options. Thanks Regards

Hi everyone. Could someone assist me with a problem I have. I want to display images in a folder.(image/). I have my MySQL table with my images location.(images/test.jpg) etc. I also have a legend_id where I specified id's (id_1, id_2, id_3) This is linked to cars. If I search according …

Hi Everyone. I have MySQL db with images in(MEDIUMBLOB); I would to display the images in a gallery fashion with a MySQL select command. Any help would be appreciated. Regards