Search the Community

How do I export oracle database from my server to my local computer? I have tried using navicat client but nothing got exported but I can connect, view, edit,.. database using navicat.

Hi folks, I am having problem with my project. I need to show the corresponding values from the populated drop down list. so in my table i have this. I need to show the quantity from the head_mark i chose from the populated drop down list. Please help me <?php $paint_parse = oci_parse($conn, 'SELECT HEAD_MARK FROM PAINTING ORDER BY REV_DATE'); oci_define_by_name($paint_parse, 'HEAD_MARK', $head_mark); oci_execute($paint_parse, OCI_DEFAULT); ?> <section> <div class="row"> <div class="col4 first"> <label for="headmark" class="lbl-text tleft">HEADMARK :</label> </div><!-- end .col4 section --> <div class="col8 last"> <label for="headmark" class="lbl-ui select"> <select id="headmark" name="headmark" onChange=""> <?php while (oci_fetch($paint_parse)){?> <option value="headmark_sel" id="headmark"> <?php echo "$head_mark"; ?></option> <?php } ?> </select> </label> </div> </div> </section> <section> <div class="row"> <div class="col4 first"> <label for="lnames" class="lbl-text tleft">Total Quantity:</label> </div><!-- end .col4 section --> <div class="col8 last"> <label class="lbl-ui"> <!-- Show Corresponding head mark quantity in this field --> <h1><?php $qty_parse ?></h1> </label> </div><!-- end .col8 section --> </div><!-- end .row section--> </section>

Hi folks, Is there any specific ORACLE method to show the traffic, data changes and specific user that logged in and made changes ? I need help with this since i need to show the user WHAT, WHEN, and WHO made the changes with the database values. Can I monitor this traffic daily and make some kind of report with PHP ? Any help would be really appreciated Thanks.

Hi Folks, I am new here and I am building a dummy business application for my school project. So I am still learning from you guys and please guide me with what i have right now. So, I want to populate a dropdown list with rows that exists in my Oracle DB and that would be my COMPONENT_ID column. When i pull that component ID column and select one of them, I need to show the corresponding data that show progress from that particular item. So when i choose one of the ID, I need to show the rest of the column that is in the same row with that particular item. What i have right now is this. I am assuming this will only pull the component ID but it doesnt work either. So please help me... <?php $paint_parse = oci_parse($conn, 'SELECT HEAD_MARK FROM FABRICATION'); oci_execute($paint_parse, OCI_DEFAULT); // Count the number of occurence inside the table $result = array(); $numrows = oci_fetch_all($paint_parse, $result, null, null, OCI_FETCHSTATEMENT_BY_ROW); while ($row = oci_fetch_array($paint_parse, OCI_ASSOC)!= false){ $value = $row['HEAD_MARK']; echo "<option value = $value>$value</option>"; } ?>

Hi, I'm currently using date picker for selecting event date in my form codes. But I have problem when trying to insert to the database. The date picker display value as this, October 9th, 2013 I try to convert it using this code from another forum, $eventDate=$_POST['eventdate']; //check date format here before continuing. list($day,$month,$year)=explode('/',$eventDate); $timestamp=mktime(0,0,0,$month,$day,$year); $final_date=date('Y-m-d',$timestamp); echo $final_date; // to see the conversion and this is what i get back Warning: mktime() expects parameter 5 to be long, string given ..................... 1970-01-01 Please help me, I want to get this value -----> 09/10/2013

I have form where user have to fill in and upload several file. I plan to keep the files in upload folder under the ID of user (eg: ../upload/userID/filename) and save each dir of files in database so that it is easier (?) to retrieve later. But, since I am not familiar with the process, I kind of stuck with the codes. student_newSubmission.php (since it is long forms/codes, I put several only) <form action="student_newSubmission.php" method="post" enctype="multipart/form-data"> <table width="1023" cellpadding="2" cellspacing="2"> <tr> <td width="160"><strong>Full Name : </strong></td><td colspan="3"><?php echo $row['STDNAME']; ?><style="text-transform: uppercase" required value="" /></td> </tr> <tr> <td><strong>Sponsor : </strong></td><td width="374"><input name="sponsor" type="text" size="50" style="text-transform: uppercase"></td> <td><strong>Admission Date : </strong></td><td width="309"><?php echo $date; ?> <input type="hidden" name="admissionDate" id="admissionDate" value="<?php $date;?>" style="text-transform: uppercase" required value="" /></td> </tr> <tr> <td><strong>Matric No : </strong></td><td width="374"><?php echo $row['MATRICNO']; ?> <input type="hidden" name="matricNo" id="matricNo" value="<?php echo $row["MATRICNO"]; ?>" style="text-transform: uppercase" required value="" /></td> <td><strong>Email Address :</strong></td><td width="309"><?php echo $row['EMAIL']; ?> </td> </tr> . . . . . </table> . . . . <fieldset style="width:500px; background-color: #FFC"><legend align="center" style="font-size:24px">Upload file</legend> <p style="color:#F00"> ( Please take note to name your files accordingly and save as .pdf or .doc ) </p> <table width="809" cellpadding="2" cellspacing="2"> <tr> <td width="252"><label for="file">Acceptance Letter from Publisher:</label></td> <td width="541"><input type="file" name="file" id="acceptletter" onchange=checkFile(this) required value=""></td> </tr> <tr> <td width="252"><label for="file">Turnitin Similarity Report :</label></td> <td width="541"><input type="file" name="file" id="turnitin" onchange=checkFile(this) required value=""></td> </tr> <tr> <td width="252"><label for="file">Paper Indexing :</label></td> <td width="541"><input type="file" name="file" id="paperindex" onchange=checkFile(this) > <br />/ Link : <input type="text" name="paperindexurl" size="30" /></td> </tr> <tr> <td width="252"><label for="file">Publisher's Reviewers Report :</label></td> <td width="541"><input type="file" name="file" id="reviewerReport" onchange=checkFile(this) required value=""></td> </tr> </table></fieldset> this is what I already try... edit from what I found in the forum. if(isset($_POST['submit']) && !empty($_POST['submit'])) { $sponsor = $_POST['sponsor']; $admissionDate = $_POST['admissionDate']; $matricNo= $_POST['matricNo']; . . . $paperindexurl= $_POST['paperindexurl']; $submittedVersionurl= $_POST['submittedVersionurl']; $confPaperurl=$_POST['confPaperurl']; if (isset($_FILES['file']) && !empty($_FILES['file'])) { $num_files = count($_FILES['file']); for($x =0; $x < $num_files; $x++) { $filename = $_FILES['file']['name'][$x]; $tempName = $_FILES['file']['tmp_name'][$i]; $allowed_ext = array ('doc', 'docx','pdf'); $file_ext = strtolower(end(explode('.', $filename))); if ((filesize($filename) > 1048576) && (in_array($file_ext, $allowed_ext) == false)) { header('location: student_newSubmission.php?error=6'); exit(); } elseif ($_FILES['file']['error'][$x] == UPLOAD_ERR_OK) { $saveDirectory = '../upload/'.$matricNo.'/'; if (@move_uploaded_file($tempName, $saveDirectory . $fileName)) { echo 'File Successfully Uploaded!'; } else { echo 'There was an error whilst uploading the file.'; } } } } $query= "INSERT INTO submission VALUES(seq_subID.nextval, '$matricNo', '$sponsor', '$admissionDate', '$programme', '$sem', '$field', '$supervisor', '$cosupervisor', '$papertitle', '$author', '$conftitle', '$organizer', '$address', '$tel', '$venue', '$confDate', '$fee' , .................."; $parse= oci_parse($conn, $query)or die(oci_error()); $exe= oci_execute($parse); if ($exe == 1) { header('location:homeStudent.php'); echo '<script type="text/javascript">'; echo 'alert ("Successfully upload your form!")'; echo '</script>'; } else { echo '<script type="text/javascript">'; echo 'alert("There was an error while uploading your form. Please try again.")'; echo '</script>'; } } and here is submission table.. subID NUMBER(4) NOT NULL, matricNo VARCHAR2 (10)NOT NULL, sponsor VARCHAR2(10), admissionDate DATE NOT NULL, programme VARCHAR2(10), sem VARCHAR2(4) NOT NULL, field VARCHAR2(10) NOT NULL, supervisor VARCHAR2(50) NOT NULL, cosupervisor VARCHAR2(50) NOT NULL, papertitle VARCHAR2(50) NOT NULL, author VARCHAR2(150) NOT NULL, conftitle VARCHAR2(50) NOT NULL, organizer VARCHAR2(20), orgaddress VARCHAR2(50), orgtel VARCHAR2(20), venue VARCHAR2(30), confDate DATE, fee NUMBER(10), file1 VARCHAR2(30) NOT NULL, file2 VARCHAR2(30) NOT NULL, file3 VARCHAR2(30), indexurl VARCHAR2(30), file4 VARCHAR2(30) NOT NULL, submitversionurl VARCHAR2(30) NOT NULL, confpaperurl VARCHAR2(30), file5 VARCHAR2(30) NOT NULL, file6 VARCHAR2(30) NOT NULL); So far, is it correct what I am doing.? From the code above, nothing happen when I try to submit. Not even check the file. Please anyone show me the way.. I really don't know how to proceed.

Hi, I don't know how to solve this problem. Please help me. <?php if(isset($_COOKIE['ID_site']) && isset($_COOKIE['Pass_site'])) { $_SESSION['id'] = $_COOKIE['ID_site']; $_SESSION['password'] = $_COOKIE['Pass_site']; if(isset($_SESSION['id'])) { $id = $_SESSION['id']; $pass = $_SESSION['password']; echo $id; $query2 = oci_parse($conn,"SELECT * FROM user1 WHERE id ='".$id."'")or die(oci_error()); $check2 = oci_execute($query2); echo $check2; while($info2=oci_fetch_array(query2,OCI_ASSOC+OCI_RETURN_NULLS)) //the error come from this line { echo $info2[0]; //if the cookie has the wrong password, they are taken to the login page if (($pass != $info2['PASSWORD']) || ($info2['ROLE'] != 'admin') ) { header('Location: index.php?error=4'); } //otherwise they are show the admin home else { ?

Hello. I am trying to connect my php page to an Oracle database, without success until now. I tried everything I could find on google, but nothing.... We have enabled oci8 in php: oci8 OCI8 Support enabled Version 1.4.7 Revision $Id: bf2eaf558b050b6d2e6d098bed6345af7e842ea4 $ Active Persistent Connections 0 Active Connections 0 Oracle Run-time Client Library Version 11.2.0.3.0 Oracle Instant Client Version 11.2 Temporary Lob support enabled Collections support enabled Directive Local Value Master Value oci8.connection_class no value no value oci8.default_prefetch 100 100 oci8.events Off Off oci8.max_persistent -1 -1 oci8.old_oci_close_semantics Off Off oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20 I tried the following connection attempts - 3 versions (the server is not on the same machine as the oracle db): <?php //Putenv("NLS_LANG=SPANISH_SPAIN.WE8ISO8859P15"); $db="(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=$GLOBALS[192.168.1.102])(PORT=$GLOBALS[1521]) ) ) (CONNECT_DATA=(SID=$GLOBALS[***])) )"; $conn = OCILogon($GLOBALS['user'],$GLOBALS['pass'],$db); if (!conn) { $e=oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); echo $e; echo "dfsdf<br />"; return FALSE; } else echo "success"; return $conn; } /* $db='(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ***) ) )'; $connection = oci_connect('user', 'pass', $db); if (!$connection) { $e = oci_error(); echo htmlentities($e['message']); } */ ?> <?php /* function oracle_connect() { $user='user'; $pwd='pass'; $server='192.168.1.102'; // or ip $port='1521'; $sid='****'; // service name $charset='WE8ISO8859P1'; // change to whatever is needed $conn=oci_connect($user,$pwd,'//'.$server.':'.$port.'/'.$sid,$charset); if (!conn) { $e=oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); echo $e; echo "dfsdf<br />"; return FALSE; } else echo "success"; return $conn; } $s = oci_parse($conn, "select * from 303"); */ ?> I get only a blank page! I`m not an IT guy but I can work well with PHP and MySQL...but Oracle gives me headaches... Any ideas? Anyone?!

so how to convert this oracle timestamp, without using any oracle function, just pure php fucntions to manipulate this oracle timestamp? like e.g 12-JAN-13 12.00.00.000000000 AM if i do echo date('F d,Y',strtotime($oracleTimeStamp)); it produces January 01,1970 and if i do echo strtotime($oracleTimeStamp); it produces nothing at all what's the proper way without using any oracle function at all, just pure php to manipulate this oracle timestamp?

Please help! i can't connect codeigniter to Oracle I am trying to connect Codeigniter to Oracle 11g, here are my settings Settings in database.php: $active_group = 'default'; $active_record = TRUE; $db['default']['hostname'] = "//localhost/"; $db['default']['username'] = 'xxxxxxx'; $db['default']['password'] = 'xxxxxxx'; $db['default']['database'] = 'orcl'; $db['default']['dbdriver'] = 'oci8'; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = TRUE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ''; $db['default']['char_set'] = 'utf8'; $db['default']['dbcollat'] = 'utf8_general_ci'; $db['default']['swap_pre'] = ''; $db['default']['autoinit'] = TRUE; $db['default']['stricton'] = FALSE; Note: I added the C:\instantclient_11_2 to environment variable to PATH. Oracle : oracle port number: 1521 oracle hostname: Home-pc database name: orcl Only when I run my CodeIgniter login code it shows this error message: A Database Error Occurred Unable to connect to your database server using the provided settings. Filename: D:\xampp\htdocs\ci\system\database\DB_driver.php Line Number: 124 But I can connect to Oracle when I run a simple php code like: <?php $conn = oci_connect("xxxxxx", "xxxxxx",""); if (!$conn) { echo "Not connected!"; } else echo "yahooooooooo!!!!!!!!!!"; ?> Result: yahooooooooo!!!!!!!!!!