Linux, Apache, MySQL, PHP

Re: Voice recording in php website??

16-Aug-11 23:18

Is there any free solution for voice recording in php?

cjoki17-Aug-11 9:39

cjoki

17-Aug-11 9:39

You will need to find out for yourself. Try running that google query with free tossed in. Otherwise just start looking through the results you get from google. This will als o giv you a basic idea as to how they did it, like what tools or language features did they use.

best of luck!

Chris J
www.redash.org

insert multiple database table row from dynamic checkboxes from db

sir_amin12-Aug-11 1:57

sir_amin

12-Aug-11 1:57

hello there

i have a form for submiting data into mysql table with the name of TERM_LESSON table in this form i have a sets of checkboxes that came from a table with the name GRADE these are my two tables:
TERM_LESSON

SQL

CREATE TABLE IF NOT EXISTS `term_lesson` (
  `lid` int(5) NOT NULL,
  `gradeid` int(1) NOT NULL,
  
  PRIMARY KEY (`lid`,`gradeid`)
) ENGINE=MyISAM ;

GRADE

SQL

CREATE TABLE IF NOT EXISTS `grade` (
  `gradeid` int(11) NOT NULL AUTO_INCREMENT,
  `gname` varchar(40)  NOT NULL,
  PRIMARY KEY (`gradeid`)
) ENGINE=MyISAM  AUTO_INCREMENT=0 ;

and this is my form:

HTML

<!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>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" method="post" id="form1">
                            <table align="center">
                              <tr valign="baseline">
                                 <td align="right">LID</td>
                                <td">
                                
                                <input name="lid[]" type="text" id="lid[]" value="<?php echo $row_rslesson['lid']; ?>" size="32" readonly="readonly" />
                                </td>
                               
                                
                              </tr>
                                <td >GRADE</td>
                                <td >
                                  <?php do { ?>
                                  <input name="gradeid[]" type="checkbox" id="gradeid[]" value="<?php echo $row_rstotalgrade['gradeid']; ?>" />
                                  <label for="gradeid[]"></label>
                                  <?php echo $row_rstotalgrade['gname']; ?><br />
                                <?php } while ($row_rstotalgrade = mysql_fetch_assoc($rstotalgrade)); ?></td>
                              <tr valign="baseline">
                                <td style="text-align: center"></td>
                                <td align="right"><input type="submit" value="submit" /></td>
                               
                              </tr>
                            </table>
                            <input type="hidden" name="MM_insert" value="form1" />
                          </form>
</body>
</html>

i want to make a TABLE ROW in TERM_LESSON for every checkboxes that is selected by user with same LID in form like: (for 2 chekbox seledted)

lid gradeid
11 , 1
11 , 2

and this is my php code for doing that:

PHP

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
	
  foreach ($_POST['gradeid'] as $i) {

  $insertSQL = sprintf("INSERT INTO term_lesson (lid, gradeid) VALUES (%s, %s)",
                       GetSQLValueString($_POST['lid'], "int"),
                       GetSQLValueString($i, "int"));

  mysql_select_db($database_register, $register);
  $Result1 = mysql_query($insertSQL, $register) or die(mysql_error());
  }
  $insertGoTo = "lesson_term_added.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_register, $register);
$query_rstotalgrade = "SELECT * FROM grade";
$rstotalgrade = mysql_query($query_rstotalgrade, $register) or die(mysql_error());
$row_rstotalgrade = mysql_fetch_assoc($rstotalgrade);
$totalRows_rstotalgrade = mysql_num_rows($rstotalgrade);
?>

but when i submit the form i face to this error :

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\register\admin\add_lesson_term.php on line 11
Column 'lid' cannot be null

i appreciate any idea.

with prior thanks

help me (PHP beginner)

Ahmad Alweshahi11-Aug-11 6:11

Ahmad Alweshahi

11-Aug-11 6:11

I wanna some one please advise me where can i begin to learn PHP and have a good experience

Mohibur Rashid11-Aug-11 18:51

11-Aug-11 18:51

That is interesting.......

if you have experience with other programming language, i think you can start learning php.

If you dont know any other programming language, i am sure you are going to be slow.

You can collect a book. I started learning PHP reading a book published by Wrox publications. written bye 4 writer. i dont remember the name.

And about being professional?: start career as trainee somewhere. If you have the quality to be a programmer you will be.

Otherwise without real work there is no way being professional

Ahmad Alweshahi12-Aug-11 1:03

Ahmad Alweshahi

12-Aug-11 1:03

thanks so much Johny
i am already knowing a programming language
and i learned about php but i stopped in session and cookies and can't complete till understand these subjects so thanks so much for ur care .

User 171649212-Aug-11 0:16

User 1716492

12-Aug-11 0:16

There is a huge variety of books, internet tutorial resources and video tutorials. I'll give you just a few ...

Books :

Beginning PHP and MySQL 5: From Novice to Professional, Second Edition by W. Jason Gilmore. Apress Publishers.

The PHP Anthology: Sitepoint Publishing

PHP Solutions: Dynamic Web Design Made Easy by David Powers.

Internet Tutorials :

PHP 101 series http://devzone.zend.com/node/view/id/625[^]

PHP Essentials : http://www.techotopia.com/index.php/PHP_Essentials[^]

Learning PHP series www.ibm.com/developerworks/opensource/tutorials/os-phptut1/[^]

Video Tutorials

Killer PHP www.killerphp.com/[^]

NetTuts+ www.net.tutsplus.com[^]

And don't forget to include CodeProject, there are some resources here, and in your quest for knowledge, don't forget MySQL database

modified 1-Aug-19 21:02pm.

Ahmad Alweshahi12-Aug-11 3:01

Ahmad Alweshahi

12-Aug-11 3:01

thanks so much Richard A. Abbottfor ur effort Smile | :)

these sites is very helpful

php and mysql related firefox problem

cjoki16-Aug-11 11:08

cjoki

16-Aug-11 11:08

look at the source code for some open source php projects. As a programmer you are going to read a lot of code, but if you can understand why the programmer designed the app the way he did you will gain quite a bit of info.

Chris J
www.redash.org

doitnow114711-Aug-11 0:46

11-Aug-11 0:46

i don't know why my firefox browser executing mysql query two times. and this is happening only with firefox. i have tested the code with chrome and opera and its working fine.

modified on Thursday, August 11, 2011 9:45 AM

Mohibur Rashid11-Aug-11 18:45

11-Aug-11 18:45

The fact is your browser doesn't execute your query twice. your php/html code has an mistake. different browser handle your mistake html code differently. may be that is why you are seeing result twice.

read your returned code.

Better is post your php code

doitnow114711-Aug-11 19:21

11-Aug-11 19:21

i am posting my mysql query check it if you find any problem?

PHP

$sql_item=mysql_query("select * from add_out_stock where challan_no='$challan_no'");

while($rs=mysql_fetch_array($sql_item))
{

 $cata_name=$rs['catalogue_name'];


 $design_no=$rs['design_no'];


$qty=$rs['quantity'];



  $sql_stock=mysql_fetch_array(mysql_query("select * from  stock where catalogue_name='$cata_name' AND design_no ='$design_no'"));


   $tqty=$sql_stock['roll_no']-$qty;


 $qty= mysql_query("update stock set roll_no='$tqty' where catalogue_name='$cata_name' AND design_no ='$design_no'");



}

when i am using this code it executing $qty two times

Mohibur Rashid11-Aug-11 22:48

11-Aug-11 22:48

What type of request are you sending to server from your broswer?
is it ajax request ? normal request?

doitnow114711-Aug-11 23:18

11-Aug-11 23:18

its a normal request. i am just opening the page in localhost or server.

doitnow114711-Aug-11 23:28

11-Aug-11 23:28

It's VERY frustrating for me , i am facing this problem for past 2 month. but i am not able to find any soln. for it.

Peter_in_278011-Aug-11 23:39

Peter_in_2780

11-Aug-11 23:39

Have you done this[^] yet? It will take a lot less than 2 months.

Peter

Software rusts. Simon Stephenson, ca 1994.

doitnow114711-Aug-11 23:44

11-Aug-11 23:44

what is this? i don't understand. i have tested the code using basic insertion and using some complicated code. but i am not able to find any soln for it.using live http header . but did not find any soln.

Peter_in_278012-Aug-11 0:01

Peter_in_2780

12-Aug-11 0:01

If your SQL code is getting run twice for a particular browser but not others, you need to find out how many HTTP requests and responses are sent. LiveHTTPHeaders is a Firefox plugin, so can't see what happens on other browsers. Wireshark is independent of the browser, so it provides an impartial record of the HTTP traffic. If there is one request/response when it fails, then the problem is on the server side. If there are two, then you need to find out what is causing the second one. Javascript/JQuery in the browser, maybe?

Software rusts. Simon Stephenson, ca 1994.

doitnow114712-Aug-11 0:02

12-Aug-11 0:02

ok let me try this one. than i will reply.
thanks for suggestion.

Mohibur Rashid12-Aug-11 0:12

12-Aug-11 0:12

if you are running the server in Linux then execute the code
and see how its behave:
>php test.php

if you found two entry then something is not right about your php

you also try the same statement in mysql from command prompt

By the way, tell me this. did you installed phpmyadmin?

try to insert from phpmyadmin, if it insert more than one input php, try reinstall it. i am not sure is there any thing to do with your apache installaion and configuration

doitnow114712-Aug-11 0:20

12-Aug-11 0:20

problem is that when i echo my mysql query it show only one time but it execute the code two times. and i have also tested the sql directly into the phpmyadmin but there its working fine.

doitnow114712-Aug-11 2:09

12-Aug-11 2:09

i have found the soln.for the problem. when i have tested the code on other pc with firefox than it running perfectly fine so i have tested the header request and found out that it sending two url request. so i Google it and found out that its happening because of yslow add-on. when i disable it query running fine. thanks to you guys for your valuable suggestion.

doitnow114711-Aug-11 20:53

11-Aug-11 20:53

now i have tested simple php code . this one

PHP

mysql_query("insert into test('1','12345')");

just this code and i am facing the same problem.
it inserting the two times data into the test table.