Linux, Apache, MySQL, PHP Discussion Boards

AkkiMo2-Jan-13 4:03

2-Jan-13 4:03

Hi,

I have a table fetched using ajax, according to the choice made from my dropdown menu. In the table I have some input fields. I need to save my inputs in the table while submitting it.
If I check the source code of the page I cannot find the table fields to post using $_post since ajax is used. I am really new to ajax. Can anybody please tell me how I can submit these table input values in PHP?

Thanks in advance

I have a trouble about query_insert().

陳建勳24-Dec-12 1:31

陳建勳

24-Dec-12 1:31

I want to make a messageboard with php.
but I cant't insert data to database.
I dont know what's wrong in my code???
Can someone help me please?

HTML

<!DOCTYPE  HTML>
<html>
<head>
<title> 留言板 </title>
</head>


<body>
<form action="insert.php" method="get">
請輸入名稱: <input type="text" name="name" />
請輸入標題: <input type="text" name="title" />
請輸入留言: <input type="text" name="message"   />
請輸入電子郵件: <input type="text" name="email" />
<input    type="submit"  value="送出留言" name="post"  />
</form>

</body>
</html>

PHP

<?php
//This is insert.php

require_once("connectdb.php");// It is success!!


if(isset($_GET["name"])!=""){
	$query_insert = "INSERT INTO '1100108128'.'MB'
	('USER','TITLE','MESSAGE','TIME','EMAIL')
VALUES (";$query_insert .= "'".$_GET["name"]."',";
	$query_insert .= "'".$_GET["title"]."',";
	$query_insert .= "'".$_GET["message"]."',";
	$query_insert .= "NOW(),";
	$query_insert .= "'".$_GET["email"]."')";
mysql_query($query_insert);
header("Location:Messageboard.php");
}
 ?>

Re: I have a trouble about query_insert().

ziggyfish6-Jan-13 12:36

ziggyfish

6-Jan-13 12:36

replace

mysql_query($query_insert);

with

mysql_query($query_insert) or die('Error occured: ' . mysql_error());

Than reply with the output.

without refresh the page using Submit button / Button how can i do process the dtabase operations ?

vinay digil16-Dec-12 7:10

vinay digil

16-Dec-12 7:10

navigate data from database in webpage without page refresh

Re: without refresh the page using Submit button / Button how can i do process the dtabase operations ?

Killzone DeathMan19-Dec-12 23:12

Killzone DeathMan

19-Dec-12 23:12

I make a little login example...

In the index.php :

HTML

<html>
  <head>
    <!-- INCLUDE HERE THE JQUERY 1.7.2 LIBRARY -->
  </head>
  <body>
    Username:<input id="input-username" type="text" maxlength="100" />
    Password:<input id="input-password" type="password" maxlength="16" />
    <input id="btn-ok" type="button" value="OK" />
  </body>
  <script type="text/javascript">
    $('#btn-ok').click(function() {
      var DataToSend = new Object();

      DataToSend.username = $('#input-username').val();
      DataToSend.password = $('#input-password').val();     

      $.post('validate.php',DataToSend,function(data) {
        
        if(data == 'ok')
          alert('Login OK!');
        else
          alert('Login ERROR!');

      });
    });
  </script>
</html>

You just make a post to a php file "validate.php" and there you validate the login, and make querys to the DataBase and return a value, and you are doing that all without refresh the page!

Any question, add me on gtalk: miguel.poegel@pears.fr
Regards,
KZ

how can Multiple selected List box items move from one list box to another list

vinay digil16-Dec-12 7:06

vinay digil

16-Dec-12 7:06

ques 1: Php how can Multiple selected List box items move from one list box to another list box?

ques 2:Instead of Submit button how can i use Button or Any thing which do process like insert / update / delete /select without refresh the page?

navigate the data without page refresh how can i achieve in easy way?

Re: how can Multiple selected List box items move from one list box to another list

Killzone DeathMan19-Dec-12 22:57

Killzone DeathMan

19-Dec-12 22:57

You can use javascript... without refresh the page...

how to get data when using header('location:'. $url) ? help me

aa_zz26-Nov-12 4:29

aa_zz

26-Nov-12 4:29

hi all.
I want get data form url when use header('location:'.$url) then it rederect to another url.
how to get data when using header('location:'.$url) ???

thanks

nothing

Re: how to get data when using header('location:'. $url) ? help me

Killzone DeathMan19-Dec-12 22:54

Killzone DeathMan

19-Dec-12 22:54

In one page you use:
header('Location: ' . $url);
Suppose $url = 'www.example.com/abcd.php?action=register';
And in the "abcd.php" page just do a $_GET['action'] to get the action!
And then you do something, in this case you show a div to register!
Hope I can help,
KZ

Re: how to get data when using header('location:'. $url) ? help me

Keanu L18-Jan-13 16:29

Keanu L

18-Jan-13 16:29

what about using :

PHP

$content = include '${url}';header("location:antoher url");

Starting Point

silentspeaker19-Nov-12 23:43

silentspeaker

19-Nov-12 23:43

From where to start programming on Open Source?

Re: Starting Point

User 171649219-Nov-12 23:58

User 1716492

19-Nov-12 23:58

From your posting in a thread below, you are at the beginner level in the learning phase. It will take you quite a while before you become competent. I would suggest you grab hold of this book and work through it doing some of the exercises.

Beginning PHP and MySQL: From Novice to Professional by W. Jason Gilmore

You could also visit the nettuts website, search for beginning php, and view their video tutorials.

When you feel you have reached some maturity in this PHP/MySQL subject, go look at, for example, SourceForge[^] who have a number of Open Source projects under some level of development.

modified 1-Aug-19 21:02pm.

Re: Starting Point

silentspeaker20-Nov-12 0:07

silentspeaker

20-Nov-12 0:07

nettuts website

???

Re: Starting Point

User 171649220-Nov-12 0:21

User 1716492

20-Nov-12 0:21

You could easily find the nettuts website by asking our friends at Google. But as you clearly didn't, here is their website's front door to all of their offerings. http://net.tutsplus.com/[^]

Here is their first video in the "diving into PHP" video series http://blog.themeforest.net/tutorials/diving-into-php-video-series/[^]

modified 1-Aug-19 21:02pm.

PHP, MySQL and Apache

silentspeaker10-Nov-12 19:38

silentspeaker

10-Nov-12 19:38

How to Install PHP

, MySQL and Apache

on my Machine?

Re: PHP, MySQL and Apache

Richard MacCutchan10-Nov-12 21:39

Richard MacCutchan

10-Nov-12 21:39

You can get PHP from http://www.php.net/[^]. No doubt you can find the other two for yourself.

One of these days I'm going to think of a really clever signature.

Re: PHP, MySQL and Apache

Senaid Maksumic11-Nov-12 11:15

Senaid Maksumic

11-Nov-12 11:15

Install XAMPP or WAMP...

Re: PHP, MySQL and Apache

silentspeaker12-Nov-12 19:19

silentspeaker

12-Nov-12 19:19

WAMP is enough for the whole development envirnment?
I am on the beginning level, so want to know more about it.

Re: PHP, MySQL and Apache

Senaid Maksumic13-Nov-12 10:33

Senaid Maksumic

13-Nov-12 10:33

Yes! WAMP is enough, I'm not familiar with WAMP, becouse I'm using XAMPP, and IIS with installed PHP.

Re: PHP, MySQL and Apache

Ngobi Arthur 20135-Jan-13 8:52

Ngobi Arthur 2013

5-Jan-13 8:52

Yes, WAMP is good for local Server. But we shall also need the server-side Application language[PHP] with the Database for storing captured Information.

Re: PHP, MySQL and Apache

vbmike14-Dec-12 4:37

vbmike

14-Dec-12 4:37

Go to this page here and it gives a full rundown of how-to for differing applications. XAMPP or WAMP products are very good. I have tried XAMPP and it installs very easily and sets up very well. Easy to use and learn. It installs mysql, php, apache etc for you all at once as I assume WAMP does also. To answer one of your posts, either product provides a whole package for you to begin.

vbmike

Re: PHP, MySQL and Apache

Manish Choudhary .NET expert14-Dec-12 18:45

Manish Choudhary .NET expert

14-Dec-12 18:45

Well if you are using Windows then you can install wamp or Xampp.

C#, VB.NET,ASP.NET DEVELOPER

Re: PHP, MySQL and Apache

Zamshed Farhan12-Jan-13 3:02

Zamshed Farhan

12-Jan-13 3:02

What's more convenient you think - WAMP or XAMPP?

Re: PHP, MySQL and Apache

ronakT26-Jan-13 5:32

ronakT

26-Jan-13 5:32

install Wamp server, it has MySQL and Apache. and it installs setting automatically. you need only to work on PHP.

can not get data from url when use method post paramater using php. because page use token. please me

aa_zz4-Nov-12 22:22

aa_zz

4-Nov-12 22:22

Dear All.
I want get data from url, I use HTTP_Request to post parameter and get data from url. If url not using token then get OK, but If url using token then get data not OK.

Please help me get data from url have use token.
thanks very much.

nothing

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.