619 Posted Topics
 | Ohh man... Big code. Try to minimize your question thread. You will get more answers.Its bit tidy to read all your code. |
| | Re: checkbox problem [I]suppose a user check the checkbox & there is some validation error while submiting,[/I] Are you validating form in PHP side? |
| | You need cronjob dear. In cronjob you can set php file name and time interval that will execute that php file. e.g. you have sendnewsletter.php and set time 'every night 12am'. Server will call that file daily at 12am, thats it.. all is done. Cronjob setting is in server's hosting …  |
| | Just a random hour have nothing to do with time function. [CODE] <? echo rand(1, 12); ?> [/CODE] OR do you want random date? |
| | better to use BCC. It may because of execution time. Use below function for overcoming time limit. [CODE] set_time_limit(0); [/CODE] |
| | Hi all, I have seen below icon in thread listing. [URL="http://images.daniweb.com/vbulletin/statusicon/thread_hot.gif"]http://images.daniweb.com/vbulletin/statusicon/thread_hot.gif[/URL] I think it will be described on dani but did't find it. Just want to ask what does it means? Thanks. |
| | |
 | so final code is: [CODE] <?php $totala ="0"; $numrows ="10"; //QUERY $extract = mysql_query("SELECT * FROM invoicedata WHERE invnum='$invnumber' limit 0,10"); //FIND DATA AND ASSIGN while ($row = mysql_fetch_assoc($extract)) { $items = $row['item_description']; $prices = $row['item_price']; $quant = $row['item_quantity']; $itemvat = $row['item_vat']; $subanswer = $prices * $quant; $totala = $totala … |
| | Didn't get your logic. You are searching from id and want id of searched field ?? |
 | Check this jquery file upload, it may help you. [URL="http://www.fyneworks.com/jquery/multiple-file-upload/#tab-Examples"]http://www.fyneworks.com/jquery/multiple-file-upload/#tab-Examples[/URL] |
| | Just add one new hidden field with quantity name. [CODE]<input type='hidden' name='quantity' value='3'>[/CODE] Above will show 3 quantity on paypal page. |
| | Hi All, I have win7 and we have some computers in LAN. Now i want to remotely access my friend's computer.We are developers and want remotely help each other without moving here and there. I know these two option.Windows remote assistance, remote desktop connection. When i connect using remote desktop … |
| | Why you want type casting? I mean if want to insert posted data in database you can directly insert it without casting. |
 | Re: Help with code I have changed a bit. [CODE] <html> <head> <title>Title Here</title> <link rel="stylesheet" href="/offline/maintenance.css" type="text/css" /> </head> <body> <?php // Make a MySQL Connection mysql_connect('localhost', 'dbuser', "dbpass") or die(mysql_error()); mysql_select_db('dbname') or die(mysql_error()); // Retrieve all the data from the "example" table $result = mysql_query('SELECT * FROM sitesettings') or die(mysql_error()); $row = … |
| | Check this. [CODE] <? echo $strDate = substr('Wed Jun 15 2011 00:00:00 GMT 0530',4,11); echo '<br />'.date('m/d/Y', strtotime($strDate)); ?> [/CODE] |
 | You have changed old database credentials to new. Check your new database's credentials proper.I think it should not be username:root for host:localhost. Something went wrong with credentials only. |
| | If you are fetching records from database you can directly get values using mysql_fetch_assoc. [URL="http://in.php.net/manual/en/function.mysql-fetch-assoc.php#example-1472"]example link[/URL] |
| | It is possible with JS, not sure for PHP. What is your exact requirement? If flash is not installed then what you want to do? |
| | Try below code. And post output you are getting. [CODE] <? $insertQuery = "ALTER TABLE atable ADD `".$example."` INT"; $result = mysql_query($insertQuery); if (!$result) { die('Invalid query: ' . mysql_error()); } else { echo 'Successfully executed'; } ?> [/CODE] |
| | This paypal standard blog is cool. May be help you. [URL="http://leepeng.blogspot.com/2006/04/standard-paypal-php-integration.html"]http://leepeng.blogspot.com/2006/04/standard-paypal-php-integration.html[/URL] |
| | Because you haven't provided header after your logic. Lets your page name is 'page.php'. [CODE] <? if(condition) { // your // message // sending // code [COLOR="Red"]header("location:page.php"); exit;[/COLOR] } ?> [/CODE] |
| | You can also use ternary operator for minimizing code. [CODE] <tr> <td ><span class="style2">1</span></td> <td >PERAK IP-F002</td> <td style="background-color:<?=($a1==1)?('#00FF00'):('#FF0000');?>"> </td> <td style="background-color:<?=($a2==1)?('#FF0000'):('#00FF00');?>"> </td> <td style="background-color:<?=($a3==1)?('#00FF00'):('#FF0000');?>"> </td> </tr> [/CODE] |
| | Re: ajax help If you just want proper date format. check this [URL="http://jqueryui.com/demos/datepicker/default.html"]http://jqueryui.com/demos/datepicker/default.html[/URL] And if you want ajax any how then see here [URL="http://api.jquery.com/jQuery.ajax/"]http://api.jquery.com/jQuery.ajax/[/URL]. Check how ajax work and then you can implement your logic. |
| | Re: Joining Tables You forget two commas in field selection after qTodaysLow and qCurrentPERatio shown in red color. Give space after qQuoteDateTime. [CODE] $query = "SELECT symSymbol, symName, symMarketCap, qSymbol, qQuoteDateTime, qLastSalePrice, qNetChangePrice, qNetChangePct, qTodaysHight, qTodaysLow[COLOR="Red"], [/COLOR]" ."qShareVolumeQty, qPreviousClosePrice, qBidPrice, qAskPrice, q52WeekHigh, q52WeekLow, qCashDividendAmount, qEarningsPerShare, qCurrentPERatio[COLOR="Red"], [/COLOR]" ."qCurrentYieldPct, qTotalOutstandings FROM symbols LEFT JOIN … |
| | Re: T_CASE Error ? There is one extra brace before break. [CODE] echo '<meta http-equiv="refresh" content="0;URL=yazi.php?id='.$id.'">'; } [COLOR="red"][B]}[/B][/COLOR] break; } ?> [/CODE] |
| | Here is a bit change in login code. [CODE] $results = mysql_query($login) or die(mysql_error()); if(mysql_num_rows($results) == 0) { echo "Invalid login"; exit; } else { echo "Successfull Login"; exit; } [/CODE] |
| | Re: php cron job There are linux commands for it. But better to go with hosting panel e.g. cpanel link [URL="http://www.siteground.com/tutorials/cpanel/cron_jobs.htm"]http://www.siteground.com/tutorials/cpanel/cron_jobs.htm[/URL] |
| | You have to create one mysql table where you can store which user have which image. Then on delete link you can delete from table. |
| | Yes you have to add every input to a session variable on page 2. Post your code with CODE tag for more detail. |
 | Check this demo. [URL="http://gmaps-samples.googlecode.com/svn/trunk/poly/mymapstoolbar.html"]http://gmaps-samples.googlecode.com/svn/trunk/poly/mymapstoolbar.html[/URL] |
| | For adding data in mysql: html_entities(mysql_real_escape_string($variable)); For echoing: html_entity_decode(stripslashes($variable)); |
| | Re: PHP with Jquery Check this.. [CODE] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script language="javascript" src="http://code.jquery.com/jquery-1.6.1.min.js"></script> <script> function chooseGender() { var selectGender = $('input[name=gender]:checked', '#submitgender').val(); if(selectGender) { $.ajax( { type: "POST", url: "ajax.php", data: "gender="+ selectGender, success: function() { $("#submitgender").hide(); $("#rest").show(); } … |
| | Try this. [CODE] RewriteEngine On RewriteRule ^download\.php\?file\=([^/]*)$ /?d=$1 [L] [/CODE] |
| | Try [CODE] $radmin="SELECT * FROM ".self::$admin; [/CODE] |
| | |
 | Try this code. [CODE] $q = preg_replace('/\s\s+/', ' ', $q); // remove extra spaces $sql = "SELECT *,CONCAT(FirstName, ' ',LastName) as fullname WHERE CONCAT(FirstName, ' ',LastName) LIKE CONVERT(_utf8 '%".$q."%' USING latin1) COLLATE latin1_swedish_ci "; [/CODE] |
| | you need to replace this line. [CODE] mysql_query("SELECT*FROM Products='"$result"'"); [/CODE] to [CODE] $result = mysql_query("SELECT * FROM Products"); [/CODE] |
 | Below is normalization. Field names are self explainable. Also as urtvi suggested check event uniqueness. [CODE] ==================== Table Name : event ==================== eventId eventTitle date 1 Seminar 2 Robotics 3 AI ==================== Table Name : user ==================== userId fullName email 1 John [email protected] 2 Tanya [email protected] 3 Mathew [email protected] =============================== … |
| | Use array in field name. When form is submitted using foreach delete each element. [CODE] <?php if(isset($_POST['delete'])) { $checkboxAll = $_POST['checkbox']; foreach( $checkboxAll as $key=>$del_id ) { $sql = "DELETE FROM Inq_cat WHERE Inq_id='$del_id'"; $result = mysql_query($sql); } header("location:index.php"); exit; } ?> <form name="frm" id="frm" method="post"> <input name="checkbox[]" type="checkbox" value="1" … |
| | Hello All, When i see my 'Latest Reputation Received' in list some icons are green and some are blue. Is there any meaning for it? See attached image. Thanks, Vibha |
| | |
| | |
 | Re: AJAX Once you know basics of AJAX, jquery provides a good way to use it. [URL="http://api.jquery.com/jQuery.ajax/"]http://api.jquery.com/jQuery.ajax/[/URL] |
| | |
 | Re: Email Problem Sometimes if you are continuously sending emails from one email address to second email address. Email server automatically forward it to spam after some attempts. Also check mail function header contents like from name and from email. |
 | Where is inactive_batch field? Post complete code in CODE tags. |
| | It is just a notice. You can ignore it and stop getting error message by [CODE] <?php error_reporting (E_ALL ^ E_NOTICE); ?> [/CODE] |
| | [URL="http://phpcrawl.cuab.de/example.html"]http://phpcrawl.cuab.de/example.html[/URL] |
| | Use square bracket. [CODE] $keyarray[$i] = $tranrec[0]; [/CODE] |
| | Formatted email [CODE] <?php $groupname = $_REQUEST['groupname'] ; $info = $_REQUEST['info'] ; $size = $_REQUEST['size'] ; $special = $_REQUEST['special'] ; $firstname =$_REQUEST['firstname'] ; $lastname = $_REQUEST['lastname'] ; $address1 = $_REQUEST['address1'] ; $address2 = $_REQUEST['address2'] ; $city = $_REQUEST['city'] ; $prov = $_REQUEST['prov'] ; $email = $_REQUEST['email'] ; $phone1 = $_REQUEST['phone1'] … |
The End.