php - Creating a Dynamic Array and returning array from with-in a function -

-

i'm trying write function selects contents database. problem have lack of understanding of arrays , returning variables functions.

i've written function seem going round in circles how build array , return function.php.

main php file. (labels , names have been changed protect innocent.)

<?php  //include '../sb_mysqli_connect.php';//connect database include 'functions.php' ; //include functions list  $username = 'foo'; $password = 'bar';   $fields = array( array('username', $username), array('password', $password)); //prep's     array multiple statements sbpolldb ("users",$fields, null, 1, null); //function sbpolldb($sbbeta, $sbbecon, $sbbeorder, $sbbelimit, $sbbegroup)  echo $tablex['row_name_y']; ?>

the function.php file

<?php     function sbpolldb($sbbeta, $sbbecon, $sbbeorder, $sbbelimit, $sbbegroup){  //sbbeta = table name, sbbecon = condition, sbbeval = value, sbbesort = sort value, sbbelim -          include '../sb_mysqli_connect.php';//connect database         if (empty($sbbeorder)) {             $sbbeotemp="";         } else {             $sbbeotemp=" order ".$sbbeorder;         } //check if order null         if (empty($sbbelimit)){             $sbbeltemp="";         } else {             $sbbeltemp=" limit ".$sbbelimit;         } //check if there's limit set         if (empty($sbbegroup)){             $sbbegtemp="";         } else {//$ssbegtemp=' group '.$sbbegroup;             $count = sizeof($sbbegroup);             $sbbegtemp = " group ";             //loop create conditons             ($i = 0; $i < $count; $i++) {                 $value = $sbbegroup[$i];                 $sbbegtemp = $sbbegtemp.$value;                 if ($i < ($count -1 )){                     $sbbegtemp = $sbbegtemp.' , ';                 }             };         }         if (empty($sbbecon)){             $sbbectemp='';         } else {             $count = sizeof($sbbecon);             $sbbectemp = 'where ';             //loop create conditons             ($i = 0; $i < $count; $i++) {                 $value = $sbbecon[$i];                 $sbbectemp = $sbbectemp.$value[0]." ="."'".$value{1}."'"; // &#39 code apostraphe                 if ($i < ($count -1 )){                     $sbbectemp = $sbbectemp.' , ';                 }             };         }         $sbbesql = "select * ".$sbbeta.' '          .$sbbectemp         .$sbbegtemp         .$sbbeotemp         .$sbbeltemp; //&#34 code speach marks         mysql_select_db("database1");         $result = mysql_query($sbbesql, $sbbedbc) or die($sbbesql."<br/><br/>".mysql_error());;         $temp = mysql_fetch_array($result, mysql_assoc);         // build array here dynamically $sbbeta content variable name.         // how return array name no longer $temp?     } ?>

the construction of sql works, believe dynamic variables created using $$label, declares new variable content of old one. apply arrays well? i'm building web application doing lot of database queries , wanted shorten repetition of code.

you can return array in function.php(by adding return statement in last line as):

return $temp;

so retrieve returned value in calling function,

$tablex=sbpolldb ("users",$fields, null, 1, null);  echo $tablex['row_name'];

Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused...
Read more

What is the difference between data design and data model(ERD) -

-
i have google question , find answer in day. know, data design many many table have list column,and mark pk , fk. why er-diagram have find this? data design process of designing database. main output of data design detailed logical data model of database. some people data design includes of needed logical , physical design choices , physical storage parameters needed generate design in data definition language. technically, database analysis, database analysts (dbas) trained do. while person can both data design , database analysis, these 2 different tasks. data design models data. database analysis takes model , applies 1 or more database engines (relational, hierarchical, nosql). a logical data model 1 of main outputs of data design. data model represented entity relationship diagram, or er diagram.
Read more

ios - Can NSManagedObject conform to NSCoding -

-
i need transfer single object across device. right converting nsmanagedobject dictionary , archiving , sending nsdata. upon receiving unarchiving it. transfer nsmanagedobject archiving , unarchiving instead of creating intermediate data object. @interface test : nsmanagedobject<nscoding> @property (nonatomic, retain) nsstring * title; @end @implementation test @dynamic title; - (id)initwithcoder:(nscoder *)coder { self = [super init]; if (self) { self.title = [coder decodeobjectforkey:@"title"]; //<crash } return self; } - (void)encodewithcoder:(nscoder *)coder { [coder encodeobject:self.title forkey:@"title"]; } @end nsdata *archivedobjects = [nskeyedarchiver archiveddatawithrootobject:testobj]; nsdata *objectsdata = archivedobjects; if ([objectsdata length] > 0) { nsarray *objects = [nskeyedunarchiver unarchiveobjectwithdata:objectsdata]; } the problem above code is. crashes @ self.title in initwithcoder sa...
Read more