PHP - Php Multi Pages Function

hello,  is there a way to insert something 17 times into a database and change the 3rd field one at a time (from 1-17)?

Code: [Select]
$sql = "INSERT INTO picks VALUES (
NULL,
'" . mysql_real_escape_string($userid) ."',
'" . mysql_real_escape_string($weekid) ."',
'" . mysql_real_escape_string($pickid) ."'
)";
  mysql_query($sql) or die('Error, Check you fields and try again.');

hi , i want to make 5 forms with 1 submit button , how i do that?
thanks , Mor.

Hi guys
I got an issue that when a link on the site is loading, the other links does not load until the previous is complete but it will work if i try on 2 different browsers. How can i browse multiple links silmultanously?
Thanks

hello all, i have been sitting here googleing and googling but i can't seem to find what im looking for.

i am tring to create a personal site that lets me note services i do for my cars. I have multiple tables (cars, color, mfg, ...) in the main table cars i insted of putting the color black i put and int(11) of 1 which is suppose to "if statement" to the table colors and produce the correct color. same for mfg. although nothing i have tried has helped i always just have the else of the if echoed out.

i have heard of union and join left right i am so unsure of what is need any insite would be useful.

thanks in advance.

Hello friends,

I've tried to search over the Internet but didn't found any tutorial how to do the following :-

let say we have form with input username and input email just 2 field

HTML Code

Code: [Select]
<form>
<table>
<tr>
<td>Username :</td>
<td><input id="username" size="20" type="text" name="username"></td>
</tr>
<tr>
<td>Email :</td>
<td><input id="email" size="20" type="text" name="email"></td>
</tr>
</table>
</form>

As you can see no submit button cause we will only check out if username and/or email is not stored already, by using ajax

My problem : i can only check out for username (1 field) but i can not check for 2 fields or more and i want to know how to apply it for 2 fields (username and email)

Here is my idea for only one field (username)

I'll add in the HTML code  this

Code: [Select]
<td><div id="status"></div></td>
and will add this java code

Code: [Select]
<SCRIPT type="text/javascript">
pic1 = new Image(16, 16);
pic1.src = "loader.gif";
$(document).ready(function(){
$("#username").change(function() {
var usr = $("#username").val();
if(usr.length >= 4)
{
$("#status").html('<img src="loader.gif" align="absmiddle">&nbsp;Checking availability...');
$.ajax({
type: "POST",
url: "check.php",
data: "username="+ usr,
success: function(msg){
$("#status").ajaxComplete(function(event, request, settings){
if(msg == 'OK')
{
$("#username").removeClass('object_error');
$("#username").addClass("object_ok");
$(this).html('&nbsp;<img src="tick.gif" align="absmiddle">');
}
else
{
$("#username").removeClass('object_ok');
$("#username").addClass("object_error");
$(this).html(msg);
}
});
}
});
}
else
{
$("#status").html('<font color="red">The username should have at least <strong>4</strong> characters.</font>');
$("#username").removeClass('object_ok');
$("#username").addClass("object_error");
}
});
});
</SCRIPT>

Explain : it will get the input of username and will send it to check.php

Now check.php code (should have all usernames that will compare with it)

Code: [Select]
<?php
if(isSet($_POST['username']))
{
$usernames = array('john','michael','terry', 'steve', 'donald');
$username = $_POST['username'];
if(in_array($username, $usernames))
{
echo '<font color="red">The username<STRONG>'.$username.'</STRONG> is already in use.</font>';
}
else
{
echo 'OK';
}
}
?>

Now it is very clear , if will automatic check the username

now my problem is how to apply it for also email

common.php
Code: [Select]

<?php
session_start();
header('Cache-control: private'); // IE 6 FIX

if(isSet($_GET['lang']))
{
$lang = $_GET['lang'];

// register the session and set the cookie
$_SESSION['lang'] = $lang;

setcookie("lang", $lang, time() + (3600 * 24 * 30));
}
else if(isSet($_SESSION['lang']))
{
$lang = $_SESSION['lang'];
}
else if(isSet($_COOKIE['lang']))
{
$lang = $_COOKIE['lang'];
}
else
{
$lang = 'en';
}

switch ($lang) {
  case 'en':
  $lang_file = 'lang.en.php';
  break;

  case 'de':
  $lang_file = 'lang.de.php';
  break;

  case 'el':
  $lang_file = 'lang.el.php';
  break;

  default:
  $lang_file = 'lang.en.php';

}

include_once 'languages/'.$lang_file;
?>
ip2locationlite.class.php
Code: [Select]
<?php
final class ip2location_lite{
protected $errors = array();
protected $service = 'api.ipinfodb.com';
protected $version = 'v3';
protected $apiKey = '';

public function __construct(){}

public function __destruct(){}

public function setKey($key){
if(!empty($key)) $this->apiKey = $key;
}

public function getError(){
return implode("\n", $this->errors);
}

public function getCountry($host){
return $this->getResult($host, 'ip-country');
}

public function getCity($host){
return $this->getResult($host, 'ip-city');
}

private function getResult($host, $name){
$ip = @gethostbyname($host);

if(preg_match('/^(?:25[0-5]|2[0-4]\d|1\d\d|[1-9]\d|\d)(?:[.](?:25[0-5]|2[0-4]\d|1\d\d|[1-9]\d|\d)){3}$/', $ip)){
$xml = @file_get_contents('http://' . $this->service . '/' . $this->version . '/' . $name . '/?key=' . $this->apiKey . '&ip=' . $ip . '&format=xml');

try{
$response = @new SimpleXMLElement($xml);

foreach($response as $field=>$value){
$result[(string)$field] = (string)$value;
}

return $result;
}
catch(Exception $e){
$this->errors[] = $e->getMessage();
return;
}
}

$this->errors[] = '"' . $host . '" is not a valid IP address or hostname.';
return;
}
}
?>



index.php

Code: [Select]
<?php
include_once('ip2locationlite.class.php');
 
//Set geolocation cookie
if(!$_COOKIE["geolocation"]){
  $ipLite = new ip2location_lite;
  $ipLite->setKey('*****************');
 
  $visitorGeolocation = $ipLite->getCountry($_SERVER['REMOTE_ADDR']);
  if ($visitorGeolocation['statusCode'] == 'OK') {
    $data = base64_encode(serialize($visitorGeolocation));
    setcookie("geolocation", $data, time()+3600*24*7); //set cookie for 1 week
  }
}else{
  $visitorGeolocation = unserialize(base64_decode($_COOKIE["geolocation"]));
}
var_dump($visitorGeolocation);
?>


im using this http://ipinfodb.com/

in index.php i got this message

array(5) { ["statusCode"]=> string(2) "OK" ["statusMessage"]=> string(0) "" ["ipAddress"]=> string(13) "94.68.211.211" ["countryCode"]=> string(2) "GR" ["countryName"]=> string(6) "GREECE" }

how to switch automatic if GR go to index.php?lang=el
if DE go to  index.php?lang=de etc...

In javascript you can do multiple methods on the same line like:
if(document.getElementById('myElement').className.match(/^[0-9]/)){/*Do something*/}

in that we have getElementById() and match() on the same line, and it works the same as if you were to split them on multiple lines.

Is it possible to do that with php?

For example:
$obj = new MyObject();

$obj->add(2, 3)->to_string();

im trying to do a multi insert form using for loop. the concept is specifying a number and then using it in the for loop. the loop then makes a number of fields depending on the specified number. after that i use another for loop to insert the grouped fields together.

code for specifying desired number
Code: [Select]
<?
if ($_GET[num]=="") {
?><form name="form1" method="post" action="multiup.php?num=1">
<input name="num" type="text" value="10" maxlength="2">
    <input type="submit" name="button" id="button" value="Submit">
</form><? } ?>
Code: [Select]
<? } else { ?><form name="form2" method="post" action="multiup2.php">
<input name="adder" type="hidden" value="">
<input name="num" type="hidden" value="<? echo $_POST[num]; ?>">


code for displaying fields
<?
for ($i=1;$i<=$_POST[num];$i++) {
echo "groupnumber<br />
<input name='eno$i' type='text' value='$i'>
Thumb
<input name='thumb$i' type='text'>
link1<br />

";}
?>

the insert code
Code: [Select]
<? if(isset($_POST['submit']) && ($_POST['submit'] == "Submit"))

{ $con = mysql_connect("lalalalala");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("kiphi_main", $con);

for ($i=1;$i<=$_POST[num];$i++) {
$title="$eno$i";

$sql="INSERT INTO articles (title)
VALUES
('$_POST[$title]')"; }
}
if (!mysql_query($sql,$con))
  {echo testest;}?>

problem is i cant get it to work... should i try a different approach?

How would I go about making a small feature for my moderators that allows them to select multiple threads while viewing a forum then take action? All I need is an idea of how I would do this. Wouldn't I use the explode() function?

Example: http://i490.photobucket.com/albums/rr267/brannenclass/ex.png

Hi people

I need a way to loop through an array where $imgid is some random number assigned to each array element and there are 4 fields id, url, tnurl, caption per array element. I need to extract these 4 fields in the same loop iteration. Thanks

Code: [Select]
$_SESSION['imagegallery'][$imgid]['id'];
$_SESSION['imagegallery'][$imgid]['url'];
$_SESSION['imagegallery'][$imgid]['tnurl'];
$_SESSION['imagegallery'][$imgid]['caption'];
example:
Code: [Select]
$_SESSION['imagegallery'][347]['id'];
$_SESSION['imagegallery'][347]['url'];
$_SESSION['imagegallery'][347]['tnurl'];
$_SESSION['imagegallery'][347]['caption'];
$_SESSION['imagegallery'][892]['id'];
$_SESSION['imagegallery'][892]['url'];
$_SESSION['imagegallery'][892]['tnurl'];
$_SESSION['imagegallery'][892]['caption'];

I am trying to make a database application. I encounterd a problem that. suppose multiple users tryto access data it may cause problem. to clearly understand please see the attachment. How can I resolve it?

Hello   I write following code to get Multiple page of the this site: www.mobile.ir This website have mobile price category .. this category have 42 navigation page. I write following code with curl_multi_init and xpath to get data from Multiple page from category. $ch1= curl_init ("http://www.mobile.ir...es/prices.aspx");
$ch2 = curl_init ("http://www.mobile.ir...hopid=0&page=2");
curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch1,CURLOPT_USERAGENT,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13');
curl_setopt($ch1, CURLOPT_HEADER, 0);
curl_setopt($ch1, CURLOPT_ENCODING, 'UTF-8');
curl_setopt($ch2, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch2,CURLOPT_USERAGENT,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13');
curl_setopt($ch2, CURLOPT_HEADER, 0);
curl_setopt($ch2, CURLOPT_ENCODING, 'UTF-8');

$mh = curl_multi_init();

//add the two handles
curl_multi_add_handle($mh,$ch1);
curl_multi_add_handle($mh,$ch2);

$active = null;
//execute the handles
do {
$mrc = curl_multi_exec($mh, $active);
} while ($mrc == CURLM_CALL_MULTI_PERFORM);

while ($active && $mrc == CURLM_OK) {
if (curl_multi_select($mh) != -1) {
do {
$mrc = curl_multi_exec($mh, $active);
} while ($mrc == CURLM_CALL_MULTI_PERFORM);
}
}



$dom = new DOMDocument('1.0', 'utf-8');
libxml_use_internal_errors(true);
$dom->loadHTML($mrc);
libxml_clear_errors();
$xpath = new DOMXpath($dom);

$data = array();
$table_rows = $xpath->query('//table[@id="price_table"]/tbody/tr'); // target the row (the browser rendered <tbody>, but actually it really doesnt have one)

if($table_rows->length <= 0) { // exit if not found
echo 'no table rows found';
exit;
}
$s = "st\xECna";
foreach($table_rows as $tr) { // foreach row
$row = $tr->childNodes;
if($row->item(0)->tagName != '<tr class="carHeader"> <td>نام کارخانه </td> <td>نام خودرو </td> <td>قیمت نمایندگی (ریال) </td> <td>قیمت بازار (ریال) </td> </tr>') { // avoid headers
$data[] = array(
'Name' => trim($row->item(2)->nodeValue),
'Price' => trim($row->item(4)->nodeValue),

);
}
}

echo '<pre>';
print_r($data);  But don't display data ... when I use curl_init() to get data from one page without problem working and displaying data (name and price) but when use curl_multi_init dont display I really need..

Hi all

I have a menu function which basically produces a menu which looks like

Code: [Select]
Products
    Apple
       iMac
       iPod
       iPhone
    Microsoft
       Windows
       Office
and the code I use is;

THE FUNCTION

function menu($parentID, $mymenu)
{
   $html = "";
   if (isset($mymenu['parentID'][$parentID]))
   {
      $html .= "
      <ul>\n";
       foreach ($mymenu['parentID'][$parentID] as $menu_id)
       {
          if(!isset($mymenu['parentID'][$menu_id]))
          {
             $html .= "<li>\n&nbsp; <a href='/".$mymenu['menu_item'][$menu_id]['url']."'>".$mymenu['menu_item'][$menu_id]['value']."</a>\n</li>";
          }
          if(isset($mymenu['parentID'][$menu_id]))
          {
             $html .= "<li>\n&nbsp; <a href='/".$mymenu['menu_item'][$menu_id]['url']."'>".$mymenu['menu_item'][$menu_id]['value']."</a>";
             $html .= menu($menu_id, $mymenu);
             $html .= "</li>";
          }
       }
       $html .= "</ul>";
   }
   return $html;
}


CREATE MENU CODE

$result = mysql_query("SELECT id, value, url, parentID FROM menu WHERE active = 1 AND deleted = 1 ORDER BY position ASC");
$mymenu = array('menu_item' => array(),'parentID' => array());
while ($menu_item = mysql_fetch_assoc($result))
{
$mymenu['menu_item'][$menu_item['id']] = $menu_item;
$mymenu['parentID'][$menu_item['parentID']][] = $menu_item['id'];
}

echo menu(0, $mymenu);


The problem I have is the URLS, at the moment the menu URLS are outputted as

Code: [Select]
Products  -  http://localhost/Products
     Apple  -  http://localhost/Apple
       iMac  -  http://localhost/iMac
       iPod  -  http://localhost/iPod
But I need to alter my function so that URLS are outputted as

Code: [Select]
Products  -  http://localhost/Products
     Apple  -  http://localhost/Products/Apple
       iMac  -  http://localhost/Products/Apple/iMac
       iPod  -  http://localhost/Products/Apple/iPod
Is this at all possible?

Thanks very much everyone

John

Hello everebody,
i have code to updare many rows at once using "for".
when i click submit button nothing happens, where is the error in my code? thank you very much for your help

 <?php
$hoster="db.mkq.de";
$username="dbxxxxxx";
$password="xxxxxx";
$db_name="xxxxxx";
mysql_connect("$hoster", "$username", "$password")
or die("cannot connect");
mysql_select_db("$db_name") 
or die("cannot select DB");
$sql="SELECT * FROM gbook";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>www</strong></td>
<td align="center"><strong>email</strong></td>
<td align="center"><strong>pwd</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td align="center">
<input name="id[]" type="text" id="id" value="<? echo $rows['id']; ?>">
</td>
<td align="center">
<input name="www[]" type="text" id="www" value="<? echo $rows['www']; ?>">
</td>
<td align="center">
<input name="email[]" type="text" id="email" value="<? echo $rows['email']; ?>">
</td>
<td align="center">
<input name="pwd[]" type="text" id="pwd" value="<? echo $rows['pwd']; ?>">
</td>
</tr>

<?php
}
?>

<tr>
<td colspan="4" align="center"><input type="submit" name="submit" id="submit" value="update"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>

<?php

if($submit)
{
for($i=0;$i<$count;$i++)
{
$sql1="UPDATE gbook SET www='$www[$i]', email='$email[$i]', pwd='$pwd[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1)
{
header("location:editmulti3.php");
}
mysql_close();
?>