kbloem

Found sqlbuddy

Hello, i have a simple mysql database and i use some forms to write data to the databases. This is done by some novice users, wich i am myself too. However i dont want them to login to phpadmin when they made a typo or want to delete a record. Is there a simple tool wich i can install on the webserver that gives a simple overview of a table with a delete and edit button? I tried looking for some but i cannot find it... Thanks!

Vardump gives me this... it only displays the last shop...

I think we are getting there... however, it now only shows one shop?

Well i am very thankfull for you to help.... I changed the code a bit so the brackets are correct... <?php //require_once('SoapClientAuth.php'); date_default_timezone_set('Europe/Amsterdam'); ini_set("soap.wsdl_cache_enabled", "0"); #- verbinden met WSDL $client = new SoapClient("http://www.beslist.nl/api/v2/wsdl/products.wsdl", array('login'=> "Gamepedia", 'password'=> "gamP8853")); $productitemsearch_args = array('input' => array( 'cat_id' => 4, 'item_id' => 71267 , 'shopinfosort'=> "PRICE", 'shopinfo'=>"TRUE" )); $productitemsearch= $client->ProductItemSearch( $productitemsearch_args ); foreach ($productitemsearch->ProductItemSearchResult->productdata as $key => $att) { if(!is_object($att)) { echo "$key --- $att<br>"; } else { foreach($att->Shops as $shop) { $shops[$shop['shop_id']] = array('name'=>$shop['shopname'], 'logo'=>$shop['shoplogo'], 'levertijd'=>$shop['levertijd'],'price'=>$shop['price'],'postage'=>$shop['postage'], 'cp_type'=>$shop['cp_type'], 'product_url' => $shop['producturl']); echo "Shops ---<br>"; } } } foreach ($shops as $id=>$shop_info) { echo "---- Shop ID $id<br>"; } foreach ($shop_onfo as $key=>$value) { echo "---- ---- $key --- $value<br>"; } //foreach ($productitemsearch->ProductItemSearchResult->productdata as $key => $att ){ //echo "$key --- $att<br>";} //print_r ($productitemsearch); ?> But i still get an error...

This is what i get...

Wel i actually got a bit further... This is my code now... It gives me the following output wich i now have to try and get in a html table

Thanks, there was a different IP talking to de server, i guess a gateway. They whitelisted that and now it seems to work. But my code does not. Below is de code i have now... i get the following error...

I've done it different now but still an issue...

Anyone?

Hi, i have a supplier that gave me an wsdl link. To get productinfo they gave me this description. I had to translate it so i'm sorry if its not clear... Now, i am a complete noob with php but what i have is this. Don't laugh at me. I am new at this I hope someone can help. Once i get one value and a correct connection i should get on my way. Right now i get an empty page.

Nope, it keeps giving me this error... Fatal error: Call to undefined function doPagination() in C:\wamp\www\test\result.php The folder on my home server is identical to the folder on the webserver of my hostingprovider....

Hi i have a piece of php code wich includes a pagination.class.php. That file is in the same folder and when i execute it gives me a Fatal Error for undefined function doPagination(). When i upload the contents of this folder to my webhoster everything is ok so i suspect there is something wrong in my php.ini or i have to enable something. Does someone know what? I use wamp 2.0i and i tested it on 4 different workstations. I can email the files if someone wants to test. You also get a nice search function [attachment deleted by admin]

Hmm i can't figure this out... Below you see my code. I have 8 results from the query and i have the pegination set to max 2 values. It has 8 result so it devides them into 4 pages. But all the results are on the first page so the second third and fourth page are empty. Why is that? <?php if (isset($_POST['model_zoeken'])) { $con = mysql_connect("localhost","admin",""); if (!$con) { die('Could not connect: ' . mysql_error()); } if (!(isset($pagenum))) { $pagenum = 1; } mysql_select_db("produkten", $con); $data = mysql_query("SELECT * FROM eigenschappen") or die(mysql_error()); $rows = mysql_num_rows($qry); $page_rows = 2; $last = ceil($rows/$page_rows); if ($pagenum < 1) { $pagenum = 1; } elseif ($pagenum > $last) { $pagenum = $last; } $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; $data_p = mysql_query("SELECT * FROM eigenschappen $max") or die(mysql_error()); $qry = "SELECT * FROM eigenschappen WHERE 1=1"; if (isset($_POST['prod_name']) && trim($_POST['prod_name']) != "") { $qry .= " AND prod_name='" . mysql_real_escape_string($_POST['prod_name']). "'"; } "'"; } $result = mysql_query($qry) or die(mysql_error()); $teller = 0; $rijen = 0; echo '<table border="0"><tr>'; while($row = mysql_fetch_array($result)) { echo' <td width="160" align="center"> <a href="'.$row['website'].'"></a><img src="'.$row['prod_img'].'"> </td> <td width="165" valign="top"><br /><br />Name: '.$row['prod_name'].'<br/><br/>Website: <a href="'.$row['website'].'" target="_blank">'.$row['website_naam'].'</a> </td>' ; $teller = $teller + 1; $rijen = $rijen + 1; if ($teller == 3 || $rijen == 3){ echo "</tr><tr>"; $rijen = 0; $teller = 0; } } echo '</tr></table>'; echo '<br />'; echo " --Page $pagenum of $last-- <p>"; if ($pagenum == 1) { } else { echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> "; echo " "; $previous = $pagenum-1; echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> "; } echo " ---- "; if ($pagenum == $last) { } else { $next = $pagenum+1; echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> "; echo " "; echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> "; } } ?>

Ok to be clear, this is what i have echo'<table border="0"> <tr> <td> <a href="'.$row['website'].'"> <img src="'.$row['prod_img'].'"> </td> <td> '.$row['prod_name'].'<br/><br/> <a href="'.$row['website'].'">'.$row['website'].' </td> </tr> </table> ';}} Now it gives the next result below the other and i want i to give the result in 3x3..... Result 1 , Result 2, Result 3 Result 4 , Result 5, Result 6 Result 7 , Result 8, Result 9 I hope it's clear now...