396 Posted Topics
 | Hi, How do i check result of out parametter of stored procedure in php? [code] CREATE PROCEDURE `username`(IN name_in varchar(10), OUT name_out varchar(10)) BEGIN SELECT name FROM table WHERE name= name_in; END; [/code] [code] //This always returns 1 even there is no record in the table. $query = "CALL username($name, … |
| | Hi, I have a directory called "mysql5.0.51a" in C:\wamp\ It says "invalid directory", when i type (in command prompt) C:\wamp\>CD mysql5.0.51a Why do you think this is? "mysql5.0.51a" is in wamp as well. I have a lot of files in it aswell. Windows XP Prof. Thanks |
| | Hi, How do you restore all the settings to default in Office 2007? Thanks |
| | Hi, I have a cookie with 5 products. There will be a loop to read one by one and reduce from stock in database for each product. Now, If something goes wrong half way through i want to cancel whole transaction. For example; everything went ok for first 3 products … |
| | Hi, MySQL function below is not working. I cant find the mistake. Can you help me? Thanks [code] CREATE FUNCTION testVAT(DECIMAL(4,2)) RETURNS DECIMAL(4,2) DETERMINISTIC BEGIN DECLARE myVAT DECIMAL; SET myVAT = (myMoney * 0.17); RETURN myVAT; END; [/code] |
| | Hi, I have 2 tables in each page. when i have more than 1 page, tables are breaking into other pages. Like, end of the one table appear in next page. How can i do it stable. Because, when i print, i want each page have 2 tables without any …  |
| | Hi, I want to create a form with 2 textboxses(starting number and ending number) and 1 button. When i click on button it is going to list all the records between two numbers in a report. How can i do this? Thansk |
| | Hi, I use a submit to POST a data to page1.php. When i am in page1.php, I go to another page. But when i want to come back, page1.php is not displayed. I know it is about POSTed data but How can i prevent this issue? Thanks  |
| | Hi, [code] function myWindows(link) { if (!window.focus) return true; var href; if (typeof(link) == 'string') href=link; else href=link.href; window.open(href, 'width=5000,height=500,scrollbars=yes'); return false; } } [/code] [inlinecode]<a href=2bla.php" onClick="return myWindows(this)">Open</a>[/inlinecode] Above code opens new plain windows. How can i do same thing with a submit button? It will be plain as …  |
| | Hi, How can i read the OUT parameter of a MySQL stored procedure in PHP with using mysql not the mysqli? Thanks |
| | Hi, I navigate throught the pages in my php project. When i click back button in Internet Explorer to go back to previous page, it displays common "The page cannot be displayed" error. What do i have to add into my php code to overcome this problem? Thanks |
| | Hi, Stored proc code below works fine in MySQL command prompt. It returns John because it is in table. However, i can't return or read the Out parametter in PHP. I mean i cant retrieve John. I did ask this in PHP forum but no answer. [code] CREATE PROCEDURE `findname`(IN … |
| | Hi, I have checked several examples but, i couldn't do the pagination. Please help me because i simply can't do it. I am stuck with my assignment because of this. Table is shown below. Thanks [code] CREATE TABLE `country` ( `code` varchar(255) default NULL, `rank` int(11) default NULL, `name` varchar(255) … |
| | Hi, How can store [inlinecode]$_SESSION['id']="myId";[/inlinecode] for 5 hours? I tried cache thing but, when i closed IE it expired. When i echo $_SESSION['id'], it doesn't return any value. Thanks [code] session_cache_expire(150); session_start(); $_SESSION['id']="myId"; [/code]  |
| | Hi, I want a messagebox or alert to appear in my screen after i click on a link. I can do popup windows but i can't do this. How do i this? Thanks |
| | Hi, Ho do i find out which month has how many days with PHP? Ok July is 31 days but, how can i calculate it? Thanks |
| | Hi, I used to watch online tv before but now, picture is blur (blue, yellow, pink ...) coloured. I was ok before, i don't know what happened? Any idea? I hope this is right place to ask! Thanks |
| | Hi, How do we increase and decrease a counter when we click on a selectbox? Example: I have 3 selectbox. Whenever i click on one selectbox it will print on screen a message 1 selected, 2 selected 3....... Thank you very much |
| | Hi, I have a table and i want to list details in list.php with pagging style. 2 record each. I can't do it. Can anyone help me. I have tried some examples but, i couldn't do it. Please help. Thanks [code] CREATE TABLE `country` ( `code` varchar(255) default NULL, `rank` … |
| | Hi Code below generates this error "Table 'sis_audit.pay' doesn't exist". [code]UPDATE pay SET Ref='111', date='2008-11-11' WHERE id=29[/code] When i create same table in different database, no error at all. Why? Thanks |
| | Hi, How do we save person's pictures in database?Do we just create column "pictutePath" and enter this value "../pictures/user1.jpg" for each person or is there any other way? Thanks  |
| | Hi, I have 2 textbox and 2 buttons in my form. Seperatly, Button 1 will validate textbox 1 and Button 2 will validate textbox 2, if they are empty or not. How can we do it? Thanks |
| | Hi, i use php mailler to send email but i don't know how to add <br> or <p> breaks into message that comes from other page with $_POST. I need it because message appears in email as an one long line. [code] $mail->Body = $_POST['message']; //Not fine $mail->Body = "Hi,<br>How … |
| | Hi, I print a HTML table with background colour but, it doesn't print it with colours. Why? Thanks  |
| | Hi, Code below sends values to the test1.php with button. Is there any way to use <a> link to do same thing? Thanks [code] <form method="post" name="form"> <input type="text" name="name" /> <input type="submit" name="submit1" value="submit1" onclick="javascript: form.action='test1.php';" /> </form> [/code] |
| | Hi, I use the "login.php" to login to my site, i want store all the sessions in "sessions.php" after login process. When i go to other pages, i simply want to require "sessions.php" to be able to use sessions in those all pages. Is this logis possible? If so, how … |
| | Hi, Code below returns true for (.). It should return false like it returns false for (,). Is there any other way to check (.) and (,). I simply want validate money. Thanks [code] if (isNaN(form1.paid.value)) { alert ("Syntax is not right."); return false; } return true; [/code] |
| | Hi, When i hit the F5 to refresh the page, sql statement in that page runs again. It means last insert, update or delete process is triggered again. How can i solve this problem. Is it necessary for me to do insert, update or delete processes in other pages to … |
| | Hi, I want to send authenticated mail in php. i know smtp and phpmail classes. Is there anyone to help me? I have followed scripts on net but, i couldn't send an email. Anyone with working solution? Thanks |
| | Hi, I can't send authenticated email from phpmailer. Code and error are shown below. If SMTPAuth is false then mail goes only to my mail. Everyting under C:\wamp\www\phpMailer. I didn't do any changes in "class.phpmailer.php" file. Thanks Error: "Mailer Error: SMTP Error: Could not connect to SMTP host." Code: [code] … |
| | Hi, I need to send email with authentication. I have downloaded class.smtp.php and class.phpmailer.php files. I have tried to send an email but, i thing i miss something. Therefore, i cant send it. Can anyone help me to do this? Thanks guys 1-What settings do i need to do in … |
| | Hi, I just wanted to share this information with you to be able to send email via php. It works fine to me. Go to php.ini file and find the line below; (Do changes according to your settings.) php.ini [code] [mail function] ; Setup for Windows systems SMTP = your …  |
| | Hi, When i click one checkbox code below workes fine but, more than one, noo. I cant find the problem. Can you help me please? Thnaks 1st page. [code] <td><input type="checkbox" name="checkboxReceipt<?php echo "[$newArray[id]]"; ?>" value="<?php echo $newArray['id']; ?>" id="checkboxReceipt"></td> [/code] 2nd page. [code] if (isset($_POST['checkboxReceipt'])){ $sql="UPDATE payment SET"; foreach … |
| | Hi, I insert data into database with submit button. When insert is successful, a message box appears on the screen which is shown below. Now, user must click on "Ok" on that message to be able to continue. Is this effect concurrency in MySQL database because, several people use this … |
| | Hi, If i select 1 or 2 in "selectPay" then, "selectDate" should be filled with [icode]"Select date From acc Where date=1 (Or 2)";[/icode] How can i do this? Thanks [code] <select name="selectPay"> <option value=""></option> <option value="1">Pay 1</option> <option value="2">Pay 2</option> </select> <select name="selectDate"> <option></option> </select> [/code] |
| | Hi, I create dbf.php file to connect database and require dbf.php in main.php but, doesn't work. Thanks dbf.php [code] <?php $conn = mysql_connect('localhost', 'root', ''); if (!$conn) { die('Could not connect: ' . mysql_error()); } else { mysql_select_db('dbf', $conn) or die('Could not select database.'); } ?> [/code] main.php [code] <?php … |
| | Hi, What should i do for "logout link" to clear "login session" because, when i click "logout link", i can come back to same page without any problem with clicking on back button on the IE. Thanks |
| | Hi, Javascript below doesn't work. It always retuns false. Where is mistake? thanks [code] <script Language="JavaScript"> function validateAreas(){ if (document.form1.selectS.value=="") { alert("Please select a S"); form1.selectS.focus(); return false; } return true; } </script> <form name="form1" method="post" action="" onSubmit="return validateAreas();"> ..... <select name="selectS"> <option selected="selected"></option> <?php $q="SELECT id FROM spp"; $run=mysql_query($q); … |
| | Re: While statement [code] <?php while ($i<50) { $result=$i%2; if ($result==0) { echo "$i"; echo "<br>"; } $i=$i+1; } ?> [/code] |
| | Hi, I'll create a Login.php page to check uid and password and let user login to the system. Now, do i check uid and password in same Login.php or i post uid and password to next page to be checked there? What is the best way? Thanks |
| | Hi, I get this error on red coloured line. "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\.....". I use PHP 5.25, MySQL 5.51. [code] $sql="SELECT * FROM customer"; $run = mysql_query($sql); [COLOR="Red"] if (mysql_num_rows($run) > 0) {[/COLOR] .... } [/code] When there is record it …  |
| | Hi, I have "Balance" table that is shown below. Table :Balance todaysDate/openBalance/closeBalance ------------ --------------- -------------- 2008-07-24 250000 100000 Above record will be inserted into next row as it is at 10:00pm. How do i do this? Thanks  |
| | Hi, I retrieve all students from database with adding submit buttons along with them. For example; when i click on 3rd student’s submit button, it gives me information of last retrieved student. How can solve this problem? Note : All action is in same page. Thanks [code] <?php while ($myArray … |
| | Hi, I have textboxes and combos in a form with submit and clear button. When i submit all values in textboxes and combos remain same. How can i clear them when i click on clear button. Or reload the page? Thanks |
| | Hi, I have a form with 3 submit buttons. This is what i want; Click on button1, form action becomes 1.php Click on button2, form action becomes 2.php Click on button3, form action becomes 3.php I dont want to enter action manual. How can we do this? Thanks |
| | Hi, How can i pick next or prevoius day in mysql? Any function like curdate() ? Thanks |
| | Hi, [inlinecode]Select closing From balance Where account_no = 12 Limit 1[/inlinecode] returns an error "You can't specify target table 'balance' for update in FROM clause" Where is mistake? Thanks [code] AFTER INSERT ON Close BEGIN Insert into balance (date, opening, account) Values (CURDATE(), (Select closing From balance Where account_no = … |
| | Hi, Can we set a schedule for Mysql triggers in "Scheduled tasks" of Windows XP. Thanks |
| | Hi, Code below is wrong but i can't find the mistake. [code] Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE()); if ISNULL(@RecAdj) set @RecAdj:= 0; end if; [/code] Or is there any other way? Thanks |
| | Hi, I want to create a form for retoprt section in my VB6 project. What do i add into my form and from where? Thanks  |
The End.